Archives of the TeradataForum

Message Posted: Wed, 15 Nov 2006 @ 22:16:32 GMT

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

<-- Anonymously Posted: Wednesday, November 15, 2006 17:03 -->

Bad syntax; the qualifying phrase FOR SESSION or FOR REQUEST is required.

Also note the restriction that the account used at session logon must be higher priority than the one you are trying to SET dynamically. If you really want to set the alternate priority "at the time of LOGON" then you don't use SET SESSION PRIORITY at all; just say so in the logon, e.g. for BTEQ:

     .LOGON tdpid/username,password,account;

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