V10, PDQ, Business Objects and ODBC

Posted in 2009

Topics: Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues

Andrew Grantham — Tue, 15 Dec 2009 11:04:00 — source: IIUG Forums & Mailing Lists

Hello All, I am using Informix V10 on Sun Solaris ( different versions ). I would like to use PDQ for queries coming from Business Objects. I gather they use ODBC connections. Is there a way I can include PDQPRIORITY directives within ODBC definitions, BO configuration files etc etc? All thoughts and experiences welcome. Regards Andy G. _________________________________________________________________ Add your Gmail and Yahoo! Mail email accounts into Hotmail - it's easy http://clk.atdmt.com/UKM/go/186394592/direct/01/

↪ replying to Andrew Grantham

Obnoxio The Clown — Tue, 15 Dec 2009 11:09:35 — source: IIUG Forums & Mailing Lists

Andrew Grantham wrote: > Hello All, > > I am using Informix V10 on Sun Solaris ( different versions ). > > I would like to use PDQ for queries coming from Business Objects. I gather > they use ODBC connections. Is there a way I can include PDQPRIORITY directives > within ODBC definitions, BO configuration files etc etc? All thoughts and > experiences welcome. I don't know, but if you don't get a better answer, is it feasible for you to bring the engine up with PDQ set? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

↪ replying to Andrew Grantham

Art Kagel — Tue, 15 Dec 2009 11:41:43 — source: IIUG Forums & Mailing Lists

If you upgrade to v11.50 you can use the connection procedure (which, once you define it, is executed whenever a users connects to the instance) to set the PDQPRIORITY for each user based on their userid. That would work regardless of the connection type. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Dec 15, 2009 at 6:04 AM, Andrew Grantham <agrantha@hotmail.com>wrote: > Hello All, > > I am using Informix V10 on Sun Solaris ( different versions ). > > I would like to use PDQ for queries coming from Business Objects. I gather > they use ODBC connections. Is there a way I can include PDQPRIORITY > directives > within ODBC definitions, BO configuration files etc etc? All thoughts and > experiences welcome. > > Regards > > Andy G. > > _________________________________________________________________ > Add your Gmail and Yahoo! Mail email accounts into Hotmail - it's easy > http://clk.atdmt.com/UKM/go/186394592/direct/01/ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517440f9a2e4f41047ac2df65