Using GetQueryBandValueSF to Query QryLogV
This example shows you how to query the DBC.DBQLogTbl table for all Teradata brands specified in the QueryBand column.
SELECT t1.queryband(FORMAT 'X(50)') FROM
dbc.dbqlogtbl t1
WHERE GetQueryBandValueSF(t1.queryband, 0, 'brand') = 'teradata'
AND username='qbuser' ORDER BY t1.queryid;
Result:
QueryBand -------------------------------------------------- =T> game=monopoly;brand=teradata; =T> game=monopoly;brand=teradata; =T> game=monopoly;brand=teradata; =T> game=monopoly;brand=teradata;
Using GetQueryBandValueSF to Query DBQLogTbl (QryLogV)
This example shows how to query the DBC.DBQLogTbl table for all cat names specified in the QueryBand column.
SEL GetQueryBandValueSF(t1.queryband, 0, 'cat') FROM
dbc.dbqlogtbl t1 where
GetQueryBandValue(t1.queryband, 0, 'CAT') IS NOT NULL
AND username='qbuser' ORDER BY t1.queryid;
Result:
GetQueryBandValueSF(QueryBand,0,'cat') ------------------------------------------------------------------------ asta asta asta asta asta asta asta sabella sabella sabella sabella sabella sabella sabella sabella sabella sabella sabella