how to insert sql statement in Brio query

[seng]

Hi all,

I am currently using Brio Query Explorer 6.2.1.27
I face question on putting my own sql statement in the query before i run the actual select statement.

What i wanted to put is a set sql statement such as:

SET PDQPRIORITY HIGH

before i run the actual select statement so that enough memory is used to process this query.

(PDQPRIORITY is related to informix IDS 7.3 database setting requirements)

Can someone please help me?

 

[nthg2say]

use Brio 6.5 DataModel/ Audit /preProcess SQL