IBM DB2 Functions

Table of Contents

• 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 ins 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