DSXchange

Hi All,

Acutally we are trying to remove warning from the jobs and most of our tagets are DB2 Enterprise Stages and we have reject links for Target DB2 and reject records if any,goes to seq. Flie Stage.

Here in Seq file we are facing warning and unable to remove,its related to null handling and i m unable to handle nulll to each and every columns because it is not decable. Anyhow i have defined Null Field Value='' in Format tab but its not working for Char.My warning Message is So is there any way to remove these warnings.

Regards
Deb

Set your null field value to (6 spaces). Your message comes from the fact that your null field specification and actual field lengths are not the same.

ArndW wrote:Set your null field value to

Code: Select all

"      "

(6 spaces). Your message comes from the fact that your null field specification and actual field lengths are not the same.

Thanks for your reply,but i have other columns whose datatype is Char of 2 lenght and others have char(6), so how can i handle null in this..?

Char(2) columns must have a Null Field Value containing precisely two characters, even if they're space characters. Char(6) columns must have a Null Field Value containing precisely six characters, even if they're space characters.