Example: Inserting into a Table with an Explicit Isolated Load Operation - Teradata Database - Teradata Vantage NewSQL Engine

For information on defining a load isolated table and performing an explicit isolated load operation, see the WITH ISOLATED LOADING option for CREATE TABLE and ALTER TABLE, in addition to Load Isolation Statements in Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144.

Following are the table definitions for the example.

CREATE TABLE ldi_table1,
     WITH CONCURRENT ISOLATED LOADING FOR ALL
     (a INTEGER,
      b INTEGER,
      c INTEGER)
PRIMARY INDEX ( a );


CREATE TABLE t1
     (c1 INTEGER,
      c2 INTEGER,
      c3 INTEGER)
PRIMARY INDEX ( c1 );

 BEGIN ISOLATED LOADING ON ldi_table1 
    USING QUERY_BAND 'LDILoadGroup=Load1;';

SET QUERY_BAND='LDILoadGroup=Load1;' FOR SESSION;

 INSERT INTO ldi_table1 SELECT * FROM t1 WHERE c1 > 10;

END ISOLATED LOADING FOR QUERY_BAND 'LDILoadGroup=Load1;';

SET QUERY_BAND = 'LDILoadGroup=NONE;' FOR SESSION;