16.20 - Session Information Function Interface for Table Operators and QueryGrid - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K
A new function, DBSSessionAttrInfo, is available that allows users to get information about system variables and session attributes in a table operator. The function provides the following information about the current session to the table operator or foreign server:
  • Current User Name
  • Current Role Name
  • Transaction Mode
  • Collation

Benefits

A table operator can retrieve information about the current session, such as system variables and session attributes.

Additional Information

For more information about the FNC_DBSSessionAttrInfo function or getDBSSessionAttrInfo() method, see Teradata Vantageā„¢ SQL External Routine Programming , B035-1147 .