SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Error when bulkload to DB2 zos from SAS PC-file

Reply
New Contributor
Posts: 3

Error when bulkload to DB2 zos from SAS PC-file


Hi

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

Super User
Posts: 5,256

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

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...

Data never sleeps
SAS Employee
Posts: 203

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

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

New Contributor
Posts: 3

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

Hi,

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

/Bjarne

New Contributor
Posts: 3

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

Hi,

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

/Bjarne

Ask a Question
Discussion stats
  • 4 replies
  • 422 views
  • 0 likes
  • 3 in conversation