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
ft:locale
en-US
ft:lastEdition
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);