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