Syntax - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™
void
FNC_DbsInfo_EON( dbs_info_eon_t *data )
dbs_info_eon_t *data
the global information, including user account, user name, user ID, and session number.
The dbs_info_eon_t structure is defined as:
typedef struct dbs_info_eon_t {
    Unicode_Text UserAccount[FNC_MAXNAMELEN_EON];
    Unicode_Text UserName[FNC_MAXNAMELEN_EON];
    int      UserId;
    short    StatementNo;
    short    Host;
    int      SessionNo;
    int      RequestNo;
} dbs_info_eon_t;
where:
  • UserAccount specifies the account string of a user.
  • UserName specifies the name of a user.
  • UserId specifies the user ID.
  • StatementNo specifies the current statement number for the request.
  • Host specifies the host ID.
  • SessionNo specifies the session number.
  • RequestNo specifies the current client request number.