| SE_connection_get_dbms_info | |
Retrieves information about database management system (DBMS) settings
LONG SE_connection_get_dbms_info (SE_CONNECTION connection, LONG *dbms_id LONG *dbms_properties);
| connection | The connection handle |
| dbms_id | A pointer to the DBMS ID |
| dbms_properties | A pointer to the DBMS properties |
SE_connection_get_dbms_info returns the DBMS ID and properties for the connection.
The DBMS ID values are:
SE_DBMS_IS_UNKNOWN -1
SE_DBMS_IS_OTHER 0
SE_DBMS_IS_ORACLE 1
SE_DBMS_IS_INFORMIX 2
SE_DBMS_IS_SYBASE 3
SE_DBMS_IS_DB2 4
SE_DBMS_IS_SQLSERVER 5
SE_DBMS_IS_ARCINFO 6
SE_DBMS_IS_IUS 7
SE_DBMS_IS_DB2_EXT 8
SE_DBMS_IS_ARCSERVER 9
SE_DBMS_IS_JET 10
SE_DBMS_IS_POSTGRE 11
SE_DBMS_IS_DB2ZOS 12
The DBMS properties are boolean values; either true or false. The following is a list of values and what it means if they are set to true:
| SE_DBMS_CAN_RENAME | The DBMS table can be renamed. |
| SE_DBMS_CAN_ADD_COL | The DBMS allows columns to be added to the table. (Supports ALTER TABLE with ADD COLUMN) |
| SE_DBMS_CAN_DROP_COL | The DBMS can drop columns from the table. (Supports ALTER TABLE with DROP COLUMN) |
| SE_DBMS_OWNER_PREFIXES_TABLE | The table can be qualified with the owner name. (Supports schemas in data manipulation, table definitions, and privilege definitions) |
| SE_DBMS_IS_CASE_SENSITIVE | The connected database is case sensitive. (Supports mixed-case identifiers) |
| SE_DBMS_SUPPORT_DELIMITED_IDENTIFIER | Delimited identifiers are supported. (Supports mixed-case, quoted identifiers) |
| SE_DBMS_IS_CASE_SENSITIVE_IN_COMPARISON | Value comparisons in the SQL WHERE clause are case sensitive. |
| SE_DBMS_IS_USER_CASE_SENSITIVE | User names are case sensitive. |
| SE_DBMS_IS_PASSWORD_CASE_SENSITIVE | DBMS passwords are case sensitive. |
SE_SUCCESS
SE_CONNECTION_IN_USE
SE_CONNECTION_LOCKED
SE_INVALID_CONNECTION
SE_INVALID_POINTER
SE_NET_FAILURE
SE_SDE_NOT_STARTED