Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 25 Jun 2004 @ 13:00:01 GMT

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

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?

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016