Our DBA asked me to try putting an extra SET statement in before the SQL
that Business Objects generated. The SQL would look something like:
SET PDQPRIORITY LOW;
SELECT stu_wsu_num
FROM informix.student;
I tried editing the SQL that Business Objects generated and I also tried
typing in the SQL in the Freehand SQL section as well. In both places,
Business Objects won’t let me do it. So, I have 2 questions:
Is there a way for me to put this SET statement in on an occasional basis?
Is there a way for me to tell Business Objects to automatically put the
SET statement in on every query?
Any help with this would be appreciated.
Thanks,
Dennis Edgecombe
Washington State University
dennis_edgecombe@wsu.edu
If you look at the contents of the \Informix subfolder of your BO main
folder, you should find a file that has the .SBO extension. After
you opened this file, you should a entry that reads
EmptySPParamList=()
I have not tried this myself so I cold be way off. Nonetheless, If I were
you, I would try to put between the () the SET PDQPRIORITY LOW; your DBA
wants use in your queries.
Let me know. My 2 cents…
Alain.
-----Original Message-----
Behalf Of Dennis Edgecombe
Sent: Thursday, February 11, 1999 11:51 AM
Our DBA asked me to try putting an extra SET statement in before the SQL
that Business Objects generated. The SQL would look something like:
SET PDQPRIORITY LOW;
SELECT stu_wsu_num
FROM informix.student;
I tried editing the SQL that Business Objects generated and I also tried
typing in the SQL in the Freehand SQL section as well. In both places,
Business Objects won’t let me do it. So, I have 2 questions:
Is there a way for me to put this SET statement in on an
occasional basis?
Is there a way for me to tell Business Objects to automatically put the
SET statement in on every query?
Any help with this would be appreciated.
Thanks,
Dennis Edgecombe
Washington State University
dennis_edgecombe@wsu.edu