Warnings in sequential file

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
bala_135
Premium Member
Premium Member
Posts: 156
Joined: Fri Oct 28, 2005 1:00 am
Location: Melbourne,Australia

Warnings in sequential file

Post by bala_135 »

Hi,

I am getting the following warning when I use a sequential stage as the source.
Sequential_File_0,0: Import consumed only 76bytes of the record's 77 bytes (no further warnings will be generated from this partition)

my final delimiter is none or whitespace.
my record delimiter is tab.


Kindly let me what could be the possible reason or let me know what can be done.

Thank you in advance
Bala
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

According to your columns, you should have 76 bytes of information on that line, but the line read from the file contained 77 bytes. So you have a discrepancy between your metadata and data. Once you discover where your problem lies you can modify that column description. When data comes from mainframes and the last column contains text with trailing space(s) it gets inadvertantly trimmed; this might be happening in your case.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is the record terminator property set to UNIX-style when it should be set to DOS-style?
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