Table 14-11: Global variables containing Adaptive
Server information
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. For more information, 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.
|
