Example 1 - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2018-10-10
dita:mapPath
lsl1527114222348.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following examples show three ways to specify the relationship between the fields of input data records and the columns of the target table, using targetable as the target object name.

  • Using the tname .* Specification
    .LAYOUT lname;
    .TABLE  targetable;
    .DML LABEL label;
    INSERT INTO targetable .*; 
  • Using the cname Specification
    .LAYOUT lname;
    .FIELD first 1 somedatatype;
    .FIELD f2nd * anydatatype;
    .FIELD flast * datatype;
    .DML LABEL label;
    INSERT INTO targetable (col1, col2, ... colast)
    VALUES (:f2nd, :first, ... :flast); 
  • Using the VALUES fieldname Specification
    .LAYOUT lname;
    .FIELD first 1 somedatatype;
    .FIELD f2nd * anydatatype;
    .FIELD flast * datatype;
    .DML LABEL label;
    INSERT INTO targetable VALUES (:first, :f2nd, ... :flast);