Page 1 of 1

Complex Flat Files

Posted: Tue Mar 01, 2011 5:48 am
by GAMEOVER7
Hi,

I want to display data in a complex file without error.
1) I saved the file structure Complex Flat Files from DataStage Server on the folder Table Definitions.

2) I worked with this file in DataStage PX/EE:
Input CFF, then a Transformer and a Table Oracle Output

Result : Warning : Data that exceeds the maximum display length has been truncated

Thank you.

Posted: Tue Mar 01, 2011 7:56 am
by chulett
There is a hard limit in the Viewer on how much data it can display... you've exceeded that in at least one field. Not much you can do about that if your field sizes are correct, view it outside of DataStage if you need to see every last bit.