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)
Posts
