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
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.
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
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
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...
</a>