Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 29 Nov 2004 @ 14:04:47 GMT


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


Subj:   Re: Fast Export Decimal problem
 
From:   Geoffrey Rommel

  Since BTEQ and FASTLOAD were normally used to load data from the mainframe, the data normally came from DB2 and they know about null bits  


Not sure what you mean here, Michael. As far as I know, DB2 (officially DB2 UDB for z/OS) will not unload data with the null bits packed into bytes as Teradata does. You could write your own program, though ... hmm ...


  would it not follow in a logical progression that DB2 load and unload utilities know how to create and interpret the null bits?  


No. DB2 has always sublimely disregarded Teradata.

In the early releases of DB2, there was a LOAD utility but no UNLOAD. The NULLIF parameter in the load utility allows you to check only whole bytes, not individual bits.

There was a "sample program" called DSNTIAUL that would unload data from a DB2 table, but it wasn't officially supported. In V6, the REORG UNLOAD EXTERNAL command was added; this is a supported unload utility. I believe it indicates nulls by means of a separate byte either before or after the nullable field.



     
  <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