Class Zend_Db_Statement_Db2

Description

Extends for DB2 native adapter.

Located in /Db/Statement/Db2.php (line 36)

Zend_Db_Statement
   |
   --Zend_Db_Statement_Db2
Variable Summary
 mixed $_keys
 mixed $_stmt
 mixed $_values
Method Summary
 bool bindParam (mixed $parameter,  &$variable, [mixed $type = null], [mixed $length = null], [mixed $options = null], mixed $variable)
 bool closeCursor ()
 int columnCount ()
 string errorCode ()
 array errorInfo ()
 bool execute ([ $params = array()])
 mixed fetch ([int $style = null], [int $cursor = null], [int $offset = null])
 array fetchAll ([int $style = null], [int $col = null])
 mixed fetchObject ([string $class = 'stdClass'], [ $config = array()])
 bool nextRowset ()
 int rowCount ()
 void _prepSql (string $sql)
Variables
mixed $_keys (line 46)

Column names.

  • access: protected
mixed $_stmt = null (line 41)

Statement resource handle.

  • access: protected
mixed $_values (line 51)

Fetched result values.

  • access: protected

Inherited Variables

Inherited from Zend_Db_Statement

Zend_Db_Statement::$_adapter
Zend_Db_Statement::$_attribute
Zend_Db_Statement::$_bindColumn
Zend_Db_Statement::$_bindParam
Zend_Db_Statement::$_fetchMode
Zend_Db_Statement::$_sqlParam
Zend_Db_Statement::$_sqlSplit
Methods
bindParam (line 87)

Binds a parameter to the specified variable name.

  • throws: Zend_Db_Statement_Db2_Exception
  • access: public
bool bindParam (mixed $parameter,  &$variable, [mixed $type = null], [mixed $length = null], [mixed $options = null], mixed $variable)
  • mixed $parameter: Name the parameter, either integer or string.
  • mixed $variable: Reference to PHP variable containing the value.
  • mixed $type: OPTIONAL Datatype of SQL parameter.
  • mixed $length: OPTIONAL Length of SQL parameter.
  • mixed $options: OPTIONAL Other options.
  • &$variable

Redefinition of:
Zend_Db_Statement::bindParam()
Binds a parameter to the specified variable name.
closeCursor (line 117)

Closes the cursor, allowing the statement to be executed again.

  • access: public
bool closeCursor ()
columnCount (line 134)

Returns the number of columns in the result set.

Returns null if the statement has no result set metadata.

  • return: The number of columns.
  • access: public
int columnCount ()
errorCode (line 148)

Retrieves the error code, if any, associated with the last operation on the statement handle.

  • return: error code.
  • access: public
string errorCode ()
errorInfo (line 163)

Retrieves an array of error information, if any, associated with the last operation on the statement handle.

  • access: public
array errorInfo ()
execute (line 187)

Executes a prepared statement.

  • throws: Zend_Db_Statement_Db2_Exception
  • access: public
bool execute ([ $params = array()])
  • array $params: OPTIONAL Values to bind to parameter placeholders.
fetch (line 236)

Fetches a row from the result set.

  • return: Array, object, or scalar depending on fetch mode.
  • throws: Zend_Db_Statement_Db2_Exception
  • access: public
mixed fetch ([int $style = null], [int $cursor = null], [int $offset = null])
  • int $style: OPTIONAL Fetch mode for this fetch operation.
  • int $cursor: OPTIONAL Absolute, relative, or other.
  • int $offset: OPTIONAL Number for absolute or relative cursors.
fetchAll (line 333)

Returns an array containing all of the result set rows.

  • return: Collection of rows, each in a format by the fetch mode.
  • throws:

    Zend_Db_Statement_Exception

    Behaves like parent, but if limit() is used, the final result removes the extra column 'zend_db_rownum'

  • access: public
array fetchAll ([int $style = null], [int $col = null])
  • int $style: OPTIONAL Fetch mode.
  • int $col: OPTIONAL Column number, if fetch mode is by column.

Redefinition of:
Zend_Db_Statement::fetchAll()
Returns an array containing all of the result set rows.
fetchObject (line 276)

Fetches the next row and returns it as an object.

  • return: One object instance of the specified class.
  • access: public
mixed fetchObject ([string $class = 'stdClass'], [ $config = array()])
  • string $class: OPTIONAL Name of the class to create.
  • array $config: OPTIONAL Constructor arguments for the class.

Redefinition of:
Zend_Db_Statement::fetchObject()
Fetches the next row and returns it as an object.
nextRowset (line 290)

Retrieves the next rowset (result set) for a SQL statement that has multiple result sets. An example is a stored procedure that returns the results of multiple queries.

  • throws: Zend_Db_Statement_Db2_Exception
  • access: public
bool nextRowset ()
rowCount (line 306)

Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.

  • return: The number of rows affected.
  • access: public
int rowCount ()
_prepSql (line 60)

Prepare a statement handle.

  • throws: Zend_Db_Statement_Db2_Exception
  • access: public
void _prepSql (string $sql)
  • string $sql

Redefinition of:
Zend_Db_Statement::_prepSql()
Splits SQL into text and params, sets up $this->_bindParam for replacements.

Inherited Methods

Inherited From Zend_Db_Statement

 Zend_Db_Statement::__construct()
 Zend_Db_Statement::bindColumn()
 Zend_Db_Statement::bindParam()
 Zend_Db_Statement::bindValue()
 Zend_Db_Statement::fetchAll()
 Zend_Db_Statement::fetchColumn()
 Zend_Db_Statement::fetchObject()
 Zend_Db_Statement::getAttribute()
 Zend_Db_Statement::setAttribute()
 Zend_Db_Statement::setFetchMode()
 Zend_Db_Statement::_joinSql()
 Zend_Db_Statement::_normalizeBindParam()
 Zend_Db_Statement::_prepSql()

Documentation generated on Sun, 27 May 2007 23:22:19 -0700 by phpDocumentor 1.3.2