Archives of the TeradataForum

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

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

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>>