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

anshumangupta1206 · Post by **anshumangupta1206** » Fri Sep 08, 2006 3:09 am

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

sb_akarmarkar · Post by **sb_akarmarkar** » Fri Sep 08, 2006 4:05 am

You need to set display lenght also

Thanks,
Anupam

anshumangupta1206 · Post by **anshumangupta1206** » Fri Sep 08, 2006 4:38 am

Display length is already defined and it is same as Length field.

sb_akarmarkar wrote:You need to set display lenght also

Thanks,
Anupam

kcbland · Post by **kcbland** » Fri Sep 08, 2006 7:00 am

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.

Woth · Post by **Woth** » Mon Sep 11, 2006 11:25 am

depending on the version you are using, there is an option in the stage that permits you to eliminate that warning

DSguru2B · Post by **DSguru2B** » Mon Sep 11, 2006 12:17 pm

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.

Krazykoolrohit · Post by **Krazykoolrohit** » Mon Sep 11, 2006 12:34 pm

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.

kcbland · Post by **kcbland** » Mon Sep 11, 2006 12:52 pm

You're all wrong except DSGuru2B. It's the GUI that can't display the full contents of a column. The job is fine.