Using BULKLOAD=YES along with SERVER= when accessing DB2 via the LIBNAME engine when running in the IBM z/OS environment is not currently supported


Using BULKLOAD=YES along with the SERVER= option in a LIBNAME statement while running the SAS/ACCESS® Interface to DB2 for z/OS is currently not supported. Using these options results in a -444 error when the SERVER= option is pointing to a DB2 database on a Windows or UNIX platform. The error might look similar to the following:

DB2 ERROR: RESULT OF SQL STATEMENT: A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS: ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 0 SQLCODE: -444 SQLSTATE: 42724 SQLERRP: SQLERLIB

ERROR: (ACCDB2M004E) Error trying to run the load utility. See the DB2PRINT dataset for error messages.