MVSFORUMS.com

maxisnowhere · Beginner Joined: 25 May 2005 Posts: 59 Topics: 20

Hi guys,

I need to do an INSERT on a table, and a colun is the user who made this operation. Do you know any trick to do that?

thanks a lot
_________________
Maxisnowhere

kolusu · Posted: Wed Feb 21, 2007 11:08 am Post subject:

maxisnowhere,

if you have character column of 8 bytes then you can use the CURRENT SQLID which is the authorization ID that is used as the implicit qualifier of table, view, and index names in dynamic SQL statements. The SQL ID, along with the other authorization IDs of a
process, is used for authorization checking of dynamic SQL statements.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu