When an Update operator 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 Update operator job.
RELEASE MLOAD is a Teradata SQL statement that may 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.