Archives of the TeradataForum

Message Posted: Thu, 24 Jun 2004 @ 20:48:08 GMT

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

<-- Anonymously Posted: Thursday, June 24, 2004 15:59 -->

Help! I need to represent nulls in an export running on MVS. The SET NULL AS "--" command has no affect in MVS. The nulls end up as spaces. That is not acceptable, because in some cases a space is a valid value. It works in Unix. I can't believe it does not work in MVS.

I prefer not to do a case a case statement because I am exporting over 130 tables and there are many, many fields that are nullable. I have not tried it, but it may not even work.

INDICATOR MODE does not help, because it sets bits at the beginning of the record and I do not know of a way to interpret the bits.

I need a flat file that clearly shows what fields are null.

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