IdentifyUser Function | Application Programming Reference | Teradata Vantage - 17.10 - IdentifyUser - 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 user ID who is causing a block.

Syntax

REPLACE FUNCTION SYSLIB.IdentifyUser (
  UserId  INTEGER
) RETURNS VARCHAR(128) CHARACTER SET UNICODE
  ...
;

Syntax Elements

UserId
ID of the user who is causing the block.

Usage Notes

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

Example: Using IdentifyUser

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