-
Select to open Teradata FastLoad from the Windows desktop.
-
Use the BEGIN LOADING command.
Because the Teradata Access Module for OLE DB returns data in a format that includes indicator bits, specify the INDICATORS option in the FastLoad BEGIN LOADING command
-
For the AXSMOD specification, use OLEDB_AXSMOD as the DLL for the Teradata Access Module for OLE DB.
-
Use the DEFINE command to specify the fields to load.
-
Specify the one of the following for the file parameter and operating specification:
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: FastLoad Load
LOGON DELL2300/taste,taste ;
DATABASE test2 ;
CREATE TABLE "unittestmixtablefe1_29"
(colinteger INTEGER,
colsmallint SMALLINT,
Colbyteint SMALLINT);
BEGIN LOADING "unittestmixtablefe1_29"
ERRORFILES unittestmixtablefe1_29_errors1, unittestmixtablefe1_29_errors2
INDICATORS;
AXSMOD Oledb_Axsmod "noprompt";
DEFINE colinteger (INTEGER),
colsmallint (SMALLINT),
colbyteint (SMALLINT)FILE=Myfile.amj;
INSERT INTO "unittestmixtablefe1_29"(colinteger, colsmallint, and colbyteint)
VALUES (:colinteger, :colsmallint, :colbyteint);
END LOADING;
LOGOFF;