Recently, I came across the so-called fast export facility in Teradata. This facility allows you to export data from Teradata in a relative fast way. Let us look at the script:
.LOGTABLE tom.invoer_log;
.logon 192.168.178.13/tom,******;
database tom;
.BEGIN EXPORT SESSIONS 2;
.EXPORT OUTFILE C:\Users\tomva\Documents\invoer.txt
MODE RECORD FORMAT TEXT;
SELECT CAST(leeftijd AS CHAR(10)),
CAST(nummer AS CHAR(10))
FROM
invoer;
.END EXPORT;
.logoff;
The script can be evoked by “fexp < t.txt”, t.txt being the name of the script. The output then looks like:
