GetQueryBand Function | Application Programming Reference | Teradata Vantage - 17.05 - GetQueryBand - Teradata Database

Teradata Vantage™ - Application Programming Reference

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1090-170K

Purpose

Returns the concatenated query band string for the current transaction, session, and profile.

Definition

REPLACE FUNCTION SYSLIB.GetQueryBand()
RETURNS VARCHAR(12304)CHARACTER SET UNICODE,
          .
          .
          .
;

Usage Notes

The GetQueryBand function can be used in a SELECT statement and an input parameter for a table function.

This function is created in the SYSLIB database by the DEM DIP script. EXECUTE privileges are granted to PUBLIC by default. For more information, see Requirements for Using the API.

Return Value

The GetQueryBand function returns the concatenated transaction, session, and profile query bands.

Example: Using GetQueryBand

SELECT GetQueryBand();
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.
GetQueryBand()
-------------------------------------------------------------------
=S> a=1;b=2;c=3;d=4;

Related Topics

For information on setting the query band for a session or transaction, see SET QUERY_BAND in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

For information on setting a profile query band, see CREATE PROFILE in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.