15.10 - Functionality - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

The following table describes the query band interfaces that are used to track system usage and manage task priorities.

 

If you want to ...

Use the following SQL interface ...

Or, the following CLIv2 or Teradata JDBC Driver request ...

return the name and value pairs in the query band

“GetQueryBandPairs” on page 441

return the concatenated query band for the current transaction and session

“GetQueryBand” on page 440

or

“GetQueryBandSP” on page 443

return the value of the specified name in the current query band or NULL

“GetQueryBandValue” on page 444

or

“GetQueryBandValueSP” on page 447

return the concatenated query band for the specified session

“MonitorQueryBand” on page 449

“MONITOR QUERYBAND” on page 435

return all query band names and descriptions, including those dropped from a release

“QueryBandReservedNames_TBF” on page 451