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

Update table Issue.


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

New User


Joined: 12 Jan 2013
Posts: 2
Location: INDIA

PostPosted: Thu Feb 07, 2013 7:00 pm
Reply with quote

Hi All ,

I have a typical requirement for table security issue. If we are going to update a table ,think like 100 changes will take place due to the query i used , but my requirement is i should have a check like the table should allow us to update /delete only 10 changes at single stretch. ( I want to have this condition at delaration level of table not at writing a query for update process)
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Thu Feb 07, 2013 7:30 pm
Reply with quote

Quote:
I have a typical requirement for table security issue.

not typical just warped/inane

Quote:
( I want to have this condition at delaration level of table not at writing a query for update process)


unfortunately not always You can have what You want
Back to top
View user's profile Send private message
Dineshec

New User


Joined: 12 Jan 2013
Posts: 2
Location: INDIA

PostPosted: Fri Feb 08, 2013 4:12 pm
Reply with quote

Are you telling me its not possible!!! I am trying my luck with some of options like UPDATE on RESTRICT , OPTIMIZE in DB2. The main problem is i can use them in query level execution not at DBA Level. And also The aim is to restrict the updation of table rows to some limit when we run a SPUFI.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada

PostPosted: Fri Feb 08, 2013 9:34 pm
Reply with quote

Well, I suppose you could use the DB2 resource governor to severely restrict your queries so that they fail after a very small number of updates. But that would be very imprecise and would frustrate your users. Not recommended.

Or, stand behind every user who has update authority and rap them with a cricket bat whenever they compose an update statement that might hit more than 10 rows.

Or, revoke update access from <everyone>. Only allow updates via a program / plan that enforces your restriction.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Feb 08, 2013 9:48 pm
Reply with quote

Quote:
I'm going to give a chainsaw to all my employees.
How do I restrict the chainsaw so it can only cut straws?
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 SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Pulling a fixed number of records fro... DB2 2
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