How to avoid below warning?

K.A.R.PAULSON · Post by **K.A.R.PAULSON** » Mon Nov 29, 2004 2:05 am

I am getting the below warning in reject link. How can it avoid?

Reject_Data: When checking operator: When validating export schema: At field "exchrate": "null_field" length (1) must match field's fixed width (16)

If any one help me it will be great.

Thanks in advance.
Regi

rajeev_prabhuat · Post by **rajeev_prabhuat** » Mon Nov 29, 2004 3:43 am

Hi,

What is the datatype of the column "Exchrate" that you have specified in the source and the Rejection.

Regards,
Rajeev Prabhu

ray.wurlod · Post by **ray.wurlod** » Mon Nov 29, 2004 4:35 am

You've made the reject file a fixed-width format file.

You've specified a display (storage) width for the column Exchrate to be 16 characters.

You've specified a NULL-replacement string that is fewer than 16 characters. This is what DataStage is complaining about; you must follow the rules that you yourself set!

Make the NULL-replacement string 16 characters long, even if some of them are space characters.