RE: Attempting to set PDQPRIORITY via CLI Client

Rick, Thanks for the reply, is $INFORMIXDIR/etc/informix.rc on the PC client? What should this file look like, I don't seem to have it. My INFORMIXDIR on the client is D:\\Program Files\\Informix Thanks, John -----Original Message----- From: Bernstein, Rick [mailto:rbernste@alarismed.com] Sent: Thursday, July 29, 1999 12:22 PM To: 'Porcello, John'; Informix (E-mail) Subject: RE: Attempting to set PDQPRIORITY via CLI Client 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.