Teradata fast export example

/* this is the log table in the db */
.LOGTABLE DbName.FastExportLogTable;

/* DBC logon string */
.LOGON teraSrv/userName,SecretPass;

/* always use this before export */
.BEGIN EXPORT;

/* where to export to */
.EXPORT OUTFILE simple.csv;

/*run the actual query */
SELECT TRIM(CAST(ColA AS VARCHAR(1000))) || '|' || TRIM(CAST(ColB AS VARCHAR(1000))) FROM DbName.TableName ;

/* always use this after export */
.END EXPORT;

/* disconnect from the DBS */
.LOGOFF ;