DSXchange

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.

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?

i have given the filed delimiter as none and record delimiter also as none.
is there any problem with that one.

In what format are the data arriving? That's what you must specify correctly to the stage.

the format is binary and i am importing the data as char.

Try VarChar. Are there any "zero bytes" in your data?

no, total length for all columns is 1061 bur for particular this segment(CU) i am having only 173 bytes .

Is the 174th byte 0x00?
This might be interpreted as a C-language string terminator.

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.