Sybase Adaptive Server Anywhere - Page 274

Variables
256
Global variable Returns
@@ncharsize In Adaptive Server Enterprise, average length, in bytes, of a
national character. In Adaptive Server Anywhere, returns 1
@@nestlevel In Adaptive Server Enterprise, nesting level of current
execution (initially 0). Each time a stored procedure or
trigger calls another stored procedure or trigger, the nesting
level is incremented. In Adaptive Server Anywhere, returns
–1
@@pack_received In Adaptive Server Enterprise, number of input packets read
by Adaptive Server Enterprise since it was last started. In
Adaptive Server Anywhere, returns 0
@@pack_sent In Adaptive Server Enterprise, number of output packets
written by Adaptive Server Enterprise since it was last
started. In Adaptive Server Anywhere, returns 0
@@packet_errors In Adaptive Server Enterprise, number of errors that have
occurred while Adaptive Server Enterprise was sending and
receiving packets. In Adaptive Server Anywhere, returns 0
@@procid Stored procedure ID of the currently executing procedure
@@rowcount Number of rows affected by the last command.
@@rowcount is set to zero by any command which does not
return rows, such as an IF statement. With cursors,
@@rowcount represents the cumulative number of rows
returned from the cursor result set to the client, up to the last
fetch request
@@servername Name of the local Adaptive Server Enterprise or Adaptive
Server Anywhere server
@@spid In Adaptive Server Enterprise, server process ID number of
the current process. In Adaptive Server Anywhere, the
connection handle for the current connection. This is the
same value as that displayed by the sa_conn_info procedure
@@sqlstatus Contains status information resulting from the last fetch
statement. @@sqlstatus may contain the following values
0 The fetch statement completed successfully
1 The fetch statement resulted in an error
2 There is no more data in the result set
@@textsize Current value of the SET TEXTSIZE option, which specifies
the maximum length, in bytes, of text or image data to be
returned with a select statement. The default setting is
32765, which is the largest bytestring that can be returned
using READTEXT. The value can be set using the SET
statement
@@thresh_hysteresis In Adaptive Server Enterprise, change in free space required