- Select to open Teradata FastExport from the Windows desktop.
- For the EXPORT command, specify OLEDB_AXSMOD as the DLL for the Teradata Access Module for OLE DB.
- For the .EXPORT OUTFILE and operating specification, use one of the following, where an .amj file is a previously saved access module job:
FILE Parameter |
Operating Specification |
Outcome |
"<pathame>.amj" |
'noprompt' |
Script runs if no errors exist. If errors exist, the script fails. |
"<pathame>.amj" |
'<blank>' |
The Teradata OLE DB AXSMOD dialog box appears so you can run the script using the Teradata Access Module for OLE DB. |
"UNTITLED" |
'noprompt' |
Script fails. Instead, specify an .amj file name instead of UNTITLED. |
"UNTITLED" |
'<blank>' |
The Teradata OLE DB AXSMOD dialog box appears. |
Example: FastExport
.LOGTABLE job_account_Log;
LOGON perform/test,test ;
DATABASE test2 ;
.BEGIN EXPORT SESSIONS 4 ;
SELECT name, salary FROM job_account ;
.EXPORT OUTFILE "Untitled" AXSMOD Oledb_Axsmod 'noprompt';
.END EXPORT ;
.LOGOFF ;