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

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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