When a Teradata MultiLoad task has been suspended or aborted before the end of the application phase, the RELEASE MLOAD statement removes the access locks from the target tables in the database and inhibits any attempts to restart the Teradata MultiLoad utility.
RELEASE MLOAD is a Teradata SQL statement that is recognized by BTEQ and Teradata MultiLoad. RELEASE MLOAD may be used in a Teradata MultiLoad job script or in an interactive Teradata MultiLoad session. It may also be used in BTEQ. Log on to BTEQ to enter the RELEASE MLOAD statement. Do not use a leading period (.) when using the RELEASE MLOAD statement in BTEQ.