14.2.1 Instance Manager

DBMS_NAME: Name of the DBMS
DBMS_VER: Version of the DBMS
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)
TABLE_LENGTH: The maximum number of characters for a table name
MAX_QUAL_LENGTH: Maximum length of the name for a table qualifier (the first part of a three-part table name)
COLUMN_LENGTH: The maximum number of characters for a column 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)
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
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)?
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)?
USERID_LENGTH: The maximum number of characters for a user name
QUALIFIER_TERM: Adaptive Server’s term for a table qualifier (the first part of a three-part name)
NAMED_TRANSACTIONS: Does the underlying DBMS support named transactions?
SPROC_AS_LANGUAGE: Can stored procedures be executed as language events?
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?
REMOTE_SPROC: Can stored procedures be executed through the remote stored procedure APIs in DB-Library?
SYS_SPROC_VERSION: The version of the catalog stored procedures currently implemented