IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Identify the user who has updated the row in a table


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Simon Daniel

New User


Joined: 16 Nov 2007
Posts: 2
Location: India

PostPosted: Fri Feb 04, 2011 11:01 pm
Reply with quote

Hi,

Please let me know how to identify the user-id/job name that had updated/inserted one of the rows in a table. I can see the timestamp of when the row had got updated. There are around 10 programs that ran at the same time. I am certain that DBAs will be able to assist me. However, thought of checking the forum before I go to them.

Many Thanks.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Fri Feb 04, 2011 11:21 pm
Reply with quote

Quote:
I am certain that DBAs will be able to assist me. However, thought of checking the forum before I go to them.


then... why should we do the job for which Your colleagues are getting paid for ?
Back to top
View user's profile Send private message
Simon Daniel

New User


Joined: 16 Nov 2007
Posts: 2
Location: India

PostPosted: Sat Feb 05, 2011 12:25 am
Reply with quote

Thanks. I will check with them.
Back to top
View user's profile Send private message
dejunzhu

Active User


Joined: 08 May 2008
Posts: 390
Location: China

PostPosted: Sat Feb 19, 2011 6:50 pm
Reply with quote

I suppose you can see the userid only when the function is coded your own program.

correct me if I'm wrong. thanks.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts PuTTY - "User is not a surrogate... IBM Tools 5
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
Search our Forums:

Back to Top