DSXchange

I have a very simple job with source and target sequential file stages.
I have a 100 character Unix file with just 1 line. The columns are:

A 10
B 10
C 50
D 30

On the Format tab of the source sequential file stage, I have:

Record Level:
Final Delimiter: None
Record Deliiter: UNIX Newline

Field Defaults:
Delimiter = none

Whenever I run the job, I keep getting the warning:

Import consumed only 80bytes of the record's 101 bytes (no further warnings will be generated from this partition)

Any ideas?

It looks like you declared 4 columns at 20bytes apiece in your metadata for the fixed width, and this is incorrect and being flagged by DS.

don't specify lenth for the last field, and the result

I found the reason and it is definitely a strange one. On the columns tab of the sequential file stage, I rightclicked and added Field Properties. This opens the Edit Column Meta Data window. On this window, the Field Width property for the last column is 10 eventhough on the Columns tab, I specified the length as 30 (this column initially had a length of 10). Apparently, this overrides the length specified. Very strange!

The Field Width property is the Display Size, not the SQL precision.

If Field Width for display size, why do I get the error message then? It overrides the value specified in the Length column. Where would I set the SQL precision, i.e., where does Datastage read the actual value of the column size from?