Re: Locking And Stored Procedure

In article <2F75D678briatico@gate.net> briatico@gate.net (Joseph Briatico) writes: >Path: logica.co.uk!pipex!howland.reston.ans.net!news.sprintlink.net!tequesta.gate.net!mailhost.gate.net!briatico >From: briatico@gate.net (Joseph Briatico) >Newsgroups: comp.databases.informix >Subject: Locking And Stored Procedure >Date: Sun, 26 Mar 1995 13:02:48 >Organization: General Mills >Lines: 22 >Message-ID: <2F75D678briatico@gate.net> >NNTP-Posting-Host: orfl-33.gate.net >Mime-Version: 1.0 >Content-Type: text/plain; charset="us-ascii" >X-Mailer: InternetWorks Mail and News 1.1 I guess you'll have to use a cursor inside the procedure which (implicitly) locks the rows and return from the procedure WITH RESUME?! >Can anyone help me with the following challenge? >We are trying to do all of our Updates and Inserts in stored procedures. >This is du to the fact that our users may get report tools they can use >to look at the data in our Informix database. We don't want our users >to be able to change data with these tools. Therefore, we are trying >to remove all write access from our users. >Anyhow, we want to lock our data before we give the user to ability >to change it. >Can we somehow have the user lock the data and then call a stored >procedure to actually update it? >Does anyone have any ideas? >Thanks, >Joe Briatico