BookmarkSubscribeRSS Feed
Bjarnekj
Calcite | Level 5


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

4 REPLIES 4
LinusH
Tourmaline | Level 20

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
JBailey
Barite | Level 11

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

Bjarnekj
Calcite | Level 5

Hi,

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

/Bjarne

Bjarnekj
Calcite | Level 5

Hi,

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

/Bjarne

SAS Innovate 2025: Register Now

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!

How to connect to databases in SAS Viya

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.

Discussion stats
  • 4 replies
  • 1396 views
  • 0 likes
  • 3 in conversation