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: Call for Content

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!

Submit your idea!

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
  • 1365 views
  • 0 likes
  • 3 in conversation