Problem Note 59257: The SYSDBRC macro variable does not contain the return code from the last step against a database
When you use SAS/ACCESS® software to access your database management system (DBMS) data, the macro variable SYSDBRC shows the last DBMS-specific return code that was generated. You might encounter a problem under z/OS in which running a step with BULKLOAD=YES against a DB2 table does not surface the return code to the job. In this scenario, the macro variable SYSDBRC is 0 and the return code for the job is also 0. When you encounter this problem, you must look at the output of the LOAD utility to determine whether the last step failed.
There is no workaround for this issue.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.3 TS1M2 | 9.4 TS1M4 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-11-07 09:19:07 |
| Date Created: | 2016-10-28 09:39:53 |
