NQSSetSessionValue() is an ODBC function, can be used to change the value of session variable for the entire session (ie. not only for a particular request or a dashboard).
The syntax for this function is :
call NQSSetSessionValue('DataType VariableName=Value;')
We can call this function from from Issue SQL Directly section of Presentaion Services.
Example :
Assume that, a user logon to the system, he has the value 2 for the session variable LOGLEVEL. If the user decides to increase the value for LOGLEVEL for the entire session. Then he can use the ODBC function to change the value of LOGLEVEL.
HI, The direct request creating two session one for the logged in user and other for ODBC. The presentation services are refering to old vaule only. Any suggestions?
ReplyDeleteYour question is not clear. Could you please tell in detail... ?
ReplyDelete