Loading to a Database Using MultiLoad - Access Module

Teradata® Tools and Utilities Access Module Reference

Product
Access Module
Release Number
17.00
Published
November 30, 2020
Language
English (United States)
Last Update
2020-11-18
dita:mapPath
sch1544831938749.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2425
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. Select Start > Programs > Teradata Client > MultiLoad to open Teradata MultiLoad from your 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 MultiLoad .LAYOUT command.
  3. For the AXSMOD specification, use OLEDB_AXSMOD as the DLL for the Teradata Access Module for OLE DB.
  4. Use the 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: MultiLoad Load

.LOGTABLE newtest.test1_LOG;
.LOGON perform/test,test;
DATABASE test ;
CREATE TABLE "test1"(col1 numeric(3,0));
.BEGIN IMPORT MLOAD TABLES "test1" CHECKPOINT 0;
.LAYOUT test1_layout  INDICATORS; 
.FIELD col1 * numeric(3,0);
.DML LABEL test1_label;
INSERT INTO "test1"(col1) VALUES (:col1);
.IMPORT INFILE "c:\oledb\test1.amj"
      AXSMOD OLEDB_AXSMOD 'noprompt' 
      LAYOUT test1_layout
      APPLY test1_label;
.END MLOAD;
.logoff;