• Print |
• E-mail  |
• Bookmark

Using SAS/ACCESS Interface to DB2 to bulkoad to a DB2 table in a DBCS
database, the following error may be received:

  ERROR: Bulk loader error: SQL3061N  The single-byte and/or double-byte
         code page field in the H record cannot be converted to a
         numeric value or the value is out of range.

Specifying the appropriate codepage using, BL_CODEPAGE, can be used
to work around the error:

  proc append base=test.class
      (BULKLOAD=YES
       BL_CODEPAGE=1208
       BL_REMOTE_FILE='c:\temp'
       BL_LOG='c:\temp\class.log'
       BL_DATAFILE='c:\temp\classs.ixf')
     data=sashelp.class;
  run;



A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#013504


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

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#013504

For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#013504

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at:

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 :