Search code examples
sybasesap-ase

Sybase: how to show the values of the current session variables?


I can do for example:

> set chained on

But how can I see the current value of chained, or all current session variables?


Solution

  • Take a look at this list of ASE global variables.

    For the current chained status: select @@tranchained:

    • returns 0 if chained mode is disabled (set chained off)
    • returns 1 if chained mode is enabled (set chained on )