16.10 - Exporting from Teradata Database Using BTEQ - Access Module

Teradata Tools and Utilities Access Module Reference

Access Module
July 2017
Programming Reference
  1. Select Start > Programs > Teradata Client > BTEQ to open Teradata BTEQ from the Windows desktop.
  2. For the EXPORT command, specify OLEDB_AXSMOD as the DLL for the Teradata Access Module for OLE DB.
  3. 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