Page 1 of 1

How to avoid below warning?

Posted: Mon Nov 29, 2004 2:05 am
by K.A.R.PAULSON
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

Posted: Mon Nov 29, 2004 3:43 am
by rajeev_prabhuat
Hi,

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

Regards,
Rajeev Prabhu

Posted: Mon Nov 29, 2004 4:35 am
by ray.wurlod
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.