warning 'delim=end' did not consume entire input

vairus · Post by **vairus** » Mon Jan 05, 2009 3:17 am

Hi all,

i write my unduplicate match and residula results in to a flat file. then i used those flat files as source to write in to the database.

am getting warning while writing into the database

message:initialday_match,0: Import consumed only 365bytes of the record's 375 bytes (no further warnings will be generated from this partition)

Message:: initialday_residual,0: Field "qsMatchType" with 'delim=end' did not consume entire input, at offset: 309

Message:: initialday_residual,0: Import warning at record 2563947.

initialday_residual,0: Import unsuccessful at record 2563947.

Could you tell me what cause these problems and how to fix this?

Thanks guys in advance
Regards

ray.wurlod · Post by **ray.wurlod** » Mon Jan 05, 2009 3:59 pm

It would seem that there's an additional ten characters in the data record that your metadata don't take into account (or 26 based on your "additional info" field). Look at the file using something outside of DataStage, preferably one that has a ruler so it's easy to determine the column numbers, and see what you can see there.

babbu9 · Post by **babbu9** » Wed Oct 31, 2012 1:45 pm

I just changed the final delimiter from "end" to "None" and it worked.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 31, 2012 10:50 pm

Only three years ten months later, with an identity change in the interim. Amazing!

hsahay · Post by **hsahay** » Thu Feb 13, 2014 11:33 am

hey ...thanks for the solution.

That worked for me too.

Can anybody shine a light on why though ? Most of the file work with final_delim=end ....what does it do when you specify "none" ?

Also, why is the documentation on schema file formats so sparse ? The help and guide in datastage does not tell you a single damn useful thing.

vgupta88 · Post by **vgupta88** » Tue Feb 23, 2016 11:34 am

Can anyone explain the reason behind this?
It worked for me too..