SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 33912: The SYSDBRC and SYSDBMSG macro variables are not populated after a bulk-loading failure

DetailsHotfixAboutRate It

When bulk loading fails in SAS/ACCESS® Interface to DB2, the automatic macro variables SYSDBRC and SYSDBMSG are not populated. Depending on the code submitted, an error similar to the following might be generated:

ERROR: Bulk loader error: SQL3015N  An SQL error "-903" 
occurred during processing.

The macro variables are not populated because such SAS processes depend on a non-zero exit status for error conditions. Because this situation does not have a non-zero exit status, the process does not work properly.

Select the Hot Fix tab in this note to access the hot fix for this issue.

ATTENTION: This Hot Fix is intended for Unix and Windows customers running the DB2 Client 8.1 Fix Pack 9 or later. Customers running earlier versions of the DB2 Client should only install hot fixes prior to E9D205.

Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2Microsoft Windows Server 2003 Datacenter 64-bit Edition9.1 TS1M3 SP49.2 TS1M0
Microsoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M3 SP49.2 TS1M0
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.1 TS1M3 SP49.2 TS1M0
Microsoft Windows XP 64-bit Edition9.1 TS1M3 SP49.2 TS1M0
Microsoft® Windows® for x649.1 TS1M3 SP49.2 TS1M0
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M3 SP49.2 TS1M0
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M3 SP49.2 TS1M0
Microsoft Windows Server 2003 Standard Edition9.1 TS1M3 SP49.2 TS1M0
Microsoft Windows XP Professional9.1 TS1M3 SP49.2 TS1M0
Windows Vista9.1 TS1M3 SP49.2 TS1M0
64-bit Enabled AIX9.1 TS1M3 SP49.2 TS1M0
64-bit Enabled HP-UX9.1 TS1M3 SP49.2 TS1M0
64-bit Enabled Solaris9.1 TS1M3 SP49.2 TS1M0
HP-UX IPF9.1 TS1M3 SP49.2 TS1M0
Linux9.1 TS1M3 SP49.2 TS1M0
Linux on Itanium9.1 TS1M3 SP49.2 TS1M0
* 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.