Warning Message in Reading Sequential file

[somu_june]

Hi,


I need help in solving warning messages. I have a input file when Iam reading data from that input file Iam getting a warning messages like this

Sequential_File_0,0: Import consumed only 188bytes of the record's 189 bytes (no further warnings will be generated from this partition)

Sequential_File_0,0: Import warning at record 0.

Its giving warning at record zero. I tried with all options in format tab . But Iam not able to solve this problem.

Iam having records like this in input file for example

1VK15 A956V ZR00

2KK 00N00AAN1 999912311980020600000013SR 1 EA / EA / / /////

In my sequential file stage. In Format tab ...... Record level I gave

Final delimiter = whitespace
Record delimiter = Unix New line

In Format tab ...... Field Defaults . I gave

Delimiter = none
quote= double


Thanks,
Somaraju

[ArndW]

Your file has 189 bytes in the first record, and your column metadata only account for 188 of those bytes. You are using a fixed width format, so the actual length must match that of your column definitions. What is are your column definitions? You could use an editor to manually check to see where you have dropped the 1 character.

[somu_june]

Hi Arnd,


Thanks for solving my problem .









Thanks,
Somaraju

[ArndW]

Somaraju,

I'm glad my comment helped you find your error! Could you post what it was, so that someone using the search facility with the same issue can see the resolution?

[somu_june]

Hi Arnd,

Actually when Iam defining a metadata for sequential file. I gave total columm metadata length as 187 and after seeing your post I checked all the lengths of the columm then I got 187 total length . I added 2 more bytes to the last columm metadata which is free space and now it was 189. Then I ran the job and my problem was solved.


Thanks,
Somaraju

[ArndW]

Great - thanks for the update!