Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Representing Nulls in Bteq Export on MVS
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016