16.20 - END ISOLATED LOADING - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Purpose

Ends the explicit concurrent isolated load operation for the specified load group value.

Required Privileges

You must have the INSERT, UPDATE, or DELETE privilege on the base table associated with the load operation.

Syntax



Syntax Elements

CONCURRENT
Keyword you can include for readability.
LDILoadGroup= value
For value, you specify the load group in use for the isolated load operation.
OVERRIDE SESSION
Enables you to end the load operation from a different session than the session that issued the BEGIN ISOLATED LOADING statement.

Example: Ending Isolated Loading

This statement ends concurrent isolated loading for the load operation:
END ISOLATED LOADING FOR QUERY_BAND 'LDILoadGroup=Grp1;';

Usage Notes

For a single session load, the END ISOLATED LOADING statement must be issued by the same session as the BEGIN ISOLATED LOADING statement, unless you specify the OVERRIDE SESSION option. In a multiple session load, the END ISOLATED LOADING statement can be issued from any load session.

The END ISOLATED LOADING statement must be the last statement in an explicit transaction.

After you issue the END ISOLATED LOADING statement, you must use SET QUERY_BAND statement to set the LDILoadGroup query band to NONE.