The following error message might be issued after you apply Hot Fixes E9D215，E9BD08，E9BD09，and E9BD10 and you attempt to load DB2 data using either the DB2LOAD or the DBLOAD procedures:

ERROR: DB2 PREPARE ERROR:   DSNT408I SQLCODE = -107, 
ERROR:  THE NAME "D99H02                         AZ" IS TOO LONG.  
MAXIMUM ALLOWABLE SIZE IS 18.          

The table name is created incorrectly. That is, the name is quoted with padded spaces. Therefore, the table name is not recognized.

This problem only happens when you use a DBCS English edition of SAS, and it is isolated to SAS/ACCESS^® Interface to DB2 in the IBM z/OS operating environment.

To circumvent this issue, use the LIBNAME statement instead of PROC DB2LOAD or PROC DBLOAD. These procedures are older technology, and their use is discouraged.

Note, though, that in certain situations you might not be able to modify your SAS applications to use the LIBNAME statement because it can require changes to too many jobs.

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

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: