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
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
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.