Loading to Teradata Database Using FastLoad - Access Module

Teradata Tools and Utilities Access Module Reference

Product
Access Module
Release Number
16.10
Published
July 2017
Language
English (United States)
Last Update
2019-03-27
dita:mapPath
amk1499705096540.ditamap
dita:ditavalPath
amk1499705096540.ditaval
dita:id
B035-2425
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. Select Start > Programs > Teradata Client > FastLoad to open Teradata FastLoad from the Windows desktop.
  2. 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
  3. For the AXSMOD specification, use OLEDB_AXSMOD as the DLL for the Teradata Access Module for OLE DB.
  4. Use the DEFINE command to specify the fields to load.
  5. 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 access module.
    "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;