15.00 - SESSION - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)

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