Sybase Adaptive Server Anywhere - Page 1112

Database properties
1094
Property Description
LogWrite
The number of pages that have been written to the
transaction log.
Max_cursor_count
"MAX_CURSOR_COUNT option" on page 196
Max_statement_count
"MAX_STATEMENT_COUNT option" on
page 198
Min_password_length
"MIN_PASSWORD_LENGTH option" on
page 198
Name
The name of the current connection.
Nearest_century
"NEAREST_CENTURY option" on page 199
NodeAddress
The node for the client in a client/server
connection.
Non_keywords
"NON_KEYWORDS option" on page 199
Number
The ID number of the connection.
On_tsql_error
"ON_TSQL_ERROR option" on page 201
Optimization_goal
Reserved
Optimization_level
Reserved
Percent_as_comment
"PERCENT_AS_COMMENT option" on page 204
Port
An application-specific number for each client
machine, identifying the connection port.
Precision
"PRECISION option" on page 205
Prefetch
"PREFETCH option" on page 205
Prepares
Number of statement preparations carried out.
PrepStmt
The number of prepared statements currently being
maintained by the server.
Query_plan_on_open
"QUERY_PLAN_ON_OPEN option" on page 206
Quoted_identifier
"QUOTED_IDENTIFIER option" on page 207
Recovery_time
"RECOVERY_TIME option" on page 208
Replicate_all
"REPLICATE_ALL option" on page 208
ReqType
A string for the type of the last request.
RI_Trigger_time
"RI_TRIGGER_TIME option" on page 210
Rlbk
The number of Rollback requests that have been
handled.
RollbackLogPages
The number of pages in the rollback log
Row_counts
"ROW_COUNTS option" on page 208