IBM DB2, Cloudscape and Apache Derby
- Introduction
- Installing/Configuring
- Predefined Constants
- IBM DB2 Functions
- db2_autocommit â Returns or sets the AUTOCOMMIT state for a database connection
- db2_bind_param â Binds a PHP variable to an SQL statement parameter
- db2_client_info â Returns an object with properties that describe the DB2 database client
- db2_close â Closes a database connection
- db2_column_privileges â Returns a result set listing the columns and associated privileges for a table
- db2_columns â Returns a result set listing the columns and associated metadata for a table
- db2_commit â Commits a transaction
- db2_conn_error â Returns a string containing the SQLSTATE returned by the last connection attempt
- db2_conn_errormsg â Returns the last connection error message and SQLCODE value
- db2_connect â Returns a connection to a database
- db2_cursor_type â Returns the cursor type used by a statement resource
- db2_escape_string â Used to escape certain characters
- db2_exec â Executes an SQL statement directly
- db2_execute â Executes a prepared SQL statement
- db2_fetch_array â Returns an array, indexed by column position, representing a row in a result set
- db2_fetch_assoc â Returns an array, indexed by column name, representing a row in a result set
- db2_fetch_both â Returns an array, indexed by both column name and position, representing a row in a result set
- db2_fetch_object â Returns an object with properties representing columns in the fetched row
- db2_fetch_row â Sets the result set pointer to the next row or requested row
- db2_field_display_size â Returns the maximum number of bytes required to display a column
- db2_field_name â Returns the name of the column in the result set
- db2_field_num â Returns the position of the named column in a result set
- db2_field_precision â Returns the precision of the indicated column in a result set
- db2_field_scale â Returns the scale of the indicated column in a result set
- db2_field_type â Returns the data type of the indicated column in a result set
- db2_field_width â Returns the width of the current value of the indicated column in a result set
- db2_foreign_keys â Returns a result set listing the foreign keys for a table
- db2_free_result â Frees resources associated with a result set
- db2_free_stmt â Frees resources associated with the indicated statement resource
- db2_get_option â Retrieves an option value for a statement resource or a connection resource
- db2_last_insert_id â Returns the auto generated ID of the last insert query that successfully
executed on this connection
- db2_lob_read â Gets a user defined size of LOB files with each invocation
- db2_next_result â Requests the next result set from a stored procedure
- db2_num_fields â Returns the number of fields contained in a result set
- db2_num_rows â Returns the number of rows affected by an SQL statement
- db2_pclose â Closes a persistent database connection
- db2_pconnect â Returns a persistent connection to a database
- db2_prepare â Prepares an SQL statement to be executed
- db2_primary_keys â Returns a result set listing primary keys for a table
- db2_procedure_columns â Returns a result set listing stored procedure parameters
- db2_procedures â Returns a result set listing the stored procedures registered in a database
- db2_result â Returns a single column from a row in the result set
- db2_rollback â Rolls back a transaction
- db2_server_info â Returns an object with properties that describe the DB2 database server
- db2_set_option â Set options for connection or statement resources
- db2_special_columns â Returns a result set listing the unique row identifier columns for a table
- db2_statistics â Returns a result set listing the index and statistics for a table
- db2_stmt_error â Returns a string containing the SQLSTATE returned by an SQL statement
- db2_stmt_errormsg â Returns a string containing the last SQL statement error message
- db2_table_privileges â Returns a result set listing the tables and associated privileges in a database
- db2_tables â Returns a result set listing the tables and associated metadata in a database
There are no user contributed notes for this page.