import error and no default value
Moderators: chulett, rschirm, roy
import error and no default value
Hi All,
I am also having the same problem as I am using sequential file as lookup and it has one integer field which is nullable.
I got the warning like
Field "<field_name>" has import error and no default value; data:at offset<field_name>: 17
<field_name>: Import warning at record 0.
I have set the Null Field Value to \0 so that my warning is gone.
Now again I am facing the same as I have changed the job.
My requirements are
Final Delimeter=End
Delimiter=comma
Quotes=double.
Can any one suggest why am I geting the same again.
Thanks in Advance
Anju
I am also having the same problem as I am using sequential file as lookup and it has one integer field which is nullable.
I got the warning like
Field "<field_name>" has import error and no default value; data:at offset<field_name>: 17
<field_name>: Import warning at record 0.
I have set the Null Field Value to \0 so that my warning is gone.
Now again I am facing the same as I have changed the job.
My requirements are
Final Delimeter=End
Delimiter=comma
Quotes=double.
Can any one suggest why am I geting the same again.
Thanks in Advance
Anju
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Since it is complaining about position 17, your file or metadata must be different than what you posted.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Record 0 is line number 0 in the file. Since everything is written in C (or C++) counting is always zero based.
Please show us what's actually in the file - in particular what's in character position 17 (that's the 18th character) on the first line of the file (that's line number 0).
Note that there may be non-printing characters, so please use some kind of editor that will display these.
Please show us what's actually in the file - in particular what's in character position 17 (that's the 18th character) on the first line of the file (that's line number 0).
Note that there may be non-printing characters, so please use some kind of editor that will display these.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please post the record schema (from the generated OSH for this job). Please also verify that your field delimiter is comma and that your field quote character is double-quote.
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.