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
Delimiter not seen at offset issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 32
- Joined: Tue Mar 09, 2010 5:56 am
- Location: Bangalore
Delimiter not seen at offset issue
Thanks & Regards,
Partha
Partha
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.