Table 15-11 lists the global variables that contain miscellaneous information about Adaptive Server.
Global variable |
Description |
|---|---|
@@bulkarraysize |
Returns the number of rows to be buffered in local server memory before being transferred using the bulk copy interface Used only with Component Integration Services for transferring rows to a remote server using select into. See the Component Integration Services User’s Guide. |
@@bulkbatchsize |
Returns the number of rows transferred to a remote server via select into proxy_table using the bulk interface. Used only with Component Integration Services for transferring rows to a remote server using select into. For more information, see the Component Integration Services User’s Guide. |
@@boottime |
Displays the time at which the server is started. |
@@cis_version |
Contains the date and version of Component Integration Services, if it is installed. |
@@cmpstate |
Determines the current mode of the primary companion in a High Availability environment. For the values returned, see Table 4-1 in Using Sybase Failover in a High Availability System. |
@@guestuid |
The guest server user ID. The value is -1. |
@@guestuserid |
The guest user ID. The value is 2. |
@@invaliduserid |
The ID for an invalid user. The value is -1 |
@@invalidusid |
An invalid server user ID. The value is -2. |
@@max_connections |
Contains the maximum number of simultaneous connections that can be made with Adaptive Server in the current computer environment. You can configure Adaptive Server for any number of connections less than or equal to the value of @@max_connection, using number of user connections configuration parameter. |
@@maxpagesize |
Displays the server page size. The values are 2048, 4096, 8128, or 16384. |
@@maxuserid |
The highest user ID. The value is 2147483647. |
@@max_precision |
Returns the precision level used by decimal and numeric datatypes set by the server. This value is a fixed constant of 38. |
@@maxuid |
The highest server user ID. The value is 2147483647. |
@@mingroupid |
Lowest group user ID. The lowest value is 16384. |
@@minsuid |
Minimum server user ID. The lowest value is -32768. |
@@minuserid |
Lowest user ID. The lowest value is -32768. |
@@maxgroupid |
Highest group user ID. The highest value is 1048576 |
@@maxuserid |
The highest user ID. The highest value is 2147483647 |
@@procid |
Contains the stored procedure ID of the currently executing procedure. |
@@probesuid |
The probe user ID. The value is 2. |
@@remotestate |
Returns the current mode of the primary companion in a high availability environment. For values returned, see Table 4-1 in Using Sybase Failover in a High Availability Environment. |
@@servername |
Contains the name of this Adaptive Server. Define a server name with sp_addserver, and then restart Adaptive Server. |
@@spid |
Contains the server process ID number of the current process. |
@@ssl_ciphersuite |
Returns NULL if SSL protocol is not used on the current connection; otherwise, it returns the name of the cipher suite chosen by the SSL handshake on the current connection. |
@@tempdbid |
Returns a valid temporary database ID (dbid) of the session’s assigned temporary database. |
@@thresh_hysteresis |
Contains the decrease in free space required to activate a threshold. This amount, also known as the hysteresis value, is measured in 2K database pages. It determines how closely thresholds can be placed on a database segment. |
@@timeticks |
Contains the number of microseconds per tick. The amount of time per tick is machine-dependent. |
@@version |
Contains the date of the current release of Adaptive Server. |
@@version_number |
Returns the whole version of the current release of Adaptive Server as an integer (for example, 12503) |
@@boottime |
Displays the time at which Adaptive Server was started. |
