Archives of the TeradataForum

Message Posted: Mon, 05 Apr 2004 @ 08:21:08 GMT

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

Hi,

As per Victor's suggestion-iam reframing my question from scratch !

I have a nullable decimal field in in my input file for mload(decimal(15,0).

It is not recommended to use nullif statements in my mload as they cause CPU overhead. So,instead of nullif ,i can use case.

(i.e)

     field f1 decimal(15,0);
     field f1_ind char(01);

my insert would be like

case when f1_ind = '?' then null else f1.

the problem comes when the field f1 is null.When it is null,the I/P file does not have the value in decimal format (in lowest terms my hex on does not have anything ending with 'C' or 'D' in my file ). So,i would not be able to read them as decimla(15,0).It would fail and rows go into error table.

I cannot use char also for reading it - as decimal read as char cannot insert proper values even if i cast !

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