Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Identify the user who has updated the row in a table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Identify the user who has updated the row in a table
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Fri Feb 04, 2011 11:21 pm    Post subject: Reply to: Identify the user who has updated the row in a tab
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    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts User access certification In Mainfram... Virendra Shambharkar All Other Mainframe Topics 4 Tue Oct 03, 2017 12:32 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us