Strange warning from a sequential file load

abc123 · Post by **abc123** » Thu May 31, 2007 12:19 am

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?

ArndW · Post by **ArndW** » Thu May 31, 2007 1:25 am

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.

keshav0307 · Post by **keshav0307** » Thu May 31, 2007 3:21 am

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

abc123 · Post by **abc123** » Thu May 31, 2007 8:05 am

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!

ray.wurlod · Post by **ray.wurlod** » Thu May 31, 2007 7:20 pm

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

abc123 · Post by **abc123** » Fri Jun 01, 2007 11:53 am

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?