BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I am trying to delete records from a db2 table using proc DB2UTIL as shown below on os/390. As table name is too long I am getting following error

data indate;
deldate = '30NOV08' ;

options db2ssid=dbXX ;
proc db2util
data = indate
table = aaaaaaa.mmmmm_eee_xxxx_yyyy
function=delete update;
where calendar_dt = %deldate;
sqlout = sqlfile;
update;
run;

As existing table name is too long, I am getting the following error.
DSNT408I SQLCODE = -204, ERROR: aaaaaaa.mmmmm_eee_xxxx_yy . If you observe the last two bytes are truncated. The table has 5million rows, so I am not able to create view also. Can anyone suggest how to handle this?
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
The ODS forum mostly focusses on PROC PRINT, PROC REPORT, PROC TABULATE for Base SAS reporting, with ODS. If a DATA step program were used for producing reports with Base SAS, that question might fit here, also.

However, the DATA step and PROC DB2UTIL do not fit in this category -- especially since you are performing file maintenance and not reporting, per se. You might be better off posting your question in the SAS Procedure or the Data Step and Macro forum. If you have persistent or urgent problems with your DB2UTIL program, you might wish to open a track with Tech Support for more help.

cynthia

sas-innovate-2024.png

Today is the last day to save with the early bird rate! Register today for just $695 - $100 off the standard rate.

 

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

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 799 views
  • 0 likes
  • 2 in conversation