15.10 - QUERY_BAND - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Modify the default query band defined in the profile. The name-value pairs you specify replace any existing query band settings. Changes to the profile query band of currently logged on users take effect on the next request.

You must enclose the set of name=value pairs for the query band with APOSTROPHE characters (').

The number of name=value pairs is limited to the maximum length of the string, which is 2,048 UNICODE characters, including pad characters.

Names and values cannot contain any of the following characters:
  • SEMICOLON (;)
  • a null

If an APOSTROPHE character is embedded within a pair name or value, you must type it twice, to escape it. Otherwise, the system interprets it as a pair_name=pair_value string terminator.

Do not specify reserved pair names or values. For a list of reserved query band names and values, see SQL Data Definition Language - Detailed Topics, B035-1184.
QUERY_BAND
Keyword to introduce query band options you specify.
pair_name
Name component of a query band specification.
The maximum size for each pair_name is 128 UNICODE characters. For more information about database object names, see SQL Fundamentals, B035-1141.
pair_value
Value component of a query band specification.
pair_value can be up to 256 UNICODE characters in length.
NULL
Removes the entire query band from the profile.
DEFAULT
The values are set as default values that can be overwritten using the SET QUERY_BAND statement for the session or transaction. See SET QUERY_BAND.
NOT DEFAULT
Overwriting the pairs in the profile query band is not permitted. Any pair in a SET QUERY_BAND statement matching a name in the profile query band will be discarded from the query band.

Examples

MODIFY PROFILE salesprofile AS
  QUERY_BAND = (NOT DEFAULT);
MODIFY PROFILE testprofile AS
  QUERY_BAND = NULL;
MODIFY PROFILE research_and_development AS
 QUERY_BAND = ‘jobtype=test;’ (DEFAULT);