16.20 - LDILoadGroup Query Band - 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
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

You set the LDILoadGroup reserved query band to control multi-session isolated loading.

You must first perform a BEGIN ISOLATED LOADING statement with the specified load group value before you set this query band. See BEGIN ISOLATED LOADING.

Example: Setting the LDILoadGroup Query Band

The following example sets the session as a load session for the tables associated with Grp1:
SET QUERY_BAND= 'LDILoadGroup = Grp1;' FOR SESSION;
This example removes the LDILoadGroup query band from the session:
SET QUERY_BAND= 'LDILoadGroup=NONE;' FOR SESSION;