ACCOUNT
Purpose
Returns the account string 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 ACCOUNT are as follows:
Data Type |
Format |
Title |
VARCHAR(30) CHARACTER SET UNICODE |
X(30) |
Account |
Usage Notes
If a SET SESSION ACCOUNT statement has changed the current account string, then the ACCOUNT function returns the new account string based on the request level: whether for an entire session or for an individual request.
Example
The following statement requests the account string for the current user:
SELECT ACCOUNT;
The system responds with something like the following:
Account
------------------------------
$M_D2102