-
Select to open Teradata TPump from the Windows desktop.
-
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.
-
For the AXSMOD specification, use OLEDB_AXSMOD as the DLL for the Teradata Access Module for OLE DB.
-
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;