15.10 - Examples Using PM/API and Open APIs - 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 different uses of the query band APIs.

 

You can use ...

To ...

MONITOR QUERYBAND or MonitorQueryBand

return the concatenated query band for session number 1102 on host ID 20 running on vproc 16383.

GetQueryBand or GetQueryBandSP

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

GetQueryBandValue

query the DBQLogTbl based on names and values specified in the query band name input argument.

GetQueryBandValueSP

search the session name-value pairs in the query band and return the value that corresponds to the query band name “aa.”

GetQueryBandPairs

return the query band in name and value columns.