topic Re: Error when bulkload to DB2 zos from SAS PC-file in SAS Data Management

Error when bulkload to DB2 zos from SAS PC-file

Bjarnekj — Tue, 07 Jul 2015 09:52:59 GMT

I got an error when trying to load data into DB2 on z/os from a SAS file located on Windows machine

29         data TEST.Testtable1
30            (bulkload=yes bl_db2tblxst=yes bl_db2ldct1='REPLACE');
31            set testSAS_out;
32         run;

NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.
ERROR: INTERNAL ERROR - YP UNABLE TO FORMAT MESSAGE.
NOTE: The DATA step has been abnormally terminated.
NOTE: The SAS System stopped processing this step because of errors.

Can anyone help

Regards Bjarnekj

Re: Error when bulkload to DB2 zos from SAS PC-file

LinusH — Tue, 07 Jul 2015 12:11:12 GMT

This might apply, not very positive though:

http://support.sas.com/kb/47/863.html

Perhaps a track to SAS tech support would be the best way forward.

Perhaps

options sastrace=',,,d' sastraceloc=saslog;

will you give some more hints...

Re: Error when bulkload to DB2 zos from SAS PC-file

JBailey — Tue, 07 Jul 2015 14:44:06 GMT

Hi,

It sounds like you are running SAS on a Windows box. If this is the case there are lots of moving parts here. The error indicates that the actual message is being lost. I think your best bet is to call SAS tech support on this one.

Best wishes,

Jeff

Re: Error when bulkload to DB2 zos from SAS PC-file

Bjarnekj — Wed, 08 Jul 2015 06:09:21 GMT

Hi,

Options didn't give anything, but hanks for reply I will contact SAS-Tech support

/Bjarne

Re: Error when bulkload to DB2 zos from SAS PC-file

Bjarnekj — Wed, 08 Jul 2015 06:10:27 GMT

Hi,

Yes I'm running on a Windows box, thanks for reply I will contact SAS-Tech support

/Bjarne