problem with column import stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
siva4joy
Premium Member
Premium Member
Posts: 34
Joined: Fri Apr 14, 2006 6:10 am
Location: London

problem with column import stage

Post by siva4joy »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
siva4joy
Premium Member
Premium Member
Posts: 34
Joined: Fri Apr 14, 2006 6:10 am
Location: London

Post by siva4joy »

i have given the filed delimiter as none and record delimiter also as none.
is there any problem with that one.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

In what format are the data arriving? That's what you must specify correctly to the stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
siva4joy
Premium Member
Premium Member
Posts: 34
Joined: Fri Apr 14, 2006 6:10 am
Location: London

Post by siva4joy »

the format is binary and i am importing the data as char.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Try VarChar. Are there any "zero bytes" in your 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.
siva4joy
Premium Member
Premium Member
Posts: 34
Joined: Fri Apr 14, 2006 6:10 am
Location: London

Post by siva4joy »

no, total length for all columns is 1061 bur for particular this segment(CU) i am having only 173 bytes .
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is the 174th byte 0x00?
This might be interpreted as a C-language string terminator.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
siva4joy
Premium Member
Premium Member
Posts: 34
Joined: Fri Apr 14, 2006 6:10 am
Location: London

Post by siva4joy »

actually the file which i am using is coming as a .txt file from mainframe.
from which i have to extarct the values and load it into secveral columns that's why i am using column import stage.
and after 173 bytes there is no char i mean it's a space values.
but i am taking only 173 bytes. :?:
Post Reply