Delimiter not seen at offset issue

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
partha.natta
Premium Member
Premium Member
Posts: 32
Joined: Tue Mar 09, 2010 5:56 am
Location: Bangalore

Delimiter not seen at offset issue

Post by partha.natta »

We are facing an issue while loading a delimited file into sql server database.
The metadata is defined in schema file as mentioned below.

record
{record_delim='\n', delim='|',final_delim=none, quote=NONE}
(
Col1:nullable string[1] {null_field=''};
Col2:nullable string[5] {null_field=''};
Col3:nullable string[10] {null_field=''};
Col4:nullable string[10] {null_field=''};
Col5:nullable string[10] {null_field=''};
Col6:nullable string[10] {null_field=''};
)

The table definition also same as the schema file.
but we are getting an error saying that, Field "Col2" delimiter not seen, at offset: 7
Thanks & Regards,
Partha
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Your data lacks the pipe delimiter following col2. Does the error message mention the row number at which this occurred? If row 0, how is the "first line is column names" property set?
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