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

Teradata Vantageā„¢ NewSQL Engine Release Summary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Release Notes
Publication ID
B035-1098-162K
Language
English (United States)
Last Update
2019-05-03
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 .