Page 1 of 1

War - 'Data that exceeds maximum length has been truncated'

Posted: Fri Sep 08, 2006 3:09 am
by anshumangupta1206
Hello All,
I have creatde a sequential file with total columns length as 1200 for a record.When I am looking into the file with 'View Data' option , getting a warning stating - 'Data that exceeds maximum length has been truncated'.

Can anybody explain me the reason for the same with solution.

Whether there is any relation to the maximun length?

Thanks

Posted: Fri Sep 08, 2006 4:05 am
by sb_akarmarkar
You need to set display lenght also


Thanks,
Anupam

Posted: Fri Sep 08, 2006 4:38 am
by anshumangupta1206
Display length is already defined and it is same as Length field.

sb_akarmarkar wrote:You need to set display lenght also


Thanks,
Anupam

Posted: Fri Sep 08, 2006 7:00 am
by kcbland
There is a maximum number of characters the GUI will display, something quite large. You probably have a row with a column thousands of characters wide.

Posted: Mon Sep 11, 2006 11:25 am
by Woth
depending on the version you are using, there is an option in the stage that permits you to eliminate that warning

Posted: Mon Sep 11, 2006 12:17 pm
by DSguru2B
But i dont think this is something that you need to worry about. The job will run just fine. If you have to view the records, do it from the unix level by using the head and tail options.

Posted: Mon Sep 11, 2006 12:34 pm
by Krazykoolrohit
DSguru2B wrote:But i dont think this is something that you need to worry about. The job will run just fine. If you have to view the records, do it from the unix level by using the head and tail options.
Data getting truncated is nothing to worry about? If it is getting truncated in "view data" it will be passed on truncated. Correct me if i am wrong.

Posted: Mon Sep 11, 2006 12:52 pm
by kcbland
You're all wrong except DSGuru2B. It's the GUI that can't display the full contents of a column. The job is fine.