Archives of the TeradataForum

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

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

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