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
 
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: 10375
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: 659
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: 1281
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 ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts SIGNAL ON HALT issue packerm CLIST & REXX 1 Fri Oct 20, 2017 6:56 pm
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 Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm

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