There are many operators in MLOAD, some are descried as follows:
- .LAYOUT: Reads input variables from a host input data file.
- .BEGIN: Specifies the tables, and optionally, the work and the error tables used in this MultiLoad job. Also used to specify miscellaneous options, such as checkpoint, sessions, and so on.
.BEGIN [IMPORT] [DELETE] MLOADTABLES tname1, tname2, ...WORKTABLES wt_table1, wt_table2 /* could be database.tablename */ERRORTABLES et_table1 uv_table1, et_table2 uv_table2 /* Default ET_Tablename */ERRLIMIT errcount [errpercent] /*Approximate # of data errors permitted during Acquisition */CHECKPOINT rate (Default – 15 min.) SESSIONS limit (Default – 1 per AMP + 2) /* Workload dependent */TENACITY hours (Default ...