Archives of the TeradataForum
Message Posted: Mon, 05 Apr 2004 @ 08:21:08 GMT
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.
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 !
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|