Archives of the TeradataForum

Message Posted: Thu, 01 Apr 2004 @ 09:44:23 GMT

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

Hi,

In my Mload,i have a decimal field which has an indicator field following to specify if it is nullable.

When it is nullable,(i.e the ind value = '?'),the decimal field stores low values. So,my layout definition of reading that value as decimal(15,0) does not work (rows would go into ET)

Neither am I able to read as char and cast it , as rows would go into UV for failure in conversion from char to numeric function.

How do I go about this ?

TIA.

Rohini

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