Using GetQueryBandValue to Query the QueryBand Column in 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.qrylogv t1
WHERE GetQueryBandValue(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 GetQueryBandValue to Query DBQLogTbl (QryLogV)
This example shows how to query the DBC.DBQLogTbl table for all cat names specified in the QueryBand column.
SEL GetQueryBandValue(t1.queryband, 0, 'cat') FROM
dbc.qrylogv t1 where
GetQueryBandValue(t1.queryband, 0, 'CAT') IS NOT NULL
AND username='qbuser' ORDER BY t1.queryid;
Result:
GetQueryBandValue(QueryBand,0,'cat') ------------------------------------------------------------------------ asta asta asta asta asta asta asta sabella sabella sabella sabella sabella sabella sabella sabella sabella sabella sabella sabella