Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Update table Issue.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Update table Issue.
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Thu Feb 07, 2013 7:30 pm    Post subject: Reply to: Update table Issue.
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    Post subject: Update table Issue
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: 642
Location: Whitby, ON, Canada

PostPosted: Fri Feb 08, 2013 9:34 pm    Post subject:
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: 1278
Location: Belgium

PostPosted: Fri Feb 08, 2013 9:48 pm    Post subject:
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    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 Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts -913/-911 Deadlock during UPDATE stat... NoSleep319 DB2 5 Fri Nov 18, 2016 12:37 am
No new posts How to update a portion of text in a ... Bill Woodger DFSORT/ICETOOL 25 Wed Nov 09, 2016 9:41 pm
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us