Archives of the TeradataForum

Message Posted: Wed, 25 Aug 2004 @ 13:11:41 GMT

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

We have a WEBFOCUS server that is passing the Teradata a query using the following WEBFOCUS syntax :"JOIN tablename.emp_No IN tablename TO ALL personel.job_no IN personel AS J0. The result is an almost instantaneous initiating of 10,000 to 60,000+ queries. We are looking for a way to obtain the network identification of the workstation or user that is initiating the WEBFOCUS queries.

Does anyone know if WEBFOCUS keeps a log file of this information, if so where is and how can it be accessed? Or is there a way to force the WEBFOCUS ODBC connection to 'default' and pass the workstation id of the person initiating the query?

Any help would be appreciated ..thanks

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