Global Variables

Adaptive Server 15.0.2 introduces the @@lastlogindate global variable.

New global variables
Global variable Description
@@lastlogindate

Global T-SQL variable @@lastlogindate is available to each user login session. A datetime datatype, its value is the lastlogindate column for the login account before the current session was established. This variable is specific to each login session and can be used by that session to determine the previous login to the account. If the account has not been used previously or “sp_passwordpolicy 'set', enable last login updates” is 0, then the value of @@lastlogindate is NULL.

Changed global variables
Global variable Description of change
@@opttimeoutlimit

Previous version of Adaptive Server user documenation listed @@opttimeout as a server global variable that displays the current optimization timeout limit for query optimization.

This is incorrect. The actual name of the global variable that displays the current optimization timeout limit for query optimization is @@opttimeoutlimit