Returns the name of the specified table ID.
Syntax
REPLACE FUNCTION SYSLIB.IdentifyTable (
TableID INTEGER
) RETURNS VARCHAR(128) CHARACTER SET UNICODE
...
;
Syntax Elements
- TableID
- ID of the locked table.
Usage Notes
The IdentifyTable function provides similar functionality to the PMPC IDENTIFY TABLE request. For information about this interface, see IDENTIFY.
Example: Using IdentifyTable
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