Archives of the TeradataForum

Message Posted: Wed, 24 Nov 2004 @ 21:54:35 GMT

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

Fachtna,

Try using a case statement to transform the nulls to another value - sorry, I'm not familiar enough with DB2 to know what it's looking for, but you likely know what you need. If you can read the file and work on it in DB2, then change a null to the word 'NULL', or '?'. If you need to keep the value strictly numeric for an MVS load, I believe '00'xb is the equivalent of low-values.

Hope this helps.

Jonathan

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