![]() | ![]() | ![]() | ![]() | ![]() |
Calling a DB2 stored procedure on z/OS might result in an infinite loop requiring that the job be cancelled. This seems to occur when there are parameters that are of a decimal data type but that alone does not cause the infinite loop. It appears to be a result of the number of parameters. There is no current workaround for this issue.
Also, if a schema is not specified during the call to a stored procedure, there is a risk that a SELECT statement that the code executes against SYSIBM.SYSPARMS might retrieve the wrong data. The only workaround is to add the schema to the stored procedure call.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.1 TS1M0 | 9.2 TS1M0 |