Sybase - Instance Manager

Toolbar Operations - Depending on the Tab selected, there are different Toolbar Operations available.

Available Operations for Summary tab
Refresh : Refreshes all tabs in the instance manager from the database
Reconnect : Reconnects to the database server
Copy all w/Headers and Row counts: Copies all the tab results from the database to paste the information anywhere else
Find: Find tool to search the grid of the current tab
Find Next: Finds the next instance of the previous find

Available Operations for Parameters tab
Refresh : Refreshes all tabs in the instance manager from the database
Reconnect : Reconnects to the database server
Copy all w/Headers and Row counts: Copies all the tab results from the database to paste the information anywhere else
Find: Find tool to search the grid of the current tab
Find Next: Finds the next instance of the previous find
Edit Parameter: Edits the value of the currently selected parameter

General Tab - Provides a summary of the Sybase instance

Sybase Component: Shows the component name
Value: Shows the specification of the component

DBMS_NAME: Name of the DBMS
DBMS_VER: Version of the DBMS
DBE_NAME: Unused
OWNER_TERM: Adaptive Server’s term for a table owner (the second part of a three-part name)
TABLE_TERM: Adaptive Server’s term for a table (the third part of a three-part name)
MAX_OWNER_NAME_LENGTH: Maximum length of the name for a table owner (the second part of a three-part name)
IDENTIFIER_CASE: The case sensitivity of user-defined names (table names, column names, and stored procedure names) in the database
        (the case in which these objects are presented in the system catalogs)
COLUMN_LENGTH: The maximum number of characters for a column name
TABLE_LENGTH: The maximum number of characters for a table name
USERID_LENGTH: The maximum number of characters for a user name
TX_ISOLATION: The initial transaction isolation level the server assumes, corresponding to an isolation level defined in SQL92
COLLATION_SEQ: The assumed ordering of the character set for this server
MAX_QUAL_LENGTH: Maximum length of the name for a table qualifier (the first part of a three-part table name)
QUALIFIER_TERM: Adaptive Server’s term for a table qualifier (the first part of a three-part name)
SAVEPOINT_SUPPORT: Does the underlying DBMS support named savepoints?
MULTI_RESULT_SETS: Does the underlying DBMS or the gateway itself support multiple results sets (can multiple statements be sent through
        the gateway, with multiple results sets returned to the client)?
NAMED_TRANSACTIONS: Does the underlying DBMS support named transactions?
SPROC_AS_LANGUAGE: Can stored procedures be executed as language events?
REMOTE_SPROC: Can stored procedures be executed through the remote stored procedure APIs in DB-Library?
ACCESSIBLE_TABLES: In sp_tables, does the gateway return only tables, views, and so on, that are accessible by the current user
        (that is, the user who has at least select privileges for the table)?
ACCESSIBLE_SPROC: In sp_stored_procedures, does the gateway return only stored procedures that are executable by the current user?
MAX_INDEX_COLS: Maximum number of columns in an index for the DBMS
RENAME_TABLE: Can tables be renamed?
RENAME_COLUMN: Can columns be renamed?
DROP_COLUMN: Can columns be dropped?
INCREASE_COLUMN_LENGTH: Can column size be increased?
DDL_IN_TRANSACTION: Can DDL statements appear in transactions?
DESCENDING_INDEXES: Are descending indexes supported?
SP_RENAME: Can a stored procedure be renamed?
SYS_SPROC_VERSION: The version of the catalog stored procedures currently implemented