SEL ProxyUser(FORMAT 'X(10)'), ProxyRole(FORMAT 'X(10)'), querytext(FORMAT 'X(40)') from DBC.QryLogV where username='eCRM' order by StartTime, queryid;
Result:
*** Query completed. 4 rows found. 3 columns returned. *** Total elapsed time was 1 second. ProxyUser ProxyRole QueryText ---------- ---------- -------------------------------------------------------------- DG708 Web SET QUERY_BAND = 'PROXYUSER=DG708’ DG708 Web SEL * FROM table5; DG708 Web INS table5(c1Val,c2Val); DG708 Web SEL * FROM table5; +--------+--------+--------+--------+--------+---------+--------+------+------+------
For more information on Query Logging, see Teradata Vantage™ - Database Administration, B035-1093.