Using GetQueryBandPairs
The following example shows how to call the GetQueryBandPairs function.
SELECT * FROM TABLE(GetQueryBandPairs(0)) AS t1; *** Query completed. 3 rows found. 2 columns returned. *** Total elapsed time was 1 second. QBName QBValue --------- --------------- ORG FINANCE JOB ENDOFMONTH JOBID 193858
Using GetQueryBandPairs with MonitorQueryBand as Input
The following example shows how to call the GetQueryBandPairs function using the MonitorQueryBand function as input.
SELECT * FROM TABLE(GetQueryBandPairs(MonitorQueryBand(1, 103, 16383), 0)) AS t1; *** Query completed. 3 rows found. 2 columns returned. *** Total elapsed time was 1 second. QBName QBValue ---------- --------------- ORG FINANCE JOB ENDOFMONTH JOBID 193858