DSXchange

I have connected to a db2 database from datastage and taken the output of a table to a sequential file. Now iam using this sequential file as an input for another job. But iam geeting lot of warning saying that some data is rejected.
The errors iget look like the following:

Personnel,0: Field "WFAC_PASSWORD" with 'delim=end' did not consume entire input, at offset: 382
Personnel,0: Import warning at record 1105:
Personnel,0: Import unsuccessful at record 1105:
Personnel,0: Trailing quote for field "COMMENTS" not found, at offset: 202
Personnel,0: Import warning at record 2080:
Personnel,0: Import unsuccessful at record 2080:
Personnel,0: Input buffer overrun at field "HOME_PHONE"
Personnel,0: Import warning at record 2081:
Personnel,0: Import unsuccessful at record 2081:
Personnel,0: Trailing quote for field "COMMENTS" not found, at offset: 216
Personnel,0: Import warning at record 2124:
Personnel,0: Input buffer overrun at field "HOME_PHONE"
Personnel,0: Import warning at record 2125:
Personnel,0: Import unsuccessful at record 2125:

etc........

Iam using all the data types as varchar and nullable as "NO".

Please help me to sort out this.

You will need to check the delimiter for the file and specify the same in the stage. If there is no Quote found in file, mention the Quote as none (000),

You have quote characters in the COMMENTS and HOME_PHONE fields that match the quote character specified in the Format properties. Change the format as kumar_s suggests.

I have 55 columns in the file and only 2 columns have the problem. i.e., they are getting rejected. how can i set the delimiter for these two columns. delimiter is used for the whole file.

Fix the quote character (not the delimiter) for the entire file, you cant do it for a portion of the file.

The problem seems to be with Quote character not the Delimiter. You need to fix the quote character of entire file. Also check the final delimiter.

Sam

should i do it manually?....In datastage i have set the quote as double.

In the first job change the quote character to '000' and use the same settings in reading the file in next job.

sam

Hi ,

Check the data type and data in the database by querying directly in the database for those two columns, View the data through some editor you will get some idea.

Thanks
Thiru

kirankota79 wrote:I have 55 columns in the file and only 2 columns have the problem. i.e., they are getting rejected. how can i set the delimiter for these two columns. delimiter is used for the whole file.

check record 2080,record 2081,record 2124,record 2125 in bd2 and tell me the check the metadata and let me if the metadata is fine,

Hi kirankota79,
If you got a solution, you can mark the topic as resolved. Also add up with the method you solve the issue, so that, the other enthusiastic participants can work on other post rather than a post posted a month back.