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)

Class Method Summary collapse

Class Method Details

.activeObject

.autocommitObject

.bind_paramObject

.client_infoObject

.closeObject

.column_privilegesObject

.columnprivilegesObject

.columnsObject

.commitObject

.conn_errorObject

.conn_errormsgObject

.connectObject

.createDBObject

.createDBNXObject

.cursor_typeObject

.dropDBObject

.execObject

.executeObject

.fetch_arrayObject

.fetch_assocObject

.fetch_bothObject

.fetch_objectObject

.fetch_rowObject

.field_display_sizeObject

.field_nameObject

.field_numObject

.field_precisionObject

.field_scaleObject

.field_typeObject

.field_widthObject

.foreign_keysObject

.foreignkeysObject

.free_resultObject

.free_stmtObject

.get_last_serial_valueObject

.get_optionObject

.getErrormsgObject

.getErrorstateObject

.getoptionObject

.next_resultObject

.num_fieldsObject

.num_rowsObject

.pconnectObject

.prepareObject

.primary_keysObject

.primarykeysObject

.procedure_columnsObject

.procedurecolumnsObject

.proceduresObject

.resultObject

.resultColsObject

.rollbackObject

.server_infoObject

.set_optionObject

.setoptionObject

.special_columnsObject

.specialcolumnsObject

.statisticsObject

.stmt_errorObject

.stmt_errormsgObject

.table_privilegesObject

.tableprivilegesObject

.tablesObject