Example 1 - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
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);