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;
Result:
*** Query completed. One row found. 3 columns returned. *** Total elapsed time was 4 seconds. blocking user blocking table blocking db --------------------------- -------------------------- ------------- user1 skewAmp1 DBaaa