Archives of the TeradataForum
Message Posted: Fri, 25 Jun 2004 @ 13:00:01 GMT
| Subj: || || Re: Representing Nulls in Bteq Export on MVS |
| From: || || Geoffrey Rommel |
| ||Help! I need to represent nulls in an export running on MVS.|| |
| ||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.|| |
I hate to tell you this, but indicator mode does produce a flat file that clearly shows what fields are null. Interpreting them is easy,
actually: the bits correspond with the fields one by one in order; one means null and zero means not null. For instance, if the first indicator
byte is x'54' (b'01010100'), the second, fourth, and sixth fields are null. This is spelled out in the manual "CLI V2 for Channel-Attached
Systems", App. E, under "Record Parcel (in Indicator Mode)". Unfortunately, other mainframe programs do not easily recognize this format.
If you want to substitute some value for nulls automatically, you could perhaps write your own export program. For that purpose I would suggest
Cobol with embedded SQL. Quite a pain, eh?