Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 01 Nov 2002 @ 16:46:11 GMT

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

Subj:   Re: Help in fast Export script
From:   Anomy Anom

<-- Anonymously Posted: Friday, November 01, 2002 09:33 -->


You cannot use import (import a file) in a fastexport. If you need to import a file and use it for the "where clause" for exporting data from a table, then you have to use Bteq. When exporting you do not need to specify "Format" on the fields, since it would export the fields in the native format. For e.g. if you export files to the mainframe, the Decimal fields will be exported as comp-3 fields, the integer, smallint and tinyint as comp fields .etc. The format Dara is referring to, is the format of the output file.

  <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: 28 Jun 2020