Page 1 of 1
Sequential file warning message
Posted: Wed May 03, 2006 4:09 am
by Ritesh Vikram
I am getting a warning message "Warning: Data that exceeds the maximum display length has been truncated." The length of the column is CHAR(2700). the file has only one column which is derived by merging all the columns of a source table. Though the record can be seen properly through Unix but when we see the record at the sequential file stage through DS it generates the warning
Posted: Wed May 03, 2006 4:12 am
by ArndW
If this message is while you are doing "view data" then it is not going to affect the runtime processing of the data. If you are getting this warning during execution of your job then it is a problem.
Sequential Warning
Posted: Wed May 03, 2006 4:16 am
by Ritesh Vikram
ArndW wrote:If this message is while you are doing "view data" then it is not going to affect the runtime processing of the data. If you are getting this warning during execution of your job then it is a problem. ...
It is not affecting the data as it comes while viewing the data but is there any way to remove the warning
Posted: Wed May 03, 2006 5:08 am
by ArndW
Do you have the LENGTH and the DISPLAY set to 2700 in your stage definitions? If you have display set to your maximum data length you shouldn't see the warning, I just tried it at 7.5
Posted: Wed May 03, 2006 5:28 am
by sb_akarmarkar
Hmmm...
There is limit to display column data in view data... If your data is more than that limit it will display error data will be truncated... even if increase display length...
Thanks,
Anupam
Posted: Wed May 03, 2006 8:42 pm
by ray.wurlod
... and the actual limit is undocumented, so you will need to determine it by experimentation. If you do, please post your findings.