RE: Attempting to set PDQPRIORITY via CLI Client

Doesn't setnet32 allow you to set environment variables? You could then set PDQPRIORITY within it. The problem then is that you would be setting it for that machine as a whole, instead of a single query. You would have to run setnet32 after the query completed to unset PDQPRIORITY. > John, > You can also specify it within $INFORMIXDIR/etc/informix.rc. > Unfortunately, it becomes the default for all queries. > > I am not aware of another solution using Informix provided > ODBC drivers. Even the Informix SDK 3.3 fails to address this issue. > We are faced with this same dilemma for user queries > initiated through Business Objects. > > Rick > > > -----Original Message----- > From: Porcello, John [mailto:jep-corp@kaman.com] > Sent: Thursday, July 29, 1999 07:48 > To: Informix (E-mail) > Subject: Attempting to set PDQPRIORITY via CLI Client > > > Hi All, > > I am attempting run parallel DSS queries utilizing a ODBC/CLI-32 connection > to a 7.30 engine (UNIX). I cannot figure out where to specify this other > than within the SQL statement. Hence, while utilizing reporting software > (Impromptu) on the client, I cannot add the SQL entry. While running > dbaccess on the database host I am able to "set PDQPRIORITY 100;" within the > SQL statement and/or "set PDQPRIORITY=100" as an environment variable, the > query then runs in parallel. > > TIA, > John E. Porcello, Jr., ICP, MCSE > Corporate DBA > Kaman Corporation > jep-corp@kaman.com > > My views and opinions may not reflect those of Kaman Corporation. Mark Collins mcollins@us.dhl.com