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.
- IN APPLY
-
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 Update Operator target tables during the acquisition phase. In this case, use the RELEASE MLOAD statement without the IN APPLY option.
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 Update Operator job.