SEL ProxyUser(FORMAT 'X(10)'), ProxyRole(FORMAT 'X(10)'), querytext(FORMAT 'X(40)') from DBC.QryLogV where username='eCRM' order by StartTime, queryid; *** 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; +--------+--------+--------+--------+--------+---------+--------+------+------+------
クエリー ロギングの詳細については、<Teradata Vantage™ - データベースの管理、B035-1093>を参照してください。