IdentifyDatabase Function | Application Programming Reference | Teradata Vantage - 17.10 - IdentifyDatabase - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

Returns the name of the specified database ID.

Syntax

REPLACE FUNCTION SYSLIB.IdentifyDatabase (
  DatabaseId INTEGER
) RETURNS VARCHAR(128) CHARACTER SET UNICODE
  ...
;

Syntax Elements

DatabaseId
Database ID.

Usage Notes

The IdentifyDatabase function provides similar functionality to the PMPC IDENTIFY DATABASE request. For information about this interface, see IDENTIFY.

Example: Using IdentifyDatabase

SELECT IdentifyUser(blk1userid) as "blocking user",
    IdentifyTable(blk1objtid) as "blocking table",
    IdentifyDatabase(blk1objdbid) as "blocking db"
FROM TABLE (MonitorSession(-1,'*',0)) AS t1
WHERE Blk1UserId > 0;
 *** Query completed. One row found. 3 columns returned.
 *** Total elapsed time was 4 seconds.
blocking user               blocking table             blocking db
--------------------------- -------------------------- -------------
user1                       skewAmp1                   DBaaa