Re: Setting PDQPRIORITY & OPTIMIZATION from ODBC

Posted in 1997

Nils Myklebust — Sun, 23 Mar 1997 20:15:34 GMT — source: Informix-list mailing list archive (1991-1998)

stiglich@promarkone.com wrote: : : :Hello, : : Does anyone know if it is possible to set PDQPRIORITY & OPTIMIZATION :from an ODBC connected client? We would like to be able to set these to :different levels for different applications : :Thanks : :Pete Anything that can be done via an SQL command can be done via ODBC by using the SQL Passthrough option. Proprietary SQL commands are then sent untranslated through ODBC to the database. Be aware that in some cases you may inadvertantly get multiple connections to the database when using ODBC and your setting may not apply to all of them. Also if you use the OpenLink drivers you can specify a set of commands that are executed whenever a connection is established. Via this mechanism you may set any number of options. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org