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?
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.