Module: IBM_DB
- Defined in:
- ext/ibm_db.c
Defined Under Namespace
Classes: ClientInfo, Connection, PConnection, RowObject, ServerInfo, Statement
Constant Summary collapse
- BINARY =
Specifies that binary data shall be converted to a hexadecimal encoding and returned as an ASCII string
INT2NUM(1)
- CONVERT =
Specifies that binary data shall be converted to a hexadecimal encoding and returned as an ASCII string
INT2NUM(2)
- PASSTHRU =
Specifies that binary data shall be converted to a NULL value
INT2NUM(3)
- PARAM_FILE =
Specifies that the column should be bound directly to a file for input
INT2NUM(11)
- ATTR_CASE =
Specifies the column names case attribute ATTENTION this number is not currently in CLI but used for ibm_db purpose only
INT2NUM(ATTR_CASE)
- CASE_NATURAL =
Specifies that column names will be returned in their natural case
INT2NUM(0)
- CASE_LOWER =
Specifies that column names will be returned in lower case
INT2NUM(1)
- CASE_UPPER =
Specifies that column names will be returned in upper case
INT2NUM(2)
- SQL_ATTR_CURSOR_TYPE =
Specifies the cursor type
INT2NUM(SQL_ATTR_CURSOR_TYPE)
- SQL_CURSOR_DYNAMIC =
Cursor type that detects all changes to the result set ATTENTION Only supported when using DB2 for z/OS Version 8.1 and later.
INT2NUM(SQL_CURSOR_DYNAMIC)
- SQL_CURSOR_FORWARD_ONLY =
Cursor type that only scrolls forward. This is the default
INT2NUM(SQL_CURSOR_FORWARD_ONLY)
- SQL_CURSOR_KEYSET_DRIVEN =
Cursor type is a pure keyset cursor
INT2NUM(SQL_CURSOR_KEYSET_DRIVEN)
- SQL_SCROLL_FORWARD_ONLY =
Cursor type that only scrolls forward
INT2NUM(SQL_SCROLL_FORWARD_ONLY)
- SQL_CURSOR_STATIC =
Cursor type in which the data in the result set is static
INT2NUM(SQL_CURSOR_STATIC)
- SQL_PARAM_INPUT =
Parmater binding type of input
INT2NUM(SQL_PARAM_INPUT)
- SQL_PARAM_OUTPUT =
Parmater binding type of output
INT2NUM(SQL_PARAM_OUTPUT)
- SQL_PARAM_INPUT_OUTPUT =
Parmater binding type of input/output
INT2NUM(SQL_PARAM_INPUT_OUTPUT)
- SQL_BINARY =
Data type used to specify binary data
INT2NUM(SQL_BINARY)
- SQL_BIGINT =
Data type used to specify bigint data
INT2NUM(SQL_BIGINT)
- SQL_LONG =
Data type used to specify long data
INT2NUM(SQL_INTEGER)
- SQL_DOUBLE =
Data type used to specify double data
INT2NUM(SQL_DOUBLE)
- SQL_CHAR =
Data type used to specify char data
INT2NUM(SQL_CHAR)
- SQL_WCHAR =
INT2NUM(SQL_WCHAR)
- SQL_XML =
Data type used to specify XML data
INT2NUM(SQL_XML)
- SQL_VARCHAR =
Data type used to specify VARCHAR data
INT2NUM(SQL_VARCHAR)
- SQL_WVARCHAR =
INT2NUM(SQL_WVARCHAR)
- SQL_AUTOCOMMIT_OFF =
Operates in auto-commit mode off. The application must manually commit or rollback transactions
INT2NUM(SQL_AUTOCOMMIT_OFF)
- SQL_AUTOCOMMIT_ON =
Operates in auto-commit mode on. This is the default
INT2NUM(SQL_AUTOCOMMIT_ON)
- SQL_ATTR_AUTOCOMMIT =
Specifies whether to use auto-commit or manual commit mode
INT2NUM(SQL_ATTR_AUTOCOMMIT)
- SQL_TRUE =
Specifies whether to enable trusted context mode
INT2NUM(SQL_TRUE)
- SQL_ATTR_USE_TRUSTED_CONTEXT =
Specifies whether to enable trusted context mode
INT2NUM(SQL_ATTR_USE_TRUSTED_CONTEXT)
- SQL_ATTR_TRUSTED_CONTEXT_USERID =
Specifies whether to siwtch trusted user
INT2NUM(SQL_ATTR_TRUSTED_CONTEXT_USERID)
- SQL_ATTR_TRUSTED_CONTEXT_PASSWORD =
Specifies when trusted user is specified
INT2NUM(SQL_ATTR_TRUSTED_CONTEXT_PASSWORD)
- SQL_ATTR_INFO_USERID =
String used to identify the client user ID sent to the host database
INT2NUM(SQL_ATTR_INFO_USERID)
- SQL_ATTR_INFO_WRKSTNNAME =
String used to identify the client workstation name sent to the host database
INT2NUM(SQL_ATTR_INFO_WRKSTNNAME)
- SQL_ATTR_INFO_APPLNAME =
String used to identify the client application name sent to the host database
INT2NUM(SQL_ATTR_INFO_APPLNAME)
- SQL_ATTR_INFO_ACCTSTR =
String used to identify the client accounting string sent to the host database
INT2NUM(SQL_ATTR_INFO_ACCTSTR)
- SQL_ATTR_ROWCOUNT_PREFETCH =
Enabling Prefetching of Rowcount - Available from V95FP3 onwards
INT2NUM(SQL_ATTR_ROWCOUNT_PREFETCH)
- SQL_ROWCOUNT_PREFETCH_ON =
INT2NUM(SQL_ROWCOUNT_PREFETCH_ON)
- SQL_ROWCOUNT_PREFETCH_OFF =
INT2NUM(SQL_ROWCOUNT_PREFETCH_OFF)
- DB_CONN =
Specifies resource Type passed is Connection Handle, for retrieving error message
INT2NUM(DB_CONN)
- DB_STMT =
Specifies resource Type passed is Statement Handle, for retrieving error message
INT2NUM(DB_STMT)
- QUOTED_LITERAL_REPLACEMENT_ON =
Specifies Quoted Literal replacement connection attribute is to be set
INT2NUM(SET_QUOTED_LITERAL_REPLACEMENT_ON)
- QUOTED_LITERAL_REPLACEMENT_OFF =
Specifies Quoted Literal replacement connection attribute should not be set
INT2NUM(SET_QUOTED_LITERAL_REPLACEMENT_OFF)
- VERSION =
Specfies the version of the driver
rb_str_new2(MODULE_RELEASE)
- SQL_ATTR_DBC_LIBL =
additional conn attribute
INT2NUM(SQL_ATTR_DBC_LIBL)
- SQL_ATTR_DBC_CURLIB =
INT2NUM(SQL_ATTR_DBC_CURLIB)
- SQL_ATTR_DBC_DEFAULT_LIB =
INT2NUM(SQL_ATTR_DBC_DEFAULT_LIB)
- SQL_ATTR_DBC_SYS_NAMING =
INT2NUM(SQL_ATTR_DBC_SYS_NAMING)
- SQL_SYSTEM_NAMING_ON =
INT2NUM(SQL_TRUE)
- SQL_SYSTEM_NAMING_OFF =
INT2NUM(SQL_FALSE)
- SQL_ATTR_CONN_SORT_SEQUENCE =
INT2NUM(SQL_ATTR_CONN_SORT_SEQUENCE)
- SQL_JOB_SORT_ON =
INT2NUM(SQL_JOBRUN_SORT_SEQUENCE)
- SQL_JOB_SORT_OFF =
INT2NUM(SQL_HEX_SORT_SEQUENCE)
- SQL_ATTR_TXN_ISOLATION =
INT2NUM(SQL_ATTR_TXN_ISOLATION)
- SQL_TXN_ISOLATION =
INT2NUM(SQL_ATTR_TXN_ISOLATION)
- SQL_TXN_NO_COMMIT =
INT2NUM(SQL_TXN_NO_COMMIT)
- SQL_COMMIT_NONE =
INT2NUM(SQL_TXN_NO_COMMIT)
- SQL_TXN_NOCOMMIT =
INT2NUM(SQL_TXN_NO_COMMIT)
- SQL_TXN_READ_UNCOMMITTED =
INT2NUM(SQL_TXN_READ_UNCOMMITTED)
- SQL_COMMIT_CHG =
INT2NUM(SQL_TXN_READ_UNCOMMITTED)
- SQL_COMMIT_UR =
INT2NUM(SQL_TXN_READ_UNCOMMITTED)
- SQL_TXN_READ_COMMITTED =
INT2NUM(SQL_TXN_READ_COMMITTED)
- SQL_COMMIT_CS =
INT2NUM(SQL_TXN_READ_COMMITTED)
- SQL_TXN_REPEATABLE_READ =
INT2NUM(SQL_TXN_REPEATABLE_READ)
- SQL_COMMIT_ALL =
INT2NUM(SQL_TXN_REPEATABLE_READ)
- SQL_COMMIT_RS =
INT2NUM(SQL_TXN_REPEATABLE_READ)
- SQL_TXN_SERIALIZABLE =
INT2NUM(SQL_TXN_SERIALIZABLE)
- SQL_COMMIT_RR =
INT2NUM(SQL_TXN_SERIALIZABLE)
- SQL_ATTR_DATE_FMT =
INT2NUM(SQL_ATTR_DATE_FMT)
- SQL_ATTR_TIME_FMT =
INT2NUM(SQL_ATTR_TIME_FMT)
- SQL_FMT_ISO =
INT2NUM(SQL_FMT_ISO)
- SQL_FMT_USA =
INT2NUM(SQL_FMT_USA)
- SQL_FMT_EUR =
INT2NUM(SQL_FMT_EUR)
- SQL_FMT_JIS =
INT2NUM(SQL_FMT_JIS)
- SQL_FMT_DMY =
INT2NUM(SQL_FMT_DMY)
- SQL_FMT_MDY =
INT2NUM(SQL_FMT_MDY)
- SQL_FMT_YMD =
INT2NUM(SQL_FMT_YMD)
- SQL_FMT_JUL =
INT2NUM(SQL_FMT_JUL)
- SQL_FMT_JOB =
INT2NUM(SQL_FMT_JOB)
- SQL_FMT_HMS =
INT2NUM(SQL_FMT_HMS)
- SQL_IBMi_FMT_ISO =
INT2NUM(SQL_IBMi_FMT_ISO)
- SQL_IBMi_FMT_USA =
INT2NUM(SQL_IBMi_FMT_USA)
- SQL_IBMi_FMT_EUR =
INT2NUM(SQL_IBMi_FMT_EUR)
- SQL_IBMi_FMT_JIS =
INT2NUM(SQL_IBMi_FMT_JIS)
- SQL_IBMi_FMT_DMY =
INT2NUM(SQL_IBMi_FMT_DMY)
- SQL_IBMi_FMT_MDY =
INT2NUM(SQL_IBMi_FMT_MDY)
- SQL_IBMi_FMT_YMD =
INT2NUM(SQL_IBMi_FMT_YMD)
- SQL_IBMi_FMT_JUL =
INT2NUM(SQL_IBMi_FMT_JUL)
- SQL_IBMi_FMT_JOB =
INT2NUM(SQL_IBMi_FMT_JOB)
- SQL_IBMi_FMT_HMS =
INT2NUM(SQL_IBMi_FMT_HMS)
- SQL_ATTR_DATE_SEP =
INT2NUM(SQL_ATTR_DATE_SEP)
- SQL_ATTR_TIME_SEP =
INT2NUM(SQL_ATTR_TIME_SEP)
- SQL_ATTR_DECIMAL_SEP =
INT2NUM(SQL_ATTR_DECIMAL_SEP)
- SQL_SEP_SLASH =
INT2NUM(SQL_SEP_SLASH)
- SQL_SEP_DASH =
INT2NUM(SQL_SEP_DASH)
- SQL_SEP_PERIOD =
INT2NUM(SQL_SEP_PERIOD)
- SQL_SEP_COMMA =
INT2NUM(SQL_SEP_COMMA)
- SQL_SEP_BLANK =
INT2NUM(SQL_SEP_BLANK)
- SQL_SEP_JOB =
INT2NUM(SQL_SEP_JOB)
- SQL_SEP_COLON =
INT2NUM(SQL_SEP_COLON)
- SQL_ATTR_QUERY_OPTIMIZE_GOAL =
INT2NUM(SQL_ATTR_QUERY_OPTIMIZE_GOAL)
- SQL_FIRST_IO =
INT2NUM(SQL_FIRST_IO)
- SQL_ALL_IO =
INT2NUM(SQL_ALL_IO)
- SQL_ATTR_CURSOR_SCROLLABLE =
additional stmt attribute
INT2NUM(SQL_ATTR_CURSOR_SCROLLABLE)
- SQL_CURSOR_SCROLLABLE_OFF =
INT2NUM(SQL_FALSE)
- SQL_CURSOR_SCROLLABLE_ON =
INT2NUM(SQL_TRUE)
- SQL_ATTR_FOR_FETCH_ONLY =
INT2NUM(SQL_ATTR_FOR_FETCH_ONLY)
- SQL_FETCH_ON =
INT2NUM(SQL_TRUE)
- SQL_FETCH_OFF =
INT2NUM(SQL_FALSE)
- SQL_CURSOR_TYPE =
INT2NUM(SQL_ATTR_CURSOR_TYPE)
- SQL_ATTR_CURSOR_SENSITIVITY =
SQL_CURSOR_FORWARD_ONLY (default) SQL_CURSOR_STATIC SQL_CURSOR_DYNAMIC SQL_CURSOR_KEYSET_DRIVEN
INT2NUM(SQL_ATTR_CURSOR_SENSITIVITY)
- SQL_CURSOR_SENSITIVE =
INT2NUM(SQL_ATTR_CURSOR_SENSITIVITY)
- SQL_UNSPECIFIED =
INT2NUM(SQL_UNSPECIFIED)
- SQL_INSENSITIVE =
INT2NUM(SQL_INSENSITIVE)
- SQL_SENSITIVE =
INT2NUM(SQL_SENSITIVE)
- SQL_ATTR_CONCURRENCY =
INT2NUM(SQL_ATTR_CONCURRENCY)
- SQL_CONCURRENCY =
INT2NUM(SQL_ATTR_CONCURRENCY)
- SQL_CONCUR_LOCK =
INT2NUM(SQL_CONCUR_LOCK)
- SQL_CONCUR_READ_ONLY =
INT2NUM(SQL_CONCUR_READ_ONLY)
- SQL_CONCUR_DEFAULT =
INT2NUM(SQL_CONCUR_READ_ONLY)
- SQL_CONCUR_ROWVER =
INT2NUM(SQL_CONCUR_ROWVER)
- SQL_CONCUR_VALUES =
INT2NUM(SQL_CONCUR_VALUES)
Class Method Summary collapse
- .active ⇒ Object
- .autocommit ⇒ Object
- .bind_param ⇒ Object
- .client_info ⇒ Object
- .close ⇒ Object
- .column_privileges ⇒ Object
- .columnprivileges ⇒ Object
- .columns ⇒ Object
- .commit ⇒ Object
- .conn_error ⇒ Object
- .conn_errormsg ⇒ Object
- .connect ⇒ Object
- .createDB ⇒ Object
- .createDBNX ⇒ Object
- .cursor_type ⇒ Object
- .dropDB ⇒ Object
- .exec ⇒ Object
- .execute ⇒ Object
- .fetch_array ⇒ Object
- .fetch_assoc ⇒ Object
- .fetch_both ⇒ Object
- .fetch_object ⇒ Object
- .fetch_row ⇒ Object
- .field_display_size ⇒ Object
- .field_name ⇒ Object
- .field_num ⇒ Object
- .field_precision ⇒ Object
- .field_scale ⇒ Object
- .field_type ⇒ Object
- .field_width ⇒ Object
- .foreign_keys ⇒ Object
- .foreignkeys ⇒ Object
- .free_result ⇒ Object
- .free_stmt ⇒ Object
- .get_last_serial_value ⇒ Object
- .get_option ⇒ Object
- .getErrormsg ⇒ Object
- .getErrorstate ⇒ Object
- .getoption ⇒ Object
- .next_result ⇒ Object
- .num_fields ⇒ Object
- .num_rows ⇒ Object
- .pconnect ⇒ Object
- .prepare ⇒ Object
- .primary_keys ⇒ Object
- .primarykeys ⇒ Object
- .procedure_columns ⇒ Object
- .procedurecolumns ⇒ Object
- .procedures ⇒ Object
- .result ⇒ Object
- .resultCols ⇒ Object
- .rollback ⇒ Object
- .server_info ⇒ Object
- .set_option ⇒ Object
- .setoption ⇒ Object
- .special_columns ⇒ Object
- .specialcolumns ⇒ Object
- .statistics ⇒ Object
- .stmt_error ⇒ Object
- .stmt_errormsg ⇒ Object
- .table_privileges ⇒ Object
- .tableprivileges ⇒ Object
- .tables ⇒ Object
- .trace ⇒ Object
- .trace_clear ⇒ Object
- .trace_exclude ⇒ Object
- .trace_include ⇒ Object