Archives of the TeradataForum
Message Posted: Thu, 31 Oct 2002 @ 21:29:38 GMT
Subj: | | Re: Help in fast Export script |
|
From: | | Doug Drake |
Below is a sample FastExport script. This one has an outlimit of 0 which therefore only generates a Multiload script (0 rows). Set the
outlimit at the number of maximum rows that you might want to export.
Doug Drake
--------------
.logon xxx/yyy,zzz;
.begin export sessions 12;
.export outfile "Fexp Pty Cl RB.data" mode record Outlimit 0 Mlscript
"ML Pty Cl RB.txt";
select * from pty_centric_0112.ptycl_rb;
.end export;
.logoff;
|