Re: Change Lock Mode For Session
sysdbopen only works on V11.1+ the reference on manual v10 states it's an XPS only feature. Regards. On Tue, Mar 23, 2010 at 1:01 PM, Plugge, Joe R. <JRPlugge@west.com> wrote: > James, > > > > Providing that you are using IDS 10 or higher, you can leverage *sysdbopen > *. > > > > > http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?tab=search&searchWord=sysdbopen > > > > Thanks to David Link , as I knew it was possible, just could not remember > the name of the component… ! > > > > > > > > *To set the initial environment for one or more sessions, create and > install the sysdbopen( ) SPL procedure. The primary function of these > procedures is to initialize properties of a session without requiring the > properties to be explicitly defined within the session. These procedures are > executed whenever users connect to a database where the procedures are > installed. Such procedures are useful if users access databases through > client applications that cannot modify application code or set environment > options or environment variables.* > > *You can also create the sysdbclose( ) SPL procedure which is executed > when a user disconnects from the database.* > > * * > > > > [image: image001]*Joe R. Plugge* > > *Database Administrator, West Interactive Corporation* > > *11650 Miracle Hills Drive, Omaha NE 68154* > > *402-716-0349 | Cell 402-517-2710 | jrplugge@west.com** * > > * * > > > > > > *From:* informix-list-bounces@iiug.org [mailto: > informix-list-bounces@iiug.org] *On Behalf Of *James Brunskill > *Sent:* Monday, March 22, 2010 11:11 PM > *To:* informix-list@iiug.org > *Subject:* Change Lock Mode For Session > > > > Hi All, > > > > Is there any way to force a particular lock mode on a informix session? > > I have a client app connecting to my database with lock mode set to not > wait. > > This lack of a short wait can cause issues with a locking due to a manual > process I’m running over the data currently. > > Changing the client application to get it to set the lock mode isn’t easy > to do at this stage J > > > > Regards, > > > > James Brunskill > > Computer Engineer - Manufacturing Execution Systems > > Automation & Process Control Group > > NZ Technical > > Fonterra > > Fonterra Extn: 77808 > > Ext Line: +64 7 849 2411 x 77808 > > email: james.brunskill@fonterra.com<jarrod.teale@fonterra.com> > > > > DISCLAIMER: > This email contains confidential information and may be legally privileged. > If you are not the intended recipient or have received this email in error, > please notify the sender immediately and destroy this email. > You may not use, disclose or copy this email or its attachments in any way. > Any opinions expressed in this email are those of the author and are not > necessarily those of the Fonterra Co-operative Group. > http://www.fonterra.com/ > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...