We have developed a parallel job to load a tab delimited text file to an oracle table.There are few numeric columns in the text file with null values.
Due to this the file is not getting loaded to the database.The following are the warnings we get,
Seq_Pbip_Line_Utl_Dtl,0: Field "LINE_UTL_IN_PER" has import error and no default value; data: <empty>, at offset: 89
Seq_Pbip_Line_Utl_Dtl,0: Import warning at record 172.
Seq_Pbip_Line_Utl_Dtl,0: Import unsuccessful at record 172.
Could you please help us out in resolving this issue ?
Import Error while reading a tab delimited text file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 60
- Joined: Mon Dec 27, 2004 3:38 am
-
- Participant
- Posts: 60
- Joined: Mon Dec 27, 2004 3:38 am
-
- Participant
- Posts: 60
- Joined: Mon Dec 27, 2004 3:38 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It seems likely that you have been insufficiently diligent in accurately setting null field values. You have an empty field at column position 90 (the figure 89 is zero-based numbering) which is the field LINE_UTL_IN_PER; has this field's Null Field Value property been set to ""? Can you see the NULL when you View Data (set skip to 170 and rows to 5 in View Data)?
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.