Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2004 @ 20:32:27 GMT


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


Subj:   Representing Nulls In a FASTEXPORT Output File
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, February 03, 2004 15:30 -->

Using MVS, a FASTEXPORT will populate spaces into the output file for a null char value. Sometimes, though, space and null are both valid values for a field. I need to distinguish between what was NULL and what was truly blanks.

Documentation says that MODE INDICATOR is one way to communicate this information. However, I am having trouble finding detailed documentation on how the indicator area is defined. The wording in the FASTEXPORT manual is way too general. My FASTEXPORT file will be used by a COBOL program. So a COBOL example of how to define the area would be absolutely wonderful.

What would be IDEAL is to just be able to have all "NULL" values represented as a certain character in the output file, whether the data was DATE, INTEGER, CHAR, etc., etc. Something similar to the ".set null as '*' " BTEQ command. I've tried to get this command to work in my FASTEXPORT SQL, but can't.


Thanks.



     
  <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: 15 Jun 2023