Archives of the TeradataForum

Message Posted: Wed, 21 Feb 2007 @ 22:11:12 GMT

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

<-- Anonymously Posted: Wednesday, February 21, 2007 17:06 -->

Assuming you want "all sessions" and not just a single session, you need to set "use_presence_bits" to Y (which says the Request record parcel contains indicator bits) and the input data should start with IndByte x'7F' (actually only first 4 bits matter, 0111xxxx) followed by the SMALLINT value for mon_ver_id. Should have space for host_id, session_no, user_name but contents of those fields will be ignored based on IndByte flags.

Because some of the returned fields can contain NULL, you may also want to set resp_mode to I so the Response record parcels will include presence indicator bits - but that's a separate question.

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