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);