Re: PDQPRIORITY and POWERPLAY (Impromptu)

Peter Marley <peter.marley@acco-uk-co.uk> wrote in article <912002145.4116.0.nnrp-04.9e98ba55@news.demon.co.uk>... > Hello, > > has anybody managed to get PowerPlay/Impromptu to take advantage of PDQ > using either the public/private environment variable PDQPRIORITY? > > I can get DBACCESS to work with PDQ without having to use an SQL SET > PDQPRIORITY statement, but when I try using IMPROMPTU the process is not > using PDQ. > > <snip> This is easily done with the OpenLink Multi-tier ODBC drivers (and possibly with other server-based drivers from other vendors). With OpenLink, you can set up a "rule book" on the server that will allow you to specify (among other things) an SQL script to run upon the startup of each session. In this SQL script, you can do a "set pdqpriority" statement to enable PDQ. The rule book allows you to specify different SQL scripts (and other parameters) based upon host name, application name, user name, database, etc. I have used this feature to enable PDQ, set isolation levels and set lock modes for various ad-hoc query tools and other client-server applications. A two concurent-user evaluation version of the Openlink driver can be downloaded from http://www.openlinksw.com. HTH Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com Remove anti-spam characters from e-mail address when responding.