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
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...
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
Hi,
Yes I'm running on a Windows box, thanks for reply I will contact SAS-Tech support
/Bjarne
Hi,
Options didn't give anything, but hanks for reply I will contact SAS-Tech support
/Bjarne
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.