Procedure
A complete Teradata MultiLoad job includes:
Use the following procedure as a guide in writing Teradata MultiLoad job scripts.
1 Invoke Teradata MultiLoad, specifying run‑time options:
2 Establish the Teradata MultiLoad support environment as shown in Table 26.
Command |
Description |
Specify an external data source file and character fields for setting utility variables for a Teradata MultiLoad job. |
|
Specify the form of the DATE data type specifications for the Teradata MultiLoad job. |
|
Write a specified text message to a specified file. |
|
Provide conditional control of the execution process. |
|
Establish a session with Teradata Database |
|
Specify the restart log table that will maintain checkpoint information for the Teradata MultiLoad job. |
|
Specify an alternate destination for Teradata MultiLoad utility output messages. |
|
Transfer processing control to an alternate run file. |
|
Assign a value to a specific utility variable for the Teradata MultiLoad job. |
|
Submit an operating system command to the client system. |
|
Teradata SQL statements |
Submit a supported Teradata SQL statement to Teradata Database. |
Note: As a minimum, this part of the Teradata MultiLoad job must include:
3 Specify the Teradata MultiLoad task as shown in Table 27.
Command |
Description |
Signify the beginning of a Teradata MultiLoad import or delete task. |
|
Remove rows from the target tables or views. |
|
Specify a label and error treatment options for one or more immediately following INSERT, UPDATE, or DELETE commands. |
|
Signify the end of the Teradata MultiLoad task and initiate the task processing. |
|
Specify a field of the input record to be used to supply values for variables in the SELECT statement. |
|
Describe a field of the input data record that is not referenced, but used only to indicate the relative position of the following FIELD command data. |
|
Specify either a file name or an INMOD routine as the input data source, referencing a previously specified LAYOUT command. |
|
Add new rows to the target tables or views. |
|
Specify, in conjunction with immediately following FIELD, FILLER, or TABLE commands, the layout of the input data records on the client system. (Reference this layout specification in a subsequent IMPORT command.) |
|
Pause an import task during the acquisition phase. |
|
Specify a table whose column names and data descriptions are used with the data records sent to Teradata Database. |
|
Change the field values in existing rows of the target tables or views. |
4 To specify another Teradata MultiLoad task:
a Use the support commands listed in Step 2 to modify the Teradata MultiLoad support environment for the next task.
b Use the task commands listed in Step 3 to specify the next task.
Repeat these steps for each task in a Teradata MultiLoad job.
5 Use the LOGOFF command to disconnect all active sessions with Teradata Database and terminate Teradata MultiLoad on the client system.