Thursday, June 7, 2012

NQSSetSessionValue - ODBC function

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.