ARK wrote:
Database: DB2 AIX V8.*
Question: I want to be able to get the 'Client login ID' aka 'Execution
ID' (as opposed to the authid or application_id) for the current
connection within a stored procedure and without requiring SYSADM,
SYSCTRL, SYSMAINT, or SYSMON authority. This would be for audit
purposes as several different people can share an authid.
Does the CURRENT CLIENT_USERID special register give you what you want?
--
Knut Stolze
DB2 Information Integration Development
IBM Germany