Exporting data from Teradata

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: