ChangeQueryBand Method (TdTransaction)

The Transaction Level Query Bands are modified to those defined in .

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public Sub ChangeQueryBand( _
   ByVal queryBand As TdQueryBand _
)

'Usage
 
Dim instance As TdTransaction
Dim queryBand As TdQueryBand
 
instance.ChangeQueryBand(queryBand)

public void ChangeQueryBand( 
   TdQueryBand queryBand
)

public:
void ChangeQueryBand( 
   TdQueryBand^ queryBand
)

Parameters

queryBand: The Query Bands that will be defined at the Transaction Level.

Exceptions

Exception	Description
TdException	Query Bands or Trusted Sessions are not supported by the Advanced SQL Engine.
System.ObjectDisposedException	Transaction is not opened.
System.ArgumentNullException	queryBand is null.

Remarks

Query Bands are only supported when connecting to a Teradata Database 12.00 or later releases.

When this method is called, a "SET QUERY_BAND ... FOR TRANSACTION" statement is submitted to the Advanced SQL Engine. The old settings are removed, and the new settings are created.

The Transaction Level Query Band is set to NONE when the queryBand input parameter has Zero (TdQueryBand.Count is equal to zero) Key-Value pairs.

The Query Bands that have been defined at the Connection level are still active during the transaction.

Requirements

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

Reference

TdTransaction Class
TdTransaction Members