17.10 - Loading to a Database Using TPump - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
uur1608578381725.ditamap
dita:ditavalPath
obe1474387269547.ditaval
  1. Select Start > Programs > Teradata Client > TPump to open Teradata TPump from the Windows desktop.
  2. Use the .LAYOUT command.
    Because the Teradata Access Module for OLE DB returns data in a format that includes indicator bits, specify the INDICATORS option in the TPump .LAYOUT command.
  3. For the AXSMOD specification, use OLEDB_AXSMOD as the DLL for the Teradata Access Module for OLE DB.
  4. Use the TPump IMPORT command to specify the following:
    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: TPump Load

.LOGTABLE test.precision_log;
LOGON wuscaesc/tester,dbc;
DATABASE test ;
DROP TABLE "TestPrecision";
DROP TABLE "precision_err";
CREATE TABLE "TestPrecision"(
   munie decimal(18,4));
.BEGIN LOAD SESSIONS 1
   ERRORTABLE "precision_err"
   NOMONITOR
   ROBUST ON;
.LAYOUT precision_layout INDICATORS; 
.FIELD munie * decimal(18,4);
.DML LABEL precision_label;
INSERT INTO "TestPrecision"(munie) VALUES(:munie);
.IMPORT INFILE "C:\WINNT\Profiles\Personal\sql_test08.amj" 
   AXSMOD OLEDB_AXSMOD 'noprompt' 
   LAYOUT precision_layout
   APPLY precision_label;
.END LOAD;
.LOGOFF;