Archives of the TeradataForum

Message Posted: Mon, 09 Feb 2004 @ 21:57:33 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: DBC.AccessLog

From:		David Wellman

Hi Rudel,

I'm not sure that I understand the problem that you're having. The Query logging command "Begin Query Logging" contains options (ALL or SQL) which will cause the SQL to be logged along with information about when the query ran, who submitted it etc. This data also includes the return code from the query. I can't remember whether the sql text will include '?' for parameterised queries (i.e. those queries containing data parcels) or the real data values, you'd need to try it.

Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )