Syntax - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
aim1544831946660.ditamap
dita:ditavalPath
gyk1507317446489.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities


The circled 5 in the syntax diagram above indicates that the items beneath it can be repeated five times.

where:

dbname
Name of the database where the target table to release exists.
The default is the database name associated with the user name specified in the BTEQ LOGON command. BTEQ searches for the tablename table in that database unless this option specifies another database name.
IN APPLY
Teradata MultiLoad task that was in the application phase when it was suspended. The Upload operator task that was in the application phase when it was suspended.
The IN APPLY option cannot be used to release the locks that were placed on the Teradata MultiLoad target tables during the acquisition phase. The IN APPLY option cannot be used to release the locks that were placed on the Update Operator target tables during the acquisition phase. In this case, use the RELEASE MLOAD statement without the IN APPLY option.
tablename
Name of the Teradata MultiLoad target table. Name of the Update operator target table.
The RELEASE MLOAD statement frees the target tables, but does not delete the error tables, the work tables, or the restart log table. They remain in the database, and must be dropped manually to free up the space and avoid conflicts when resubmitting the Teradata MultiLoad job. They remain in the database, and must be dropped manually to free up the space and avoid conflicts when resubmitting the Update Operator job.