Re: PDQPRIORITY and POWERPLAY (Impromptu)

In article <01be19ba$619dde20$0b9c8318@irwin.ce.mediaone.net>, "Irwin Goldstein" <irwinNOSPAM@NOSPAMobjectsoft.comNOSPAM> wrote: > 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. Just to clarify, the relevant places you can put this are [Environment INFORMIX7] (if it's Informix you're running) or if you create a short text file, pdq.sql for example, you can make it execute by putting CommandLine=+initsql pdq.sql in the [generic_inf7] section. Hope this helps, ~Tim -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own