Hi,
In column export i am using Final delimiter as end and Filed Delimiter string as \| ,In the same way i am doing from columnimport
Delimiter for field "Student" not found
Import was unsuccessful at record
What could be the reason.
Thanks for your time
Sateesh.M
Column import warning
Moderators: chulett, rschirm, roy
Which column number is "Student"? Can you post both your column definitions and a sample row of data to help analyze the problem?
<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:
Note that the problem is in an import operator, not in an export operator. So the problem's unlikely to be in your Column Export stage. Look at the stage that generates an import operator (which you can determine by inspecting the generated OSH).
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: 48
- Joined: Sat Oct 22, 2005 9:56 am
Ray,
You are right ,the problem is with columnexport only.Actually from input when we are exporting all the columns to a single column,If any special characters are coming then that particular data is not being inserted properly into database where as if we load to sequential file then it is being inserted,The special caracters are like * and ^ we are getting from input,
That is why in my second job when i am trying to import it is throwing Delimiter warnings.
Can you give your suggestions to rectify this.
Regards,
Sateesh.M
You are right ,the problem is with columnexport only.Actually from input when we are exporting all the columns to a single column,If any special characters are coming then that particular data is not being inserted properly into database where as if we load to sequential file then it is being inserted,The special caracters are like * and ^ we are getting from input,
That is why in my second job when i am trying to import it is throwing Delimiter warnings.
Can you give your suggestions to rectify this.
Regards,
Sateesh.M
-
- Participant
- Posts: 48
- Joined: Sat Oct 22, 2005 9:56 am