Archives of the TeradataForum

Message Posted: Mon, 07 Dec 2009 @ 17:19:11 GMT

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

<-- Anonymously Posted: Monday, December 07, 2009 09:16 -->

Query DBC.SessionInfo; Note that since this is Session info there are often many rows for a utility job.

Filter on Partition if you wish

     GROUP BY LogonSequenceNo,
     CASE WHEN LogonSequenceNo = '00'xb THEN SessionNo END

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