Advance SQL Query Prefix's

I'm in process of collecting all possible prefix postfix variables which can mention in Advance SQL Query tab.

As of now collected variables are

DISABLE_CACHE_HIT

DISABLE_CACHE_SEED

LOGLEVEL

QUERY_SRC_CD

SAW_DASHBOARD

SAW_SRC_PATH

Sample usage:

SET VARIABLE DISABLE_CACHE_HIT=1;

SET VARIABLE LOGLEVEL=7;

For multiple commands to set ?

SET VARIABLE DISABLE_CACHE_HIT=1, DISABLE_CACHE_SEED=1;

If you are using multiple varaibles in prefix make sure there is space in between variables and variables are separated by comma's other wise you may likely hit with following error.

Odbc driver returned an error (SQLExecDirectW).

Error Details

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27002]

Near : Syntax error [nQSError: 26012] . (HY000)