Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 17 Sep 1999 @ 05:43:55 GMT


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


Subj:   Fastexport to a "C" outmod utility
 
From:   Wayne Moran

ALL,

I have written a C outmod utility that I use with fast export. The main reason I wrote it was the 2 gig file size limit under UNIX. The fast export has 2 select statements, the first passes control information and the second the data.


If anyone is interested in more details, let me know.

Wayne Moran


Sample slice of code showing control information.

     select
        '0250'           (char(4))    /* record length */
      , '05'             (char(2))    /* number of output files  1 - 20  */
      , '004000000'      (char(9))    /* number of records per file    zero if only 1 file */
      , 'N'              (char(1))    /* create all output files some files may be empty   */
      , 'Y'              (char(1))    /* compress output files  using UNIX compress utility  */
      , '${out_file_1}'  (char(60))   /* file path and name  max 20  */
      , '${out_file_2}'  (char(60))   /* file path and name               */
      , '${out_file_3}'  (char(60))   /* file path and name               */
      , '${out_file_4}'  (char(60))   /* file path and name               */
      , '${out_file_5}'  (char(60))   /* file path and name               */
     from anytable
     group by 1,2,3,4,5,6,7,8,9,10
     ;

     select
              col1                     ( CHAR(50) )
             ,col2                     ( CHAR(50) )
             ,col3                     ( CHAR(50) )
             ,col4                     ( CHAR(50) )
             ,col5                     ( CHAR(50) )

     from table1;


     
  <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