-
Select to open Teradata BTEQ from the Windows desktop.
-
For the EXPORT command, specify OLEDB_AXSMOD as the DLL for the Teradata Access Module for OLE DB.
-
For the FILE parameter 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 access module. |
| "UNTITLED" |
'noprompt' |
Script fails. Instead, specify an .amj file name instead of UNTITLED. |
| "UNTITLED" |
'<blank>' |
The Teradata OLE DB AXSMOD dialog box appears. |
Example: BTEQ Export
.LOGON bubbater/dbc,dbc ;
database bubba ;
.EXPORT indicdata file="C:\fexp.amj" AXSMOD OLEDB_AXSMOD 'noprompt';
SELECT col1, col2 from tst10k ;
.EXPORT reset
.LOGOFF;