Changes the account string for the session or for the request.
This function returns the old account string.
Syntax
REPLACE FUNCTION SetSessionAccount ( HostIdIn SMALLINT, SessionNoIn INTEGER, NewAcctString TD_ANYTYPE, EntireSession VARCHAR(1) CHARACTER SET LATIN ) RETURNS VARCHAR(128) CHARACTER SET UNICODE ... ;
Syntax Elements
- HostIdIn
- Logical ID of a host (or client) with sessions logged on.
- SessionNoIn
- Number of the specified session.
- NewAcctString
- Account string for the session or request.
- EntireSession
- Indicator of how the new account or priority affects requests for a specified session.
Usage Notes
The SetSessionAccount function provides similar functionality to the PMPC SET SESSION ACCOUNT request. For information about this interface, see SET SESSION ACCOUNT.
Example: Using SetSessionAccount with MonitorSession
BTEQ -- Enter your DBC/SQL request or BTEQ command: SELECT SetSessionAccount(Hostid, sessionno, 'Accountx','Y') FROM TABLE (MonitorSession(1,'twmuser3',0)) AS t1; SELECT SetSessionAccount(Hostid, sessionno, 'Accountx','Y') FROM TABLE (MonitorSession(1,'twmuser3',0)) AS t1; *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. SetSessionAccount(HostId,SessionNo,'Accountx','Y') -------------------------------------------------- ACCOUNT3
Example: Using SetSessionAccount
BTEQ -- Enter your DBC/SQL request or BTEQ command: SELECT SetSessionAccount(1, 4461, 'Account3','y'); SELECT SetSessionAccount(1, 4461, 'Account3','y'); *** Query completed. One row found. One column returned. *** Total elapsed time was 1 second. SetSessionAccount(1,4461,'Account3','y') ---------------------------------------- ACCOUNTX