SESSION
Purpose
Returns the number of the session for the current user.
Syntax
ANSI Compliance
This is a Teradata extension to the ANSI SQL:2011 standard.
Result Type and Attributes
The data type, format, and title for SESSION are as follows:
Data Type |
Format |
Session |
INTEGER |
Default format for the INTEGER data type. For more information on the default formats, see “Data Type Formats and Format Phrases” in SQL Data Types and Literals. |
Session |
Example
The following statement identifies the number of the session for the current user:
SELECT SESSION;
The system responds with something like the following:
Session
-----------
1048