Sequential file warnings

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Karine
Participant
Posts: 37
Joined: Sun Feb 18, 2007 3:33 am

Sequential file warnings

Post by Karine »

I'm reading a sequential file with the following format
col1 char(3)
col2 char(5)
col3 char(8 )

and below are my sample data:
1112222233333333
4445555566666666

The sequential file stage has this definition:
Record Level - final delimiter = none
Field Level - Delimiter = none
Quote = none

This are the warnings I got in the Director log:

Sequential_File_0,0: Import consumed only 16bytes of the record's 17 bytes (no further warnings will be generated from this partition)
Sequential_File_0,0: Import warning at record 0:
Sequential_File_0,0: Missing record delimiter "\n", saw EOF instead
Sequential_File_0,0: Import warning at record 1:

Can someone help me by explaining why I'm getting the warnings? What did I do wrong? Why the first warning complained about the record has 17 bytes when to me it only has 16 (3+5+8= 16).


Thanks in advance.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Your file uses two characters as the line terminator. Either use the Record Delimiter String property set to \r\n or define a fourth Char(1) column (to read the \r) and specify UNIX newline as the Record Delimiter property.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply