DSXchange

Hi, I FTP 1 sequential file with fixed width 124. Preview the Data, all OK.

I set "Fixed Width", Column Definition also 124 in FTP stage.

However I am getting this "Warning":
"PostingFTP..Transformer_12: data for String exceeds column width(0)"

and the output file is blank.

Is there any other setting I should tinker with?

Thanks a lot
Meor
Malaysia

Welcome.

Make sure you set the Display Size properly in the Columns metadata as that information is what drives the stage. It sounds like you may have left that blank.

chulett wrote:Welcome.

Make sure you set the Display Size properly in the Columns metadata as that information is what drives the stage. It sounds like you may have left that blank.

Thanks Craig, it really does the trick.

I wonder how and where else do you guys find out the solution besdes this forum, is there a book, online manual or anything about DataStage?

I am planning to use C# to do comples business rules and embed in DS

Thanks anyway
Meor
Malaysia

meorz wrote:is there a book, online manual or anything about DataStage?

Book? No. Only 'official' things are the online help available from each Client tool and the .pdf documents automatically installed onto your pc with the client.