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;