SetSessionAccount Syntax - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248
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.
If you specify Y or y, the change applies to all current and future requests for a specified session. If no requests or steps are running, the new account or priority takes effect at the next request, and the DBC.SessionTbl table reflects the new account or priority for the current session.
If you specify NULL, blank, N, or n, the change applies only to the current request for the specified session. If no request is running, the next request for the specified session has the old account/priority.