Archives of the TeradataForum

Message Posted: Wed, 11 Feb 2009 @ 13:23:30 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Apparently the incoming field is supposed to contain month and day in 'mmdd' form. If so, split it into two fields:

     .field  usage_mm    * char(2);
     .field  usage_dd    * char(2);

Now you might be able to check for invalid values in the .field commands:

     .field  usage_mm    * char(2) nullif usage_mm < '01' or usage_mm  > '12';
     .field  usage_dd    * char(2) nullif usage_dd < '01' or usage_dd  > '31';

You say the records are being dropped. I take that to mean that they are going to one of the error tables. Which error table are they going to, and what is the error code?

	<Prev	Next>		<<First	<Prev	Next>	Last>>