Temporal Semantics
DML validtime qualifier and NONTEMPORAL semantics are supported. For more information, see SQL Data Manipulation Language (B035‑1146).
Example
.BEGIN LOAD SESSION number;
.LAYOUT Layoutname;
.TABLE Targetablename;
.DML LABEL DMLlabelname;
INSERT INTO Targetablename.*;
.IMPORT INFILE Infilename LAYOUT Layoutname APPLY DMLlabelname;
.END LOAD;
Example
.LAYOUT lname;
.FIELD first 1 somedatatype;
.FIELD f2nd * anydatatype;
.
.
.
.FIELD flast * datatype;
.DML LABEL label;
INSERT INTO targetable VALUES (:first, :f2nd, ... :flast);
Example
.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);
Example
An input data source contains a series of 10‑ to 40‑byte records. Each record contains the primary index value (EmpNum) of a row that is to be inserted successively into the Employee table whose columns are EmpNo, Name, and Salary.
.BEGIN LOAD SESSION number ;
.LAYOUT Layoutname;
.FIELD EmpNum 1 INTEGER;
.FIELD Name * (VARCHAR (30));
.FIELD Sal * (DECIMAL (7,2));
.DML LABEL DMLlabelname;
INSERT Employee (EmpNo, Name, Salary) VALUES (:EmpNum, :Name, :Sal);
.IMPORT INFILE Infilename LAYOUT Layoutname APPLY DMLlabelname;
.END LOAD;