ChangeQueryBand Method (TdConnection)

The Connection 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 TdConnection
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 Connection Level.

Exceptions

Exception	Description
TdException	This version of the Advanced SQL Engine does not support Query Banding.
System.InvalidOperationException	Connection is not open.
System.ArgumentNullException	queryBand is null.

Remarks

Query Bands are only supported when connecting to the Advanced SQL Engine 12.00 or later releases.

When this method is called, a "SET QUERY_BAND .. FOR SESSION" statement is submitted to the Teradata Datbase. The "old" settings are removed, and the "new" settings are created.

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

If this method is called before TdConnection.Open, an InvalidOperationException will get thrown indicating that the connection is not in an open state.

Requirements

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

Reference

TdConnection Class
TdConnection Members