-
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;