Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 31 Oct 2002 @ 21:37:39 GMT


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


Subj:   Re: Help in fast Export script
 
From:   Reddy, Ponnolu

Hi,

Thanx for u r prompt reply..... In my test database, i have table "emp9" that contains following columns

name char(5)
Sex char(1)
phone decimal(12)
location char(6)

I want to pull that table from databse.... i have following script....

what to put in file ddname1.txt IIMPORT INFILE)?

------------------
.logtable utillog;

.logon demo1099/madhu25,madhu25;

.begin export sessions 20;

.LAYOUT UsingData;
        .FIELD name * varchar(5);
        .FIELD Sex * varchar(1);
        .FIELD phone * varchar(12);
        .FIELD location * varchar(6);

.IMPORT INFILE
C:\Teradata\Scripts1025\emp9\ddname1.txt
        FORMAT vartext
        layout UsingData;

.EXPORT OUTFILE
C:\Teradata\Scripts1025\emp9\ddname4.txt
                FORMAT BINARY
                MODE RECORD;

select * from emp9;

.end export;

.logoff;


     
  <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