These are the global variables and their brief descriptions for Adaptive Server. See Reference Manual: Building Blocks for complete information.
Returns the number of active instances in the cluster.
Indicates the mechanism used to authenticate the user.
Returns the number of times an installation has been booted.
Returns the date and time Adaptive Server was last booted.
Returns the number of rows to be buffered in local server memory before being transferred using the bulk copy interface.
Returns the number of rows transferred to a remote server via select into proxy_table using the bulk interface.
Returns 0 if character set conversion is not in effect, 1 if character set conversion is in effect.
Returns 0 if cis rpc handling is off. Returns 1 if cis rpc handling is on.
Returns the date and version of Component Integration Services.
Returns the expansion factor used when converting from the server character set to the client character set.
Returns -1 if the client character set has never been initialized; returns the client character set ID from syscharsets for the connection if the client character set has been initialized.
Returns NULL if client character set has never been initialized; returns the name of the character set for the connection if the client character set has been initialized.
Returns the date and time the cluster was first started, even if the instance that originally started the cluster start has shut down
Returns the instance id of the current cluster coordinator.
Returns the string: “shared-disk cluster.”
Returns the name of the cluster.
Returns the current mode of Adaptive Server in a high availability environment.
Returns the number of user logins attempted.
Returns the amount of time, in ticks, that the CPU has spent doing Adaptive Server work since the last time Adaptive Server was started.
Displays the total number of rows in the cursor result set.
Either no cursors are open, no rows qualify for the last opened cursor, or the last open cursor is closed or deallocated.
Returns the current value of @@datefirst, indicating the specified first day of each week, expressed as tinyint.
Returns the timestamp of the current database.
Returns the error number most recently generated by the system.
Returns the full path to the directory in which the Adaptive Server error log is kept, relative to $SYBASE directory.
Returns a value greater than 0 if the connection to the primary companion has failed over and is executing on the secondary companion server.
Returns 0 if fetch operation is successful or -1 if fetch operation is unsuccessful. -2 is reserved for future use.
Returns the ID of the guest user.
Returns the name of the companion server in a high availability setup.
Returns a value greater than 0 if the connection has the failover property enabled.
Returns the size of the heap memory pool, in bytes.
Returns the most recently generated IDENTITY column value.
Returns the amount of time, in ticks, that Adaptive Server has been idle since it was last started.
Returns a value of -1 for an invalid user ID.
Returns the id of the instance from which it was executed
Returns the name of the instance from which it was executed
Returns a value of -1 for an invalid user ID.
Returns the amount of time, in ticks, that Adaptive Server has spent doing input and output operations.
Returns the value of the session-specific isolation level (0, 1, or 3) of the current Transact-SQL program.
ID of the instance on which the Job Scheduler is running, or will run once enabled
Returns the starting address of the first shared memory region that contains the kernel region.
Returns the size of the kernel region that is part of the first shared memory region.
Returns the mode (threaded or process) for which Adaptive Server is configured.
Returns the server-wide language ID of the language in use, as specified in syslanguages.langid.
Returns the name of the language in use, as specified in syslanguages.name.
Returns the date and time of when the last key pair was generated as set by the sp_passwordpolicy “keypair regeneration period” policy option.
Includes a datetime datatype, its value is the lastlogindate column for the login account before the current session was established.
Returns the current lock_timeout setting, in milliseconds.
Returns the object ID of the next most recently run lightweight procedure.
Returns the maximum number of simultaneous connections that can be made with Adaptive Server in the current computer environment.
Returns the precision level used by decimal and numeric datatypes set by the server. This value is a fixed constant of 38.
Returns the maximum length, in bytes, of a character in Adaptive Server's default character set.
Returns the highest group user ID. The highest value is 1048576.
Returns the server’s logical page size.
Returns maximum valid value for the spid.
Returns the highest server user ID. The default value is 2147483647.
Returns the highest user ID. The highest value is 2147483647.
Returns the global memory pool table address.
Returns the minimum size of a named cache pool, in kilobytes.
Returns the lowest group user ID. The lowest value is 16384.
Returns 1, which is the lowest value for spid.
Returns the minimum server user ID. The lowest value is -32768.
Returns the lowest user ID. The lowest value is -32768.
Reduces the number of messages displayed by sp_sysmon.
Returns the maximum length, in bytes, of a character set in the current server default character set.
Returns the current nesting level.
Returns the date and time of when the next key pair scheduled to be generated, as set by sp_passwordpolicy “keypair regeneration period” policy option.
Returns the current installation's 48-bit node identifier.
Returns the current optimization goal setting for query optimization
Returns a hexadecimal representation of the session’s set options.
Returns the currently optimization level setting.
Returns the current optimization timeout limit setting for query optimization
(Threaded mode only) Returns the operating system ID for the server.
Retruns the number of input packets read by Adaptive Server.
Returns the nmber of output packets written by Adaptive Server.
Returns the number of errors detected by Adaptive Server while reading and writing packets.
Returns the server’s virtual page size.
Returns the current maximum parallel degree setting.
Returns the object ID of the most recently prepared lightweight procedure.
Returns a value of 2 for the probe user ID.
Returns the stored procedure ID of the currently executing procedure.
Returns the physical path for the quorum device
Indicates whether Adaptive Server is in recovery based on these returns
(High-availability only) Returns the current mode of the primary companion in a high availability environment.
Returns the current dynamic repartitioning degree setting
Returns the maximum resource usage hint setting for query optimization
Returns the number of rows affected by the last query.
Returns the current maximum parallel degree setting for nonclustered index scans.
Returns the name of Adaptive Server.
Returns the current value for set rowcount
Returns the shared memory region properties.
Returns the server process ID of the current process.
Returns status information (warning exceptions) resulting from the execution of a fetch statement.
Returns NULL if SSL is not used on the current connection; otherwise, it returns the name of the cipher suite you chose during the SSL handshake on the current connection.
Returns the amount of character data returned from a toString() method.
Returns the database id of the executing instance’s effective local system temporary database
Number of ticks during which Adaptive Server was running a system task.
Returns the session-specific system view setting, either “instance” or “cluster.”
Returns a valid temporary database ID (dbid) of the session’s assigned temporary database.
Returns the column ID of the column referenced by @@textptr.
Returns the partition ID of a text partition containing the column referenced by @@textptr.
Returns the database ID of a database containing an object with the column referenced by@@textptr.
Returns the object ID of an object containing the column referenced by @@textptr.
Returns the partition ID of a data partition containing the column referenced by @@textptr.
Returns the text pointer of the last text, unitext, or image inserted or updated by a process (Not the same as the textptr function).
Returns 0 if the current status of the textptr_parameters is off, and 1 if the current status of the textptr_parameters if on.
Returns the limit on the number of bytes of text, unitext, or image data a select returns.
Returns the text timestamp of the column referenced by @@textptr.
Returns the decrease in free space required to activate a threshold.
Returns the number of microseconds per tick.
Returns the number of errors detected by Adaptive Server while reading and writing.
Returns the number of disk reads by Adaptive Server.
Returns the number of disk writes by Adaptive Server.
Returns 0 if the current transaction mode of the Transact-SQL program is unchained, and 1 if chained.
Returns the nesting level of transactions in the current user session.
Returns 0 if RPCs to remote servers are transactional, and 1 if not transactional.
Returns the current state of a transaction after a statement executes in the current user session.
Returns 2, the size of a character in unichar.
Number of ticks during which Adaptive Server was running a user task.
Returns the date, version string, and so on of the current release of Adaptive Server.
Returns the number of the last upgrade version of the current release of Adaptive Server as an integer.
Returns the whole version of the current release of Adaptive Server as an integer
