4D v16

Appendix B, 4D ODBC PRO Constants

ホーム

 
4D v16
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.

ConstantValue
SQL_ACCESS_MODE101
SQL_ACCESSIBLE_PROCEDURES20
SQL_ACCESSIBLE_TABLES19
SQL_ACTIVE_CONNECTIONS*0
SQL_ACTIVE_ENVIRONMENTS116
SQL_ACTIVE_STATEMENTS*1
SQL_AGGREGATE_FUNCTIONS169
SQL_ALL_TYPES0
SQL_ALTER_DOMAIN117
SQL_ALTER_TABLE86
SQL_AM_CONNECTION1
SQL_AM_NONE0
SQL_AM_STATEMENT2
SQL_API_SQLALLOCCONNECT1
SQL_API_SQLALLOCENV2
SQL_API_SQLALLOCHANDLE1001
SQL_API_SQLALLOCSTMT3
SQL_API_SQLBINDCOL4
SQL_API_SQLBINDPARAM1002
SQL_API_SQLBINDPARAMETER72
SQL_API_SQLBROWSECONNECT55
SQL_API_SQLCANCEL5
SQL_API_SQLCLOSECURSOR1003
SQL_API_SQLCOLATTRIBUTES6
SQL_API_SQLCOLUMNPRIVILEGES56
SQL_API_SQLCOLUMNS40
SQL_API_SQLCONNECT7
SQL_API_SQLCOPYDESC1004
SQL_API_SQLDATASOURCES57
SQL_API_SQLDESCRIBECOL8
SQL_API_SQLDESCRIBEPARAM58
SQL_API_SQLDISCONNECT9
SQL_API_SQLDRIVERCONNECT41
SQL_API_SQLDRIVERS71
SQL_API_SQLENDTRAN1005
SQL_API_SQLERROR10
SQL_API_SQLEXECDIRECT11
SQL_API_SQLEXECUTE12
SQL_API_SQLEXTENDEDFETCH59
SQL_API_SQLFETCH13
SQL_API_SQLFETCHSCROLL1021
SQL_API_SQLFOREIGNKEYS60
SQL_API_SQLFREECONNECT14
SQL_API_SQLFREEENV15
SQL_API_SQLFREEHANDLE1006
SQL_API_SQLFREESTMT16
SQL_API_SQLGETCONNECTATTR1007
SQL_API_SQLGETCONNECTOPTION42
SQL_API_SQLGETCURSORNAME17
SQL_API_SQLGETDATA43
SQL_API_SQLGETDESCFIELD1008
SQL_API_SQLGETDESCREC1009
SQL_API_SQLGETDIAGFIELD1010
SQL_API_SQLGETDIAGREC1011
SQL_API_SQLGETENVATTR1012
SQL_API_SQLGETFUNCTIONS44
SQL_API_SQLGETINFO45
SQL_API_SQLGETSTMTATTR1014
SQL_API_SQLGETSTMTOPTION46
SQL_API_SQLGETTYPEINFO47
SQL_API_SQLMORERESULTS61
SQL_API_SQLNATIVESQL62
SQL_API_SQLNUMPARAMS63
SQL_API_SQLNUMRESULTCOLS18
SQL_API_SQLPARAMDATA48
SQL_API_SQLPARAMOPTIONS64
SQL_API_SQLPREPARE19
SQL_API_SQLPRIMARYKEYS65
SQL_API_SQLPROCEDURECOLUMNS66
SQL_API_SQLPROCEDURES67
SQL_API_SQLPUTDATA49
SQL_API_SQLROWCOUNT20
SQL_API_SQLSETCONNECTATTR1016
SQL_API_SQLSETCONNECTOPTION50
SQL_API_SQLSETCURSORNAME21
SQL_API_SQLSETDESCFIELD1017
SQL_API_SQLSETDESCREC1018
SQL_API_SQLSETENVATTR1019
SQL_API_SQLSETPARAM22
SQL_API_SQLSETPOS68
SQL_API_SQLSETSCROLLOPTIONS69
SQL_API_SQLSETSTMTATTR1020
SQL_API_SQLSETSTMTOPTION51
SQL_API_SQLSPECIALCOLUMNS52
SQL_API_SQLSTATISTICS53
SQL_API_SQLTABLEPRIVILEGES70
SQL_API_SQLTABLES54
SQL_API_SQLTRANSACT23
SQL_ARD_TYPE-99
SQL_ASYNC_ENABLE4
SQL_ASYNC_ENABLE_DEFAULT0
SQL_ASYNC_ENABLE_OFF0
SQL_ASYNC_ENABLE_ON1
SQL_ASYNC_MODE10021
SQL_AT_ADD_COLUMN1
SQL_AT_ADD_CONSTRAINT8
SQL_AT_DROP_COLUMN2
SQL_ATTR_ACCESS_MODE101
SQL_ATTR_APP_PARAM_DESC10011
SQL_ATTR_APP_ROW_DESC10010
SQL_ATTR_ASYNC_ENABLE4
SQL_ATTR_AUTO_IPD10001
SQL_ATTR_AUTOCOMMIT102
SQL_ATTR_CONCURRENCY7
SQL_ATTR_CONNECTION_DEAD1209
SQL_ATTR_CONNECTION_POOLING201
SQL_ATTR_CONNECTION_TIMEOUT113
SQL_ATTR_CP_MATCH202
SQL_ATTR_CURRENT_CATALOG109
SQL_ATTR_CURSOR_SCROLLABLE-1
SQL_ATTR_CURSOR_SENSITIVITY-2
SQL_ATTR_CURSOR_TYPE6
SQL_ATTR_DISCONNECT_BEHAVIOR114
SQL_ATTR_ENABLE_AUTO_IPD15
SQL_ATTR_ENLIST_IN_DTC1207
SQL_ATTR_ENLIST_IN_XA1208
SQL_ATTR_FETCH_BOOKMARK_PTR16
SQL_ATTR_IMP_PARAM_DESC10013
SQL_ATTR_IMP_ROW_DESC10012
SQL_ATTR_KEYSET_SIZE8
SQL_ATTR_LOGIN_TIMEOUT103
SQL_ATTR_MAX_LENGTH3
SQL_ATTR_MAX_ROWS1
SQL_ATTR_METADATA_ID10014
SQL_ATTR_NOSCAN2
SQL_ATTR_ODBC_CURSORS110
SQL_ATTR_ODBC_VERSION200
SQL_ATTR_OUTPUT_NTS10001
SQL_ATTR_PACKET_SIZE112
SQL_ATTR_PARAM_BIND_OFFSET_PTR17
SQL_ATTR_PARAM_BIND_TYPE18
SQL_ATTR_PARAM_OPERATION_PTR19
SQL_ATTR_PARAM_STATUS_PTR20
SQL_ATTR_PARAMS_PROCESSED_PTR21
SQL_ATTR_PARAMSET_SIZE22
SQL_ATTR_QUERY_TIMEOUT0
SQL_ATTR_QUIET_MODE111
SQL_ATTR_RETRIEVE_DATA11
SQL_ATTR_ROW_ARRAY_SIZE27
SQL_ATTR_ROW_BIND_OFFSET_PTR23
SQL_ATTR_ROW_BIND_TYPE5
SQL_ATTR_ROW_NUMBER14
SQL_ATTR_ROW_OPERATION_PTR24
SQL_ATTR_ROW_STATUS_PTR25
SQL_ATTR_ROWS_FETCHED_PTR26
SQL_ATTR_SIMULATE_CURSOR10
SQL_ATTR_TRACE104
SQL_ATTR_TRACEFILE105
SQL_ATTR_TRANSLATE_LIB106
SQL_ATTR_TRANSLATE_OPTION107
SQL_ATTR_TXN_ISOLATION108
SQL_ATTR_USE_BOOKMARKS12
SQL_AUTOCOMMIT102
SQL_AUTOCOMMIT_DEFAULT1
SQL_AUTOCOMMIT_OFF0
SQL_AUTOCOMMIT_ON1
SQL_BATCH_ROW_COUNT120
SQL_BATCH_SUPPORT121
SQL_BEST_ROWID1
SQL_BIGINT-5
SQL_BINARY-2
SQL_BIND_BY_COLUMN0
SQL_BIND_TYPE5
SQL_BIND_TYPE_DEFAULT0
SQL_BIT-7
SQL_BOOKMARK_PERSISTENCE82
SQL_C_CHAR1
SQL_C_DEFAULT99
SQL_C_DOUBLE8
SQL_C_FLOAT7
SQL_C_LONG4
SQL_C_NUMERIC2
SQL_C_SHORT5
SQL_CATALOG_LOCATION114
SQL_CATALOG_NAME10003
SQL_CATALOG_NAME_SEPARATOR41
SQL_CATALOG_TERM42
SQL_CATALOG_USAGE92
SQL_CB_CLOSE1
SQL_CB_DELETE0
SQL_CB_PRESERVE2
SQL_CD_FALSE0
SQL_CD_TRUE1
SQL_CHAR1
SQL_CLOSE0
SQL_CODE_DATE1
SQL_CODE_DAY3
SQL_CODE_DAY_TO_HOUR8
SQL_CODE_DAY_TO_MINUTE9
SQL_CODE_DAY_TO_SECOND10
SQL_CODE_HOUR4
SQL_CODE_HOUR_TO_MINUTE11
SQL_CODE_HOUR_TO_SECOND12
SQL_CODE_MINUTE5
SQL_CODE_MINUTE_TO_SECOND13
SQL_CODE_MONTH2
SQL_CODE_SECOND6
SQL_CODE_TIME2
SQL_CODE_TIMESTAMP3
SQL_CODE_YEAR1
SQL_CODE_YEAR_TO_MONTH7
SQL_COL_PRED_BASIC2
SQL_COL_PRED_CHAR1
SQL_COLLATION_SEQ10004
SQL_COLUMN_ALIAS*87
SQL_COMMIT0
SQL_CONCAT_NULL_BEHAVIOR22
SQL_CONCUR_DEFAULT1
SQL_CONCUR_LOCK2
SQL_CONCUR_READ_ONLY1
SQL_CONCUR_ROWVER3
SQL_CONCUR_VALUES4
SQL_CONCURRENCY7
SQL_CONVERT_BIGINT53
SQL_CONVERT_BINARY54
SQL_CONVERT_BIT55
SQL_CONVERT_CHAR56
SQL_CONVERT_DATE57
SQL_CONVERT_DECIMAL58
SQL_CONVERT_DOUBLE59
SQL_CONVERT_FLOAT60
SQL_CONVERT_FUNCTIONS48
SQL_CONVERT_GUID*173
SQL_CONVERT_INTEGER61
SQL_CONVERT_INTERVAL_DAY_TIME123
SQL_CONVERT_INTERVAL_YEAR_MONTH124
SQL_CONVERT_LONGVARBINARY71
SQL_CONVERT_LONGVARCHAR62
SQL_CONVERT_NUMERIC63
SQL_CONVERT_REAL64
SQL_CONVERT_SMALLINT65
SQL_CONVERT_TIME66
SQL_CONVERT_TIMESTAMP67
SQL_CONVERT_TINYINT68
SQL_CONVERT_VARBINARY69
SQL_CONVERT_VARCHAR70
SQL_CONVERT_WCHAR*122
SQL_CONVERT_WLONGVARCHAR*125
SQL_CONVERT_WVARCHAR*126
SQL_CORRELATION_NAME74
SQL_CP_DEFAULT0
SQL_CP_MATCH_DEFAULT0
SQL_CP_OFF0
SQL_CP_ONE_PER_DRIVER1
SQL_CP_ONE_PER_HENV2
SQL_CP_RELAXED_MATCH1
SQL_CP_STRICT_MATCH0
SQL_CREATE_ASSERTION127
SQL_CREATE_CHARACTER_SET128
SQL_CREATE_COLLATION129
SQL_CREATE_DOMAIN130
SQL_CREATE_SCHEMA131
SQL_CREATE_TABLE132
SQL_CREATE_TRANSLATION133
SQL_CREATE_VIEW*134
SQL_CUR_DEFAULT2
SQL_CUR_USE_DRIVER2
SQL_CUR_USE_IF_NEEDED0
SQL_CUR_USE_ODBC1
SQL_CURRENT_QUALIFIER109
SQL_CURSOR_COMMIT_BEHAVIOR23
SQL_CURSOR_DYNAMIC2
SQL_CURSOR_FORWARD_ONLY0
SQL_CURSOR_KEYSET_DRIVEN1
SQL_CURSOR_ROLLBACK_BEHAVIOR24
SQL_CURSOR_SENSITIVITY10001
SQL_CURSOR_STATIC3
SQL_CURSOR_TYPE6
SQL_CURSOR_TYPE_DEFAULT0
SQL_DATA_AT_EXEC-2
SQL_DATA_SOURCE_NAME2
SQL_DATA_SOURCE_READ_ONLY25
SQL_DATE9
SQL_DATE_LEN10
SQL_DATETIME9
SQL_DATETIME_LITERALS*119
SQL_DB_DEFAULT0
SQL_DB_DISCONNECT1
SQL_DB_RETURN_TO_POOL0
SQL_DBMS_NAME17
SQL_DBMS_VER18
SQL_DDL_INDEX170
SQL_DECIMAL3
SQL_DEFAULT99
SQL_DEFAULT_TXN_ISOLATION26
SQL_DESC_ALLOC_AUTO1
SQL_DESC_ALLOC_TYPE1099
SQL_DESC_ALLOC_USER2
SQL_DESC_ARRAY_SIZE20
SQL_DESC_ARRAY_STATUS_PTR21
SQL_DESC_AUTO_UNIQUE_VALUE11
SQL_DESC_BASE_COLUMN_NAME22
SQL_DESC_BASE_TABLE_NAME23
SQL_DESC_BIND_OFFSET_PTR24
SQL_DESC_BIND_TYPE25
SQL_DESC_CASE_SENSITIVE12
SQL_DESC_CATALOG_NAME17
SQL_DESC_CONCISE_TYPE2
SQL_DESC_COUNT1001
SQL_DESC_DATA_PTR1010
SQL_DESC_DATETIME_INTERVAL_COD1007
SQL_DESC_DATETIME_INTERVAL_PRE26
SQL_DESC_DISPLAY_SIZE6
SQL_DESC_FIXED_PREC_SCALE9
SQL_DESC_INDICATOR_PTR1009
SQL_DESC_LABEL18
SQL_DESC_LENGTH1003
SQL_DESC_LITERAL_PREFIX27
SQL_DESC_LITERAL_SUFFIX28
SQL_DESC_LOCAL_TYPE_NAME29
SQL_DESC_MAXIMUM_SCALE30
SQL_DESC_MINIMUM_SCALE31
SQL_DESC_NAME1011
SQL_DESC_NULLABLE1008
SQL_DESC_NUM_PREC_RADIX32
SQL_DESC_OCTET_LENGTH1013
SQL_DESC_OCTET_LENGTH_PTR1004
SQL_DESC_PARAMETER_TYPE33
SQL_DESC_PRECISION1005
SQL_DESC_ROWS_PROCESSED_PTR34
SQL_DESC_SCALE1006
SQL_DESC_SCHEMA_NAME16
SQL_DESC_SEARCHABLE13
SQL_DESC_TABLE_NAME15
SQL_DESC_TYPE1002
SQL_DESC_TYPE_NAME14
SQL_DESC_UNNAMED1012
SQL_DESC_UNSIGNED8
SQL_DESC_UPDATABLE10
SQL_DESCRIBE_PARAMETER10002
SQL_DIAG_ALTER_DOMAIN3
SQL_DIAG_ALTER_TABLE4
SQL_DIAG_CALL7
SQL_DIAG_CLASS_ORIGIN8
SQL_DIAG_COLUMN_NUMBER-1247
SQL_DIAG_CONNECTION_NAME10
SQL_DIAG_CREATE_ASSERTION6
SQL_DIAG_CREATE_CHARACTER_SET8
SQL_DIAG_CREATE_COLLATION10
SQL_DIAG_CREATE_DOMAIN23
SQL_DIAG_CREATE_INDEX-1
SQL_DIAG_CREATE_SCHEMA64
SQL_DIAG_CREATE_TABLE77
SQL_DIAG_CREATE_TRANSLATION79
SQL_DIAG_CREATE_VIEW84
SQL_DIAG_CURSOR_ROW_COUNT-1249
SQL_DIAG_DELETE_WHERE19
SQL_DIAG_DROP_ASSERTION 224
SQL_DIAG_DROP_CHARACTER_SET 225
SQL_DIAG_DROP_COLLATION 226
SQL_DIAG_DROP_DOMAIN 227
SQL_DIAG_DROP_INDEX-2
SQL_DIAG_DROP_SCHEMA31
SQL_DIAG_DROP_TABLE32
SQL_DIAG_DROP_TRANSLATION33
SQL_DIAG_DROP_VIEW36
SQL_DIAG_DYNAMIC_DELETE_CURSOR38
SQL_DIAG_DYNAMIC_FUNCTION7
SQL_DIAG_DYNAMIC_FUNCTION_CODE12
SQL_DIAG_DYNAMIC_UPDATE_CURSOR81
SQL_DIAG_GRANT48
SQL_DIAG_INSERT50
SQL_DIAG_MESSAGE_TEXT6
SQL_DIAG_NATIVE5
SQL_DIAG_NUMBER2
SQL_DIAG_RETURNCODE1
SQL_DIAG_REVOKE59
SQL_DIAG_ROW_COUNT3
SQL_DIAG_ROW_NUMBER-1248
SQL_DIAG_SELECT_CURSOR85
SQL_DIAG_SERVER_NAME11
SQL_DIAG_SQLSTATE4
SQL_DIAG_SUBCLASS_ORIGIN9
SQL_DIAG_UNKNOWN_STATEMENT0
SQL_DIAG_UPDATE_WHERE82
SQL_DM_VER*171
SQL_DOUBLE8
SQL_DRIVER_HDBC3
SQL_DRIVER_HDESC135
SQL_DRIVER_HENV4
SQL_DRIVER_HLIB76
SQL_DRIVER_HSTMT5
SQL_DRIVER_NAME6
SQL_DRIVER_ODBC_VER77
SQL_DRIVER_VER7
SQL_DROP1
SQL_DROP_ASSERTION136
SQL_DROP_CHARACTER_SET137
SQL_DROP_COLLATION138
SQL_DROP_DOMAIN139
SQL_DROP_SCHEMA140
SQL_DROP_TABLE141
SQL_DROP_TRANSLATION142
SQL_DROP_VIEW143
SQL_DTC_DONE0
SQL_DYNAMIC_CURSOR_ATTRIBUTES1144
SQL_DYNAMIC_CURSOR_ATTRIBUTES2145 
SQL_ERROR-1
SQL_EXPRESSIONS_IN_ORDERBY27
SQL_FALSE0
SQL_FD_FETCH_ABSOLUTE16
SQL_FD_FETCH_FIRST2
SQL_FD_FETCH_LAST4
SQL_FD_FETCH_NEXT1
SQL_FD_FETCH_PRIOR8
SQL_FD_FETCH_RELATIVE32
SQL_FETCH_ABSOLUTE5
SQL_FETCH_DIRECTION8
SQL_FETCH_FIRST2
SQL_FETCH_LAST3
SQL_FETCH_NEXT1
SQL_FETCH_PRIOR4
SQL_FETCH_RELATIVE6
SQL_FILE_USAGE84
SQL_FLOAT6
SQL_FORWARD_ONLY_CURSOR_ATTRS1146
SQL_FORWARD_ONLY_CURSOR_ATTRS2147
SQL_GD_ANY_COLUMN1
SQL_GD_ANY_ORDER2
SQL_GET_BOOKMARK13
SQL_GETDATA_EXTENSIONS81
SQL_GUID-11
SQL_GROUP_BY88
SQL_HANDLE_DBC2
SQL_HANDLE_DESC4
SQL_HANDLE_ENV1
SQL_HANDLE_SENV5
SQL_HANDLE_STMT3
SQL_IC_LOWER2
SQL_IC_MIXED4
SQL_IC_SENSITIVE3
SQL_IC_UPPER1
SQL_IDENTIFIER_CASE28
SQL_IDENTIFIER_QUOTE_CHAR29
SQL_INDEX_ALL1
SQL_INDEX_CLUSTERED1
SQL_INDEX_HASHED2
SQL_INDEX_KEYWORDS148
SQL_INDEX_OTHER3
SQL_INDEX_UNIQUE0
SQL_INFO_SCHEMA_VIEWS149
SQL_INSENSITIVE1
SQL_INSERT_STATEMENT172
SQL_INTEGER4
SQL_INTEGRITY73
SQL_INTERVAL10
SQL_INTERVAL_DAY103
SQL_INTERVAL_DAY_TO_HOUR108
SQL_INTERVAL_DAY_TO_MINUTE109
SQL_INTERVAL_DAY_TO_SECOND110
SQL_INTERVAL_HOUR104
SQL_INTERVAL_HOUR_TO_MINUTE111
SQL_INTERVAL_HOUR_TO_SECOND112
SQL_INTERVAL_MINUTE105
SQL_INTERVAL_MINUTE_TO_SECOND113
SQL_INTERVAL_MONTH102
SQL_INTERVAL_SECOND106
SQL_INTERVAL_YEAR101
SQL_INTERVAL_YEAR_TO_MONTH107
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_ATTRIBUTES1150
SQL_KEYSET_CURSOR_ATTRIBUTES2151
SQL_KEYSET_SIZE8
SQL_KEYSET_SIZE_DEFAULT0
SQL_KEYWORDS*89
SQL_LIKE_ESCAPE_CLAUSE113
SQL_LOCK_TYPES*78
SQL_LOGIN_TIMEOUT103
SQL_LOGIN_TIMEOUT_DEFAULT15
SQL_LONGVARBINARY-4
SQL_LONGVARCHAR-1
SQL_MAX_ASYNC_CONCURRENT_STMTS10022
SQL_MAX_BINARY_LITERAL_LEN112
SQL_MAX_CATALOG_NAME_LEN34
SQL_MAX_CHAR_LITERAL_LEN108
SQL_MAX_COLUMN_NAME_LEN30
SQL_MAX_COLUMNS_IN_GROUP_BY97
SQL_MAX_COLUMNS_IN_INDEX98
SQL_MAX_COLUMNS_IN_ORDER_BY99
SQL_MAX_COLUMNS_IN_SELECT100
SQL_MAX_COLUMNS_IN_TABLE101
SQL_MAX_CONCURRENT_ACTIVITIES1
SQL_MAX_CURSOR_NAME_LEN31
SQL_MAX_DRIVER_CONNECTIONS0
SQL_MAX_IDENTIFIER_LEN10005
SQL_MAX_INDEX_SIZE102
SQL_MAX_LENGTH3
SQL_MAX_LENGTH_DEFAULT0
SQL_MAX_MESSAGE_LENGTH512
SQL_MAX_OWNER_NAME_LEN*32
SQL_MAX_PROCEDURE_NAME_LEN33
SQL_MAX_QUALIFIER_NAME_LEN*34
SQL_MAX_ROW_SIZE104
SQL_MAX_ROW_SIZE_INCLUDES_LONG103
SQL_MAX_ROWS1
SQL_MAX_ROWS_DEFAULT0
SQL_MAX_SCHEMA_NAME_LEN32
SQL_MAX_STATEMENT_LEN105
SQL_MAX_TABLE_NAME_LEN35
SQL_MAX_TABLES_IN_SELECT106
SQL_MAX_USER_NAME_LEN107
SQL_MODE_DEFAULT0
SQL_MODE_READ_ONLY1
SQL_MODE_READ_WRITE0
SQL_MULTIPLE_ACTIVE_TXN37
SQL_MULT_RESULT_SETS36
SQL_NAMED0
SQL_NC_HIGH0
SQL_NC_LOW1
SQL_NEED_DATA99
SQL_NEED_LONG_DATA_LEN111
SQL_NO_DATA100
SQL_NO_DATA_FOUND100
SQL_NO_NULLS0
SQL_NON_NULLABLE_COLUMNS75
SQL_NONSCROLLABLE0
SQL_NOSCAN2
SQL_NOSCAN_DEFAULT0
SQL_NOSCAN_OFF0
SQL_NOSCAN_ON1
SQL_NTS-3
SQL_NTSL-3
SQL_NULL_COLLATION85
SQL_NULL_DATA-1
SQL_NULL_HANDLE0
SQL_NULL_HDBC0
SQL_NULL_HDESC0
SQL_NULL_HENV0
SQL_NULL_HSTMT0
SQL_NULLABLE1
SQL_NULLABLE_UNKNOWN2
SQL_NUMERIC2
SQL_NUMERIC_FUNCTIONS49
SQL_ODBC_API_CONFORMANCE*9
SQL_ODBC_CURSORS110
SQL_ODBC_INTERFACE_CONFORMANCE152
SQL_ODBC_SAG_CLI_CONFORMANCE*12
SQL_ODBC_SQL_CONFORMANCE*15
SQL_ODBC_SQL_OPT_IEF*73
SQL_ODBC_VER10
SQL_OJ_ALL_COMPARISON_OPS64
SQL_OJ_CAPABILITIES115
SQL_OJ_CAPABILITIES65003
SQL_OJ_FULL4
SQL_OJ_INNER32
SQL_OJ_LEFT1
SQL_OJ_NESTED8
SQL_OJ_NOT_ORDERED16
SQL_OJ_RIGHT2
SQL_OPT_TRACE104
SQL_OPT_TRACEFILE105
SQL_ORDER_BY_COLUMNS_IN_SELECT90
SQL_OUTER_JOINS38
SQL_OV_ODBC222
SQL_OV_ODBC333
SQL_OWNER_TERM*39
SQL_OWNER_USAGE*91
SQL_PACKET_SIZE112
SQL_PARAM_ARRAY_ROW_COUNTS153
SQL_PARAM_ARRAY_SELECTS154
SQL_PARAM_BIND_BY_COLUMN0
SQL_PARAM_BIND_TYPE_DEFAULT0
SQL_PARAM_INPUT*1
SQL_PARAM_INPUT_OUTPUT*2
SQL_PARAM_OUTPUT*3
SQL_PC_NON_PSEUDO1
SQL_PC_PSEUDO2
SQL_PC_UNKNOWN0
SQL_POS_OPERATIONS*79
SQL_POSITIONED_STATEMENTS*80
SQL_PRED_BASIC2
SQL_PRED_CHAR1
SQL_PRED_NONE0
SQL_PROCEDURES21
SQL_PROCEDURE_TERM40
SQL_PT_FUNCTION2
SQL_PT_PROCEDURE1
SQL_PT_UNKNOWN0
SQL_QUALIFIER_LOCATION*114
SQL_QUALIFIER_NAME_SEPARATOR*41
SQL_QUALIFIER_TERM*42
SQL_QUALIFIER_USAGE*92
SQL_QUERY_TIMEOUT0
SQL_QUERY_TIMEOUT_DEFAULT0
SQL_QUIET_MODE111
SQL_QUOTED_IDENTIFIER_CASE93
SQL_RD_DEFAULT1
SQL_RD_OFF0
SQL_RD_ON1
SQL_REAL7
SQL_RESET_PARAMS3
SQL_RETRIEVE_DATA11
SQL_ROLLBACK1
SQL_ROW_IDENTIFIER1
SQL_ROW_NUMBER14
SQL_ROW_UPDATES11
SQL_ROWSET_SIZE9
SQL_ROWSET_SIZE_DEFAULT1
SQL_ROWVER
SQL_SC_NON_UNIQUE0
SQL_SC_TRY_UNIQUE1
SQL_SC_UNIQUE2
SQL_SCCO_LOCK2
SQL_SCCO_OPT_ROWVER4
SQL_SCCO_OPT_VALUES8
SQL_SCCO_READ_ONLY1
SQL_SCHEMA_TERM39
SQL_SCHEMA_USAGE91
SQL_SCOPE_CURROW0
SQL_SCOPE_SESSION2
SQL_SCOPE_TRANSACTION1
SQL_SCROLL_CONCURRENCY43
SQL_SCROLL_OPTIONS44
SQL_SCROLLABLE1
SQL_SEARCH_PATTERN_ESCAPE14
SQL_SENSITIVE2
SQL_SERVER_NAME13
SQL_SIGNED_OFFSET-20
SQL_SIMULATE_CURSOR10
SQL_SMALLINT5
SQL_SPECIAL_CHARACTERS94
SQL_SQL_CONFORMANCE118
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_ATTRIBUTES1167
SQL_STATIC_CURSOR_ATTRIBUTES2168
SQL_STATIC_SENSITIVITY*83
SQL_STILL_EXECUTING2
SQL_STRING_FUNCTIONS50
SQL_SUBQUERIES*95
SQL_SUCCESS0
SQL_SUCCESS_WITH_INFO1
SQL_SYSTEM_FUNCTIONS51
SQL_TABLE_TERM45
SQL_TC_ALL2
SQL_TC_DDL_COMMIT3
SQL_TC_DDL_IGNORE4
SQL_TC_DML1
SQL_TC_NONE0
SQL_TIME10
SQL_TIME_LEN8
SQL_TIMEDATE_ADD_INTERVALS109
SQL_TIMEDATE_DIFF_INTERVALS110
SQL_TIMEDATE_FUNCTIONS52
SQL_TIMESTAMP11
SQL_TIMESTAMP_LEN19
SQL_TINYINT-6
SQL_TRANSLATE_DLL106
SQL_TRANSLATE_OPTION107
SQL_TRUE1
SQL_TXN_CAPABLE46
SQL_TXN_ISOLATION108
SQL_TXN_ISOLATION_OPTION72
SQL_TXN_READ_COMMITTED2
SQL_TXN_READ_UNCOMMITTED1
SQL_TXN_REPEATABLE_READ4
SQL_TXN_SERIALIZABLE8
SQL_TYPE_DATE91
SQL_TYPE_TIME92
SQL_TYPE_TIMESTAMP93
SQL_UB_DEFAULT0
SQL_UB_FIXED1
SQL_UB_OFF0
SQL_UB_ON1
SQL_UB_VARIABLE2
SQL_UNBIND2
SQL_UNICODE-95
SQL_UNICODE_CHAR-95
SQL_UNICODE_LONGVARCHAR-97
SQL_UNICODE_VARCHAR-96
SQL_UNION96
SQL_UNKNOWN_TYPE 00
SQL_UNNAMED1
SQL_UNSIGNED_OFFSET-22
SQL_UNSPECIFIED0
SQL_USE_BOOKMARKS12
SQL_USER_NAME47
SQL_VARBINARY-3
SQL_VARCHAR12
SQL_WCHAR-8
SQL_WLONGVARCHAR-10
SQL_WVARCHAR-9
SQL_XOPEN_CLI_YEAR10000


 
プロパティ 

プロダクト: 4D
テーマ: Appendixes

 
履歴 

 
ARTICLE USAGE

4D ODBC Pro ( 4D v16)