Archives of the TeradataForum
Message Posted: Thu, 24 Jun 2004 @ 20:48:08 GMT
<-- 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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|