4D v13
Appendix B, 4D ODBC PRO Constants
- 4D ODBC Pro
-
- Appendixes
-
- Appendix A, 4D ODBC PRO Error Codes
- Appendix B, 4D ODBC PRO Constants
4D v13
Appendix B, 4D ODBC PRO Constants
Appendix B, 4D ODBC PRO Constants
This section details all of the SQL constants that can be used in 4D ODBC PRO.
Important Note: In the current release of the 4D ODBC PRO plug-in, not all of the following SQL constants are available as such, but you can still use the associated value. In the list below, the constants that have not been created are followed by a * sign.
| Constant | Value |
| SQL_ACCESS_MODE | 101 |
| SQL_ACCESSIBLE_PROCEDURES | 20 |
| SQL_ACCESSIBLE_TABLES | 19 |
| SQL_ACTIVE_CONNECTIONS* | 0 |
| SQL_ACTIVE_ENVIRONMENTS | 116 |
| SQL_ACTIVE_STATEMENTS* | 1 |
| SQL_AGGREGATE_FUNCTIONS | 169 |
| SQL_ALL_TYPES | 0 |
| SQL_ALTER_DOMAIN | 117 |
| SQL_ALTER_TABLE | 86 |
| SQL_AM_CONNECTION | 1 |
| SQL_AM_NONE | 0 |
| SQL_AM_STATEMENT | 2 |
| SQL_API_SQLALLOCCONNECT | 1 |
| SQL_API_SQLALLOCENV | 2 |
| SQL_API_SQLALLOCHANDLE | 1001 |
| SQL_API_SQLALLOCSTMT | 3 |
| SQL_API_SQLBINDCOL | 4 |
| SQL_API_SQLBINDPARAM | 1002 |
| SQL_API_SQLBINDPARAMETER | 72 |
| SQL_API_SQLBROWSECONNECT | 55 |
| SQL_API_SQLCANCEL | 5 |
| SQL_API_SQLCLOSECURSOR | 1003 |
| SQL_API_SQLCOLATTRIBUTES | 6 |
| SQL_API_SQLCOLUMNPRIVILEGES | 56 |
| SQL_API_SQLCOLUMNS | 40 |
| SQL_API_SQLCONNECT | 7 |
| SQL_API_SQLCOPYDESC | 1004 |
| SQL_API_SQLDATASOURCES | 57 |
| SQL_API_SQLDESCRIBECOL | 8 |
| SQL_API_SQLDESCRIBEPARAM | 58 |
| SQL_API_SQLDISCONNECT | 9 |
| SQL_API_SQLDRIVERCONNECT | 41 |
| SQL_API_SQLDRIVERS | 71 |
| SQL_API_SQLENDTRAN | 1005 |
| SQL_API_SQLERROR | 10 |
| SQL_API_SQLEXECDIRECT | 11 |
| SQL_API_SQLEXECUTE | 12 |
| SQL_API_SQLEXTENDEDFETCH | 59 |
| SQL_API_SQLFETCH | 13 |
| SQL_API_SQLFETCHSCROLL | 1021 |
| SQL_API_SQLFOREIGNKEYS | 60 |
| SQL_API_SQLFREECONNECT | 14 |
| SQL_API_SQLFREEENV | 15 |
| SQL_API_SQLFREEHANDLE | 1006 |
| SQL_API_SQLFREESTMT | 16 |
| SQL_API_SQLGETCONNECTATTR | 1007 |
| SQL_API_SQLGETCONNECTOPTION | 42 |
| SQL_API_SQLGETCURSORNAME | 17 |
| SQL_API_SQLGETDATA | 43 |
| SQL_API_SQLGETDESCFIELD | 1008 |
| SQL_API_SQLGETDESCREC | 1009 |
| SQL_API_SQLGETDIAGFIELD | 1010 |
| SQL_API_SQLGETDIAGREC | 1011 |
| SQL_API_SQLGETENVATTR | 1012 |
| SQL_API_SQLGETFUNCTIONS | 44 |
| SQL_API_SQLGETINFO | 45 |
| SQL_API_SQLGETSTMTATTR | 1014 |
| SQL_API_SQLGETSTMTOPTION | 46 |
| SQL_API_SQLGETTYPEINFO | 47 |
| SQL_API_SQLMORERESULTS | 61 |
| SQL_API_SQLNATIVESQL | 62 |
| SQL_API_SQLNUMPARAMS | 63 |
| SQL_API_SQLNUMRESULTCOLS | 18 |
| SQL_API_SQLPARAMDATA | 48 |
| SQL_API_SQLPARAMOPTIONS | 64 |
| SQL_API_SQLPREPARE | 19 |
| SQL_API_SQLPRIMARYKEYS | 65 |
| SQL_API_SQLPROCEDURECOLUMNS | 66 |
| SQL_API_SQLPROCEDURES | 67 |
| SQL_API_SQLPUTDATA | 49 |
| SQL_API_SQLROWCOUNT | 20 |
| SQL_API_SQLSETCONNECTATTR | 1016 |
| SQL_API_SQLSETCONNECTOPTION | 50 |
| SQL_API_SQLSETCURSORNAME | 21 |
| SQL_API_SQLSETDESCFIELD | 1017 |
| SQL_API_SQLSETDESCREC | 1018 |
| SQL_API_SQLSETENVATTR | 1019 |
| SQL_API_SQLSETPARAM | 22 |
| SQL_API_SQLSETPOS | 68 |
| SQL_API_SQLSETSCROLLOPTIONS | 69 |
| SQL_API_SQLSETSTMTATTR | 1020 |
| SQL_API_SQLSETSTMTOPTION | 51 |
| SQL_API_SQLSPECIALCOLUMNS | 52 |
| SQL_API_SQLSTATISTICS | 53 |
| SQL_API_SQLTABLEPRIVILEGES | 70 |
| SQL_API_SQLTABLES | 54 |
| SQL_API_SQLTRANSACT | 23 |
| SQL_ARD_TYPE | -99 |
| SQL_ASYNC_ENABLE | 4 |
| SQL_ASYNC_ENABLE_DEFAULT | 0 |
| SQL_ASYNC_ENABLE_OFF | 0 |
| SQL_ASYNC_ENABLE_ON | 1 |
| SQL_ASYNC_MODE | 10021 |
| SQL_AT_ADD_COLUMN | 1 |
| SQL_AT_ADD_CONSTRAINT | 8 |
| SQL_AT_DROP_COLUMN | 2 |
| SQL_ATTR_ACCESS_MODE | 101 |
| SQL_ATTR_APP_PARAM_DESC | 10011 |
| SQL_ATTR_APP_ROW_DESC | 10010 |
| SQL_ATTR_ASYNC_ENABLE | 4 |
| SQL_ATTR_AUTO_IPD | 10001 |
| SQL_ATTR_AUTOCOMMIT | 102 |
| SQL_ATTR_CONCURRENCY | 7 |
| SQL_ATTR_CONNECTION_DEAD | 1209 |
| SQL_ATTR_CONNECTION_POOLING | 201 |
| SQL_ATTR_CONNECTION_TIMEOUT | 113 |
| SQL_ATTR_CP_MATCH | 202 |
| SQL_ATTR_CURRENT_CATALOG | 109 |
| SQL_ATTR_CURSOR_SCROLLABLE | -1 |
| SQL_ATTR_CURSOR_SENSITIVITY | -2 |
| SQL_ATTR_CURSOR_TYPE | 6 |
| SQL_ATTR_DISCONNECT_BEHAVIOR | 114 |
| SQL_ATTR_ENABLE_AUTO_IPD | 15 |
| SQL_ATTR_ENLIST_IN_DTC | 1207 |
| SQL_ATTR_ENLIST_IN_XA | 1208 |
| SQL_ATTR_FETCH_BOOKMARK_PTR | 16 |
| SQL_ATTR_IMP_PARAM_DESC | 10013 |
| SQL_ATTR_IMP_ROW_DESC | 10012 |
| SQL_ATTR_KEYSET_SIZE | 8 |
| SQL_ATTR_LOGIN_TIMEOUT | 103 |
| SQL_ATTR_MAX_LENGTH | 3 |
| SQL_ATTR_MAX_ROWS | 1 |
| SQL_ATTR_METADATA_ID | 10014 |
| SQL_ATTR_NOSCAN | 2 |
| SQL_ATTR_ODBC_CURSORS | 110 |
| SQL_ATTR_ODBC_VERSION | 200 |
| SQL_ATTR_OUTPUT_NTS | 10001 |
| SQL_ATTR_PACKET_SIZE | 112 |
| SQL_ATTR_PARAM_BIND_OFFSET_PTR | 17 |
| SQL_ATTR_PARAM_BIND_TYPE | 18 |
| SQL_ATTR_PARAM_OPERATION_PTR | 19 |
| SQL_ATTR_PARAM_STATUS_PTR | 20 |
| SQL_ATTR_PARAMS_PROCESSED_PTR | 21 |
| SQL_ATTR_PARAMSET_SIZE | 22 |
| SQL_ATTR_QUERY_TIMEOUT | 0 |
| SQL_ATTR_QUIET_MODE | 111 |
| SQL_ATTR_RETRIEVE_DATA | 11 |
| SQL_ATTR_ROW_ARRAY_SIZE | 27 |
| SQL_ATTR_ROW_BIND_OFFSET_PTR | 23 |
| SQL_ATTR_ROW_BIND_TYPE | 5 |
| SQL_ATTR_ROW_NUMBER | 14 |
| SQL_ATTR_ROW_OPERATION_PTR | 24 |
| SQL_ATTR_ROW_STATUS_PTR | 25 |
| SQL_ATTR_ROWS_FETCHED_PTR | 26 |
| SQL_ATTR_SIMULATE_CURSOR | 10 |
| SQL_ATTR_TRACE | 104 |
| SQL_ATTR_TRACEFILE | 105 |
| SQL_ATTR_TRANSLATE_LIB | 106 |
| SQL_ATTR_TRANSLATE_OPTION | 107 |
| SQL_ATTR_TXN_ISOLATION | 108 |
| SQL_ATTR_USE_BOOKMARKS | 12 |
| SQL_AUTOCOMMIT | 102 |
| SQL_AUTOCOMMIT_DEFAULT | 1 |
| SQL_AUTOCOMMIT_OFF | 0 |
| SQL_AUTOCOMMIT_ON | 1 |
| SQL_BATCH_ROW_COUNT | 120 |
| SQL_BATCH_SUPPORT | 121 |
| SQL_BEST_ROWID | 1 |
| SQL_BIGINT | -5 |
| SQL_BINARY | -2 |
| SQL_BIND_BY_COLUMN | 0 |
| SQL_BIND_TYPE | 5 |
| SQL_BIND_TYPE_DEFAULT | 0 |
| SQL_BIT | -7 |
| SQL_BOOKMARK_PERSISTENCE | 82 |
| SQL_C_CHAR | 1 |
| SQL_C_DEFAULT | 99 |
| SQL_C_DOUBLE | 8 |
| SQL_C_FLOAT | 7 |
| SQL_C_LONG | 4 |
| SQL_C_NUMERIC | 2 |
| SQL_C_SHORT | 5 |
| SQL_CATALOG_LOCATION | 114 |
| SQL_CATALOG_NAME | 10003 |
| SQL_CATALOG_NAME_SEPARATOR | 41 |
| SQL_CATALOG_TERM | 42 |
| SQL_CATALOG_USAGE | 92 |
| SQL_CB_CLOSE | 1 |
| SQL_CB_DELETE | 0 |
| SQL_CB_PRESERVE | 2 |
| SQL_CD_FALSE | 0 |
| SQL_CD_TRUE | 1 |
| SQL_CHAR | 1 |
| SQL_CLOSE | 0 |
| SQL_CODE_DATE | 1 |
| SQL_CODE_DAY | 3 |
| SQL_CODE_DAY_TO_HOUR | 8 |
| SQL_CODE_DAY_TO_MINUTE | 9 |
| SQL_CODE_DAY_TO_SECOND | 10 |
| SQL_CODE_HOUR | 4 |
| SQL_CODE_HOUR_TO_MINUTE | 11 |
| SQL_CODE_HOUR_TO_SECOND | 12 |
| SQL_CODE_MINUTE | 5 |
| SQL_CODE_MINUTE_TO_SECOND | 13 |
| SQL_CODE_MONTH | 2 |
| SQL_CODE_SECOND | 6 |
| SQL_CODE_TIME | 2 |
| SQL_CODE_TIMESTAMP | 3 |
| SQL_CODE_YEAR | 1 |
| SQL_CODE_YEAR_TO_MONTH | 7 |
| SQL_COL_PRED_BASIC | 2 |
| SQL_COL_PRED_CHAR | 1 |
| SQL_COLLATION_SEQ | 10004 |
| SQL_COLUMN_ALIAS* | 87 |
| SQL_COMMIT | 0 |
| SQL_CONCAT_NULL_BEHAVIOR | 22 |
| SQL_CONCUR_DEFAULT | 1 |
| SQL_CONCUR_LOCK | 2 |
| SQL_CONCUR_READ_ONLY | 1 |
| SQL_CONCUR_ROWVER | 3 |
| SQL_CONCUR_VALUES | 4 |
| SQL_CONCURRENCY | 7 |
| SQL_CONVERT_BIGINT | 53 |
| SQL_CONVERT_BINARY | 54 |
| SQL_CONVERT_BIT | 55 |
| SQL_CONVERT_CHAR | 56 |
| SQL_CONVERT_DATE | 57 |
| SQL_CONVERT_DECIMAL | 58 |
| SQL_CONVERT_DOUBLE | 59 |
| SQL_CONVERT_FLOAT | 60 |
| SQL_CONVERT_FUNCTIONS | 48 |
| SQL_CONVERT_GUID* | 173 |
| SQL_CONVERT_INTEGER | 61 |
| SQL_CONVERT_INTERVAL_DAY_TIME | 123 |
| SQL_CONVERT_INTERVAL_YEAR_MONTH | 124 |
| SQL_CONVERT_LONGVARBINARY | 71 |
| SQL_CONVERT_LONGVARCHAR | 62 |
| SQL_CONVERT_NUMERIC | 63 |
| SQL_CONVERT_REAL | 64 |
| SQL_CONVERT_SMALLINT | 65 |
| SQL_CONVERT_TIME | 66 |
| SQL_CONVERT_TIMESTAMP | 67 |
| SQL_CONVERT_TINYINT | 68 |
| SQL_CONVERT_VARBINARY | 69 |
| SQL_CONVERT_VARCHAR | 70 |
| SQL_CONVERT_WCHAR* | 122 |
| SQL_CONVERT_WLONGVARCHAR* | 125 |
| SQL_CONVERT_WVARCHAR* | 126 |
| SQL_CORRELATION_NAME | 74 |
| SQL_CP_DEFAULT | 0 |
| SQL_CP_MATCH_DEFAULT | 0 |
| SQL_CP_OFF | 0 |
| SQL_CP_ONE_PER_DRIVER | 1 |
| SQL_CP_ONE_PER_HENV | 2 |
| SQL_CP_RELAXED_MATCH | 1 |
| SQL_CP_STRICT_MATCH | 0 |
| SQL_CREATE_ASSERTION | 127 |
| SQL_CREATE_CHARACTER_SET | 128 |
| SQL_CREATE_COLLATION | 129 |
| SQL_CREATE_DOMAIN | 130 |
| SQL_CREATE_SCHEMA | 131 |
| SQL_CREATE_TABLE | 132 |
| SQL_CREATE_TRANSLATION | 133 |
| SQL_CREATE_VIEW* | 134 |
| SQL_CUR_DEFAULT | 2 |
| SQL_CUR_USE_DRIVER | 2 |
| SQL_CUR_USE_IF_NEEDED | 0 |
| SQL_CUR_USE_ODBC | 1 |
| SQL_CURRENT_QUALIFIER | 109 |
| SQL_CURSOR_COMMIT_BEHAVIOR | 23 |
| SQL_CURSOR_DYNAMIC | 2 |
| SQL_CURSOR_FORWARD_ONLY | 0 |
| SQL_CURSOR_KEYSET_DRIVEN | 1 |
| SQL_CURSOR_ROLLBACK_BEHAVIOR | 24 |
| SQL_CURSOR_SENSITIVITY | 10001 |
| SQL_CURSOR_STATIC | 3 |
| SQL_CURSOR_TYPE | 6 |
| SQL_CURSOR_TYPE_DEFAULT | 0 |
| SQL_DATA_AT_EXEC | -2 |
| SQL_DATA_SOURCE_NAME | 2 |
| SQL_DATA_SOURCE_READ_ONLY | 25 |
| SQL_DATE | 9 |
| SQL_DATE_LEN | 10 |
| SQL_DATETIME | 9 |
| SQL_DATETIME_LITERALS* | 119 |
| SQL_DB_DEFAULT | 0 |
| SQL_DB_DISCONNECT | 1 |
| SQL_DB_RETURN_TO_POOL | 0 |
| SQL_DBMS_NAME | 17 |
| SQL_DBMS_VER | 18 |
| SQL_DDL_INDEX | 170 |
| SQL_DECIMAL | 3 |
| SQL_DEFAULT | 99 |
| SQL_DEFAULT_TXN_ISOLATION | 26 |
| SQL_DESC_ALLOC_AUTO | 1 |
| SQL_DESC_ALLOC_TYPE | 1099 |
| SQL_DESC_ALLOC_USER | 2 |
| SQL_DESC_ARRAY_SIZE | 20 |
| SQL_DESC_ARRAY_STATUS_PTR | 21 |
| SQL_DESC_AUTO_UNIQUE_VALUE | 11 |
| SQL_DESC_BASE_COLUMN_NAME | 22 |
| SQL_DESC_BASE_TABLE_NAME | 23 |
| SQL_DESC_BIND_OFFSET_PTR | 24 |
| SQL_DESC_BIND_TYPE | 25 |
| SQL_DESC_CASE_SENSITIVE | 12 |
| SQL_DESC_CATALOG_NAME | 17 |
| SQL_DESC_CONCISE_TYPE | 2 |
| SQL_DESC_COUNT | 1001 |
| SQL_DESC_DATA_PTR | 1010 |
| SQL_DESC_DATETIME_INTERVAL_COD | 1007 |
| SQL_DESC_DATETIME_INTERVAL_PRE | 26 |
| SQL_DESC_DISPLAY_SIZE | 6 |
| SQL_DESC_FIXED_PREC_SCALE | 9 |
| SQL_DESC_INDICATOR_PTR | 1009 |
| SQL_DESC_LABEL | 18 |
| SQL_DESC_LENGTH | 1003 |
| SQL_DESC_LITERAL_PREFIX | 27 |
| SQL_DESC_LITERAL_SUFFIX | 28 |
| SQL_DESC_LOCAL_TYPE_NAME | 29 |
| SQL_DESC_MAXIMUM_SCALE | 30 |
| SQL_DESC_MINIMUM_SCALE | 31 |
| SQL_DESC_NAME | 1011 |
| SQL_DESC_NULLABLE | 1008 |
| SQL_DESC_NUM_PREC_RADIX | 32 |
| SQL_DESC_OCTET_LENGTH | 1013 |
| SQL_DESC_OCTET_LENGTH_PTR | 1004 |
| SQL_DESC_PARAMETER_TYPE | 33 |
| SQL_DESC_PRECISION | 1005 |
| SQL_DESC_ROWS_PROCESSED_PTR | 34 |
| SQL_DESC_SCALE | 1006 |
| SQL_DESC_SCHEMA_NAME | 16 |
| SQL_DESC_SEARCHABLE | 13 |
| SQL_DESC_TABLE_NAME | 15 |
| SQL_DESC_TYPE | 1002 |
| SQL_DESC_TYPE_NAME | 14 |
| SQL_DESC_UNNAMED | 1012 |
| SQL_DESC_UNSIGNED | 8 |
| SQL_DESC_UPDATABLE | 10 |
| SQL_DESCRIBE_PARAMETER | 10002 |
| SQL_DIAG_ALTER_DOMAIN | 3 |
| SQL_DIAG_ALTER_TABLE | 4 |
| SQL_DIAG_CALL | 7 |
| SQL_DIAG_CLASS_ORIGIN | 8 |
| SQL_DIAG_COLUMN_NUMBER | -1247 |
| SQL_DIAG_CONNECTION_NAME | 10 |
| SQL_DIAG_CREATE_ASSERTION | 6 |
| SQL_DIAG_CREATE_CHARACTER_SET | 8 |
| SQL_DIAG_CREATE_COLLATION | 10 |
| SQL_DIAG_CREATE_DOMAIN | 23 |
| SQL_DIAG_CREATE_INDEX | -1 |
| SQL_DIAG_CREATE_SCHEMA | 64 |
| SQL_DIAG_CREATE_TABLE | 77 |
| SQL_DIAG_CREATE_TRANSLATION | 79 |
| SQL_DIAG_CREATE_VIEW | 84 |
| SQL_DIAG_CURSOR_ROW_COUNT | -1249 |
| SQL_DIAG_DELETE_WHERE | 19 |
| SQL_DIAG_DROP_ASSERTION 2 | 24 |
| SQL_DIAG_DROP_CHARACTER_SET 2 | 25 |
| SQL_DIAG_DROP_COLLATION 2 | 26 |
| SQL_DIAG_DROP_DOMAIN 2 | 27 |
| SQL_DIAG_DROP_INDEX | -2 |
| SQL_DIAG_DROP_SCHEMA | 31 |
| SQL_DIAG_DROP_TABLE | 32 |
| SQL_DIAG_DROP_TRANSLATION | 33 |
| SQL_DIAG_DROP_VIEW | 36 |
| SQL_DIAG_DYNAMIC_DELETE_CURSOR | 38 |
| SQL_DIAG_DYNAMIC_FUNCTION | 7 |
| SQL_DIAG_DYNAMIC_FUNCTION_CODE | 12 |
| SQL_DIAG_DYNAMIC_UPDATE_CURSOR | 81 |
| SQL_DIAG_GRANT | 48 |
| SQL_DIAG_INSERT | 50 |
| SQL_DIAG_MESSAGE_TEXT | 6 |
| SQL_DIAG_NATIVE | 5 |
| SQL_DIAG_NUMBER | 2 |
| SQL_DIAG_RETURNCODE | 1 |
| SQL_DIAG_REVOKE | 59 |
| SQL_DIAG_ROW_COUNT | 3 |
| SQL_DIAG_ROW_NUMBER | -1248 |
| SQL_DIAG_SELECT_CURSOR | 85 |
| SQL_DIAG_SERVER_NAME | 11 |
| SQL_DIAG_SQLSTATE | 4 |
| SQL_DIAG_SUBCLASS_ORIGIN | 9 |
| SQL_DIAG_UNKNOWN_STATEMENT | 0 |
| SQL_DIAG_UPDATE_WHERE | 82 |
| SQL_DM_VER* | 171 |
| SQL_DOUBLE | 8 |
| SQL_DRIVER_HDBC | 3 |
| SQL_DRIVER_HDESC | 135 |
| SQL_DRIVER_HENV | 4 |
| SQL_DRIVER_HLIB | 76 |
| SQL_DRIVER_HSTMT | 5 |
| SQL_DRIVER_NAME | 6 |
| SQL_DRIVER_ODBC_VER | 77 |
| SQL_DRIVER_VER | 7 |
| SQL_DROP | 1 |
| SQL_DROP_ASSERTION | 136 |
| SQL_DROP_CHARACTER_SET | 137 |
| SQL_DROP_COLLATION | 138 |
| SQL_DROP_DOMAIN | 139 |
| SQL_DROP_SCHEMA | 140 |
| SQL_DROP_TABLE | 141 |
| SQL_DROP_TRANSLATION | 142 |
| SQL_DROP_VIEW | 143 |
| SQL_DTC_DONE | 0 |
| SQL_DYNAMIC_CURSOR_ATTRIBUTES1 | 144 |
| SQL_DYNAMIC_CURSOR_ATTRIBUTES2 | 145 |
| SQL_ERROR | -1 |
| SQL_EXPRESSIONS_IN_ORDERBY | 27 |
| SQL_FALSE | 0 |
| SQL_FD_FETCH_ABSOLUTE | 16 |
| SQL_FD_FETCH_FIRST | 2 |
| SQL_FD_FETCH_LAST | 4 |
| SQL_FD_FETCH_NEXT | 1 |
| SQL_FD_FETCH_PRIOR | 8 |
| SQL_FD_FETCH_RELATIVE | 32 |
| SQL_FETCH_ABSOLUTE | 5 |
| SQL_FETCH_DIRECTION | 8 |
| SQL_FETCH_FIRST | 2 |
| SQL_FETCH_LAST | 3 |
| SQL_FETCH_NEXT | 1 |
| SQL_FETCH_PRIOR | 4 |
| SQL_FETCH_RELATIVE | 6 |
| SQL_FILE_USAGE | 84 |
| SQL_FLOAT | 6 |
| SQL_FORWARD_ONLY_CURSOR_ATTRS1 | 146 |
| SQL_FORWARD_ONLY_CURSOR_ATTRS2 | 147 |
| SQL_GD_ANY_COLUMN | 1 |
| SQL_GD_ANY_ORDER | 2 |
| SQL_GET_BOOKMARK | 13 |
| SQL_GETDATA_EXTENSIONS | 81 |
| SQL_GUID | -11 |
| SQL_GROUP_BY | 88 |
| SQL_HANDLE_DBC | 2 |
| SQL_HANDLE_DESC | 4 |
| SQL_HANDLE_ENV | 1 |
| SQL_HANDLE_SENV | 5 |
| SQL_HANDLE_STMT | 3 |
| SQL_IC_LOWER | 2 |
| SQL_IC_MIXED | 4 |
| SQL_IC_SENSITIVE | 3 |
| SQL_IC_UPPER | 1 |
| SQL_IDENTIFIER_CASE | 28 |
| SQL_IDENTIFIER_QUOTE_CHAR | 29 |
| SQL_INDEX_ALL | 1 |
| SQL_INDEX_CLUSTERED | 1 |
| SQL_INDEX_HASHED | 2 |
| SQL_INDEX_KEYWORDS | 148 |
| SQL_INDEX_OTHER | 3 |
| SQL_INDEX_UNIQUE | 0 |
| SQL_INFO_SCHEMA_VIEWS | 149 |
| SQL_INSENSITIVE | 1 |
| SQL_INSERT_STATEMENT | 172 |
| SQL_INTEGER | 4 |
| SQL_INTEGRITY | 73 |
| SQL_INTERVAL | 10 |
| SQL_INTERVAL_DAY | 103 |
| SQL_INTERVAL_DAY_TO_HOUR | 108 |
| SQL_INTERVAL_DAY_TO_MINUTE | 109 |
| SQL_INTERVAL_DAY_TO_SECOND | 110 |
| SQL_INTERVAL_HOUR | 104 |
| SQL_INTERVAL_HOUR_TO_MINUTE | 111 |
| SQL_INTERVAL_HOUR_TO_SECOND | 112 |
| SQL_INTERVAL_MINUTE | 105 |
| SQL_INTERVAL_MINUTE_TO_SECOND | 113 |
| SQL_INTERVAL_MONTH | 102 |
| SQL_INTERVAL_SECOND | 106 |
| SQL_INTERVAL_YEAR | 101 |
| SQL_INTERVAL_YEAR_TO_MONTH | 107 |
| SQL_INVALID_HANDLE | -2 |
| SQL_IS_INTEGER | -6 |
| SQL_IS_POINTER | -4 |
| SQL_IS_SMALLINT | -8 |
| SQL_IS_UINTEGER | -5 |
| SQL_IS_USMALLINT | -7 |
| SQL_KEYSET_CURSOR_ATTRIBUTES1 | 150 |
| SQL_KEYSET_CURSOR_ATTRIBUTES2 | 151 |
| SQL_KEYSET_SIZE | 8 |
| SQL_KEYSET_SIZE_DEFAULT | 0 |
| SQL_KEYWORDS* | 89 |
| SQL_LIKE_ESCAPE_CLAUSE | 113 |
| SQL_LOCK_TYPES* | 78 |
| SQL_LOGIN_TIMEOUT | 103 |
| SQL_LOGIN_TIMEOUT_DEFAULT | 15 |
| SQL_LONGVARBINARY | -4 |
| SQL_LONGVARCHAR | -1 |
| SQL_MAX_ASYNC_CONCURRENT_STMTS | 10022 |
| SQL_MAX_BINARY_LITERAL_LEN | 112 |
| SQL_MAX_CATALOG_NAME_LEN | 34 |
| SQL_MAX_CHAR_LITERAL_LEN | 108 |
| SQL_MAX_COLUMN_NAME_LEN | 30 |
| SQL_MAX_COLUMNS_IN_GROUP_BY | 97 |
| SQL_MAX_COLUMNS_IN_INDEX | 98 |
| SQL_MAX_COLUMNS_IN_ORDER_BY | 99 |
| SQL_MAX_COLUMNS_IN_SELECT | 100 |
| SQL_MAX_COLUMNS_IN_TABLE | 101 |
| SQL_MAX_CONCURRENT_ACTIVITIES | 1 |
| SQL_MAX_CURSOR_NAME_LEN | 31 |
| SQL_MAX_DRIVER_CONNECTIONS | 0 |
| SQL_MAX_IDENTIFIER_LEN | 10005 |
| SQL_MAX_INDEX_SIZE | 102 |
| SQL_MAX_LENGTH | 3 |
| SQL_MAX_LENGTH_DEFAULT | 0 |
| SQL_MAX_MESSAGE_LENGTH | 512 |
| SQL_MAX_OWNER_NAME_LEN* | 32 |
| SQL_MAX_PROCEDURE_NAME_LEN | 33 |
| SQL_MAX_QUALIFIER_NAME_LEN* | 34 |
| SQL_MAX_ROW_SIZE | 104 |
| SQL_MAX_ROW_SIZE_INCLUDES_LONG | 103 |
| SQL_MAX_ROWS | 1 |
| SQL_MAX_ROWS_DEFAULT | 0 |
| SQL_MAX_SCHEMA_NAME_LEN | 32 |
| SQL_MAX_STATEMENT_LEN | 105 |
| SQL_MAX_TABLE_NAME_LEN | 35 |
| SQL_MAX_TABLES_IN_SELECT | 106 |
| SQL_MAX_USER_NAME_LEN | 107 |
| SQL_MODE_DEFAULT | 0 |
| SQL_MODE_READ_ONLY | 1 |
| SQL_MODE_READ_WRITE | 0 |
| SQL_MULTIPLE_ACTIVE_TXN | 37 |
| SQL_MULT_RESULT_SETS | 36 |
| SQL_NAMED | 0 |
| SQL_NC_HIGH | 0 |
| SQL_NC_LOW | 1 |
| SQL_NEED_DATA | 99 |
| SQL_NEED_LONG_DATA_LEN | 111 |
| SQL_NO_DATA | 100 |
| SQL_NO_DATA_FOUND | 100 |
| SQL_NO_NULLS | 0 |
| SQL_NON_NULLABLE_COLUMNS | 75 |
| SQL_NONSCROLLABLE | 0 |
| SQL_NOSCAN | 2 |
| SQL_NOSCAN_DEFAULT | 0 |
| SQL_NOSCAN_OFF | 0 |
| SQL_NOSCAN_ON | 1 |
| SQL_NTS | -3 |
| SQL_NTSL | -3 |
| SQL_NULL_COLLATION | 85 |
| SQL_NULL_DATA | -1 |
| SQL_NULL_HANDLE | 0 |
| SQL_NULL_HDBC | 0 |
| SQL_NULL_HDESC | 0 |
| SQL_NULL_HENV | 0 |
| SQL_NULL_HSTMT | 0 |
| SQL_NULLABLE | 1 |
| SQL_NULLABLE_UNKNOWN | 2 |
| SQL_NUMERIC | 2 |
| SQL_NUMERIC_FUNCTIONS | 49 |
| SQL_ODBC_API_CONFORMANCE* | 9 |
| SQL_ODBC_CURSORS | 110 |
| SQL_ODBC_INTERFACE_CONFORMANCE | 152 |
| SQL_ODBC_SAG_CLI_CONFORMANCE* | 12 |
| SQL_ODBC_SQL_CONFORMANCE* | 15 |
| SQL_ODBC_SQL_OPT_IEF* | 73 |
| SQL_ODBC_VER | 10 |
| SQL_OJ_ALL_COMPARISON_OPS | 64 |
| SQL_OJ_CAPABILITIES | 115 |
| SQL_OJ_CAPABILITIES | 65003 |
| SQL_OJ_FULL | 4 |
| SQL_OJ_INNER | 32 |
| SQL_OJ_LEFT | 1 |
| SQL_OJ_NESTED | 8 |
| SQL_OJ_NOT_ORDERED | 16 |
| SQL_OJ_RIGHT | 2 |
| SQL_OPT_TRACE | 104 |
| SQL_OPT_TRACEFILE | 105 |
| SQL_ORDER_BY_COLUMNS_IN_SELECT | 90 |
| SQL_OUTER_JOINS | 38 |
| SQL_OV_ODBC2 | 22 |
| SQL_OV_ODBC3 | 33 |
| SQL_OWNER_TERM* | 39 |
| SQL_OWNER_USAGE* | 91 |
| SQL_PACKET_SIZE | 112 |
| SQL_PARAM_ARRAY_ROW_COUNTS | 153 |
| SQL_PARAM_ARRAY_SELECTS | 154 |
| SQL_PARAM_BIND_BY_COLUMN | 0 |
| SQL_PARAM_BIND_TYPE_DEFAULT | 0 |
| SQL_PARAM_INPUT* | 1 |
| SQL_PARAM_INPUT_OUTPUT* | 2 |
| SQL_PARAM_OUTPUT* | 3 |
| SQL_PC_NON_PSEUDO | 1 |
| SQL_PC_PSEUDO | 2 |
| SQL_PC_UNKNOWN | 0 |
| SQL_POS_OPERATIONS* | 79 |
| SQL_POSITIONED_STATEMENTS* | 80 |
| SQL_PRED_BASIC | 2 |
| SQL_PRED_CHAR | 1 |
| SQL_PRED_NONE | 0 |
| SQL_PROCEDURES | 21 |
| SQL_PROCEDURE_TERM | 40 |
| SQL_PT_FUNCTION | 2 |
| SQL_PT_PROCEDURE | 1 |
| SQL_PT_UNKNOWN | 0 |
| SQL_QUALIFIER_LOCATION* | 114 |
| SQL_QUALIFIER_NAME_SEPARATOR* | 41 |
| SQL_QUALIFIER_TERM* | 42 |
| SQL_QUALIFIER_USAGE* | 92 |
| SQL_QUERY_TIMEOUT | 0 |
| SQL_QUERY_TIMEOUT_DEFAULT | 0 |
| SQL_QUIET_MODE | 111 |
| SQL_QUOTED_IDENTIFIER_CASE | 93 |
| SQL_RD_DEFAULT | 1 |
| SQL_RD_OFF | 0 |
| SQL_RD_ON | 1 |
| SQL_REAL | 7 |
| SQL_RESET_PARAMS | 3 |
| SQL_RETRIEVE_DATA | 11 |
| SQL_ROLLBACK | 1 |
| SQL_ROW_IDENTIFIER | 1 |
| SQL_ROW_NUMBER | 14 |
| SQL_ROW_UPDATES | 11 |
| SQL_ROWSET_SIZE | 9 |
| SQL_ROWSET_SIZE_DEFAULT | 1 |
| SQL_ROWVER | 2 |
| SQL_SC_NON_UNIQUE | 0 |
| SQL_SC_TRY_UNIQUE | 1 |
| SQL_SC_UNIQUE | 2 |
| SQL_SCCO_LOCK | 2 |
| SQL_SCCO_OPT_ROWVER | 4 |
| SQL_SCCO_OPT_VALUES | 8 |
| SQL_SCCO_READ_ONLY | 1 |
| SQL_SCHEMA_TERM | 39 |
| SQL_SCHEMA_USAGE | 91 |
| SQL_SCOPE_CURROW | 0 |
| SQL_SCOPE_SESSION | 2 |
| SQL_SCOPE_TRANSACTION | 1 |
| SQL_SCROLL_CONCURRENCY | 43 |
| SQL_SCROLL_OPTIONS | 44 |
| SQL_SCROLLABLE | 1 |
| SQL_SEARCH_PATTERN_ESCAPE | 14 |
| SQL_SENSITIVE | 2 |
| SQL_SERVER_NAME | 13 |
| SQL_SIGNED_OFFSET | -20 |
| SQL_SIMULATE_CURSOR | 10 |
| SQL_SMALLINT | 5 |
| SQL_SPECIAL_CHARACTERS | 94 |
| SQL_SQL_CONFORMANCE | 118 |
| SQL_SQL92_DATETIME_FUNCTIONS* | 155 |
| SQL_SQL92_FOREIGN_KEY_DELETE_RULE* | 156 |
| SQL_SQL92_FOREIGN_KEY_UPDATE_RULE* | 157 |
| SQL_SQL92_GRANT* | 158 |
| SQL_SQL92_NUMERIC_VALUE_FUNCTIONS* | 159 |
| SQL_SQL92_PREDICATES* | 160 |
| SQL_SQL92_RELATIONAL_JOIN_OPERATORS* | 161 |
| SQL_SQL92_REVOKE* | 162 |
| SQL_SQL92_ROW_VALUE_CONSTRUCTOR* | 163 |
| SQL_SQL92_STRING_FUNCTIONS* | 164 |
| SQL_SQL92_VALUE_EXPRESSIONS* | 165 |
| SQL_STANDARD_CLI_CONFORMANCE* | 166 |
| SQL_STATIC_CURSOR_ATTRIBUTES1 | 167 |
| SQL_STATIC_CURSOR_ATTRIBUTES2 | 168 |
| SQL_STATIC_SENSITIVITY* | 83 |
| SQL_STILL_EXECUTING | 2 |
| SQL_STRING_FUNCTIONS | 50 |
| SQL_SUBQUERIES* | 95 |
| SQL_SUCCESS | 0 |
| SQL_SUCCESS_WITH_INFO | 1 |
| SQL_SYSTEM_FUNCTIONS | 51 |
| SQL_TABLE_TERM | 45 |
| SQL_TC_ALL | 2 |
| SQL_TC_DDL_COMMIT | 3 |
| SQL_TC_DDL_IGNORE | 4 |
| SQL_TC_DML | 1 |
| SQL_TC_NONE | 0 |
| SQL_TIME | 10 |
| SQL_TIME_LEN | 8 |
| SQL_TIMEDATE_ADD_INTERVALS | 109 |
| SQL_TIMEDATE_DIFF_INTERVALS | 110 |
| SQL_TIMEDATE_FUNCTIONS | 52 |
| SQL_TIMESTAMP | 11 |
| SQL_TIMESTAMP_LEN | 19 |
| SQL_TINYINT | -6 |
| SQL_TRANSLATE_DLL | 106 |
| SQL_TRANSLATE_OPTION | 107 |
| SQL_TRUE | 1 |
| SQL_TXN_CAPABLE | 46 |
| SQL_TXN_ISOLATION | 108 |
| SQL_TXN_ISOLATION_OPTION | 72 |
| SQL_TXN_READ_COMMITTED | 2 |
| SQL_TXN_READ_UNCOMMITTED | 1 |
| SQL_TXN_REPEATABLE_READ | 4 |
| SQL_TXN_SERIALIZABLE | 8 |
| SQL_TYPE_DATE | 91 |
| SQL_TYPE_TIME | 92 |
| SQL_TYPE_TIMESTAMP | 93 |
| SQL_UB_DEFAULT | 0 |
| SQL_UB_FIXED | 1 |
| SQL_UB_OFF | 0 |
| SQL_UB_ON | 1 |
| SQL_UB_VARIABLE | 2 |
| SQL_UNBIND | 2 |
| SQL_UNICODE | -95 |
| SQL_UNICODE_CHAR | -95 |
| SQL_UNICODE_LONGVARCHAR | -97 |
| SQL_UNICODE_VARCHAR | -96 |
| SQL_UNION | 96 |
| SQL_UNKNOWN_TYPE 0 | 0 |
| SQL_UNNAMED | 1 |
| SQL_UNSIGNED_OFFSET | -22 |
| SQL_UNSPECIFIED | 0 |
| SQL_USE_BOOKMARKS | 12 |
| SQL_USER_NAME | 47 |
| SQL_VARBINARY | -3 |
| SQL_VARCHAR | 12 |
| SQL_WCHAR | -8 |
| SQL_WLONGVARCHAR | -10 |
| SQL_WVARCHAR | -9 |
| SQL_XOPEN_CLI_YEAR | 10000 |
PROPERTIES
Product: 4D
Theme: Appendixes
© 1985-2013 4D SAS / 4D, Inc. All rights reserved.