problem with column import stage
Moderators: chulett, rschirm, roy
problem with column import stage
hi,
i am having a problem with column import stage when extracting the data from sequential file which is a binary and importing no of columns which are char.i am getting the following warnings .
columnCU,0: Import consumed only 173bytes of the record's 1061 bytes (no further warnings will be generated from this partition)
columnCU,0: Import unsuccessful at record 0:
colCA,0: Import consumed only 50bytes of the record's 54 bytes (no further warnings will be generated from this partition)
colCA,0: Import unsuccessful at record 0:
can anybody tell me why this problem is coming.
highly appreciate your help in this.
i am having a problem with column import stage when extracting the data from sequential file which is a binary and importing no of columns which are char.i am getting the following warnings .
columnCU,0: Import consumed only 173bytes of the record's 1061 bytes (no further warnings will be generated from this partition)
columnCU,0: Import unsuccessful at record 0:
colCA,0: Import consumed only 50bytes of the record's 54 bytes (no further warnings will be generated from this partition)
colCA,0: Import unsuccessful at record 0:
can anybody tell me why this problem is coming.
highly appreciate your help in this.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In record 0 (the first line in the source file/data set) you don't have enough metadata to describe the entire record. Is the field delimiter correctly set? Is the record delimiter correctly set? Do you require a final delimiter?
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:
-
- 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: