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
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