Inheritance diagram for Zend_Db_Adapter_Db2:

Public Member Functions
	isConnected ()

	closeConnection ()

	prepare ($sql)

	_getExecuteMode ()

	_setExecuteMode ($mode)

	getQuoteIdentifierSymbol ()

	listTables ($schema=null)

	describeTable ($tableName, $schemaName=null)

	lastSequenceId ($sequenceName)

	nextSequenceId ($sequenceName)

	lastInsertId ($tableName=null, $primaryKey=null, $idType=null)

	setFetchMode ($mode)

	limit ($sql, $count, $offset=0)

	supportsParameters ($type)

	getServerVersion ()

	isI5 ()

Public Member Functions inherited from Zend_Db_Adapter_Abstract
	__construct ($config)

	getConnection ()

	getConfig ()

	setProfiler ($profiler)

	getProfiler ()

	getStatementClass ()

	setStatementClass ($class)

	query ($sql, $bind=array())

	beginTransaction ()

	commit ()

	rollBack ()

	insert ($table, array $bind)

	update ($table, array $bind, $where='')

	delete ($table, $where='')

	select ()

	getFetchMode ()

	fetchAll ($sql, $bind=array(), $fetchMode=null)

	fetchRow ($sql, $bind=array(), $fetchMode=null)

	fetchAssoc ($sql, $bind=array())

	fetchCol ($sql, $bind=array())

	fetchPairs ($sql, $bind=array())

	fetchOne ($sql, $bind=array())

	quote ($value, $type=null)

	quoteInto ($text, $value, $type=null, $count=null)

	quoteIdentifier ($ident, $auto=false)

	quoteColumnAs ($ident, $alias, $auto=false)

	quoteTableAs ($ident, $alias=null, $auto=false)

	getQuoteIdentifierSymbol ()

	lastSequenceId ($sequenceName)

	nextSequenceId ($sequenceName)

	foldCase ($key)

	__sleep ()

	__wakeup ()

	listTables ()

	describeTable ($tableName, $schemaName=null)

	isConnected ()

	closeConnection ()

	prepare ($sql)

	lastInsertId ($tableName=null, $primaryKey=null)

	setFetchMode ($mode)

	limit ($sql, $count, $offset=0)

	supportsParameters ($type)

	getServerVersion ()

Protected Member Functions
	_connect ()

	_quote ($value)

	_beginTransaction ()

	_commit ()

	_rollBack ()

	_determineI5 ()

	_i5listTables ($schema=null)

	_i5LastInsertId ($objectName=null, $idType=null)

Protected Member Functions inherited from Zend_Db_Adapter_Abstract
	_checkRequiredOptions (array $config)

	_whereExpr ($where)

	_quote ($value)

	_quoteIdentifierAs ($ident, $alias=null, $auto=false, $as=' AS ')

	_quoteIdentifier ($value, $auto=false)

	_connect ()

	_beginTransaction ()

	_commit ()

	_rollBack ()

Protected Attributes
	$_config

	$_execute_mode = DB2_AUTOCOMMIT_ON

	$_defaultStmtClass = 'Zend_Db_Statement_Db2'

	$_isI5 = false

	$_numericDataTypes

Protected Attributes inherited from Zend_Db_Adapter_Abstract
	$_config = array()

	$_fetchMode = Zend_Db::FETCH_ASSOC

	$_profiler

	$_defaultStmtClass = 'Zend_Db_Statement'

	$_defaultProfilerClass = 'Zend_Db_Profiler'

	$_connection = null

	$_caseFolding = Zend_Db::CASE_NATURAL

	$_autoQuoteIdentifiers = true

	$_numericDataTypes

	$_allowSerialization = true

	$_autoReconnectOnUnserialize = false

Detailed Description

Definition at line 46 of file Db2.php.

Member Function Documentation

◆ _beginTransaction()

_beginTransaction ( )

protected

Begin a transaction.

Returns: void

Definition at line 578 of file Db2.php.

     {
         $this->_setExecuteMode(DB2_AUTOCOMMIT_OFF);
     }

◆ _commit()

_commit ( )

protected

Commit a transaction.

Returns: void

See also: Zend_Db_Adapter_Db2_Exception

Definition at line 588 of file Db2.php.

     {
         if (!db2_commit($this->_connection)) {
             #require_once 'Zend/Db/Adapter/Db2/Exception.php';
             throw new Zend_Db_Adapter_Db2_Exception(
                 db2_conn_errormsg($this->_connection),
                 db2_conn_error($this->_connection));
         }
 
         $this->_setExecuteMode(DB2_AUTOCOMMIT_ON);
     }

◆ _connect()

_connect ( )

protected

Creates a connection resource.

Returns: void

See also: Zend_Db_Adapter_Db2_Exception; Zend_Db_Adapter_Db2_Exception

Definition at line 119 of file Db2.php.

     {
         if (is_resource($this->_connection)) {
             // connection already exists
             return;
         }
 
         if (!extension_loaded('ibm_db2')) {
             #require_once 'Zend/Db/Adapter/Db2/Exception.php';
             throw new Zend_Db_Adapter_Db2_Exception('The IBM DB2 extension is required for this adapter but the extension is not loaded');
         }
 
         $this->_determineI5();
         if ($this->_config['persistent']) {
             // use persistent connection
             $conn_func_name = 'db2_pconnect';
         } else {
             // use "normal" connection
             $conn_func_name = 'db2_connect';
         }
 
         if (!isset($this->_config['driver_options']['autocommit'])) {
             // set execution mode
             $this->_config['driver_options']['autocommit'] = &$this->_execute_mode;
         }
 
         if (isset($this->_config['options'][Zend_Db::CASE_FOLDING])) {
             $caseAttrMap = array(
                 Zend_Db::CASE_NATURAL => DB2_CASE_NATURAL,
                 Zend_Db::CASE_UPPER   => DB2_CASE_UPPER,
                 Zend_Db::CASE_LOWER   => DB2_CASE_LOWER
             );
             $this->_config['driver_options']['DB2_ATTR_CASE'] = $caseAttrMap[$this->_config['options'][Zend_Db::CASE_FOLDING]];
         }
 
         if ($this->_isI5 && isset($this->_config['driver_options']['i5_naming'])) {
             if ($this->_config['driver_options']['i5_naming']) {
                 $this->_config['driver_options']['i5_naming'] = DB2_I5_NAMING_ON;
             } else {
                 $this->_config['driver_options']['i5_naming'] = DB2_I5_NAMING_OFF;
             }
         }
 
         if ($this->_config['host'] !== 'localhost' && !$this->_isI5) {
             // if the host isn't localhost, use extended connection params
             $dbname = 'DRIVER={IBM DB2 ODBC DRIVER}' .
                      ';DATABASE=' . $this->_config['dbname'] .
                      ';HOSTNAME=' . $this->_config['host'] .
                      ';PORT='     . $this->_config['port'] .
                      ';PROTOCOL=' . $this->_config['protocol'] .
                      ';UID='      . $this->_config['username'] .
                      ';PWD='      . $this->_config['password'] .';';
             $this->_connection = $conn_func_name(
                 $dbname,
                 null,
                 null,
                 $this->_config['driver_options']
             );
         } else {
             // host is localhost, so use standard connection params
             $this->_connection = $conn_func_name(
                 $this->_config['dbname'],
                 $this->_config['username'],
                 $this->_config['password'],
                 $this->_config['driver_options']
             );
         }
 
         // check the connection
         if (!$this->_connection) {
             #require_once 'Zend/Db/Adapter/Db2/Exception.php';
             throw new Zend_Db_Adapter_Db2_Exception(db2_conn_errormsg(), db2_conn_error());
         }
     }

◆ _determineI5()

_determineI5 ( )

protected

Check the connection parameters according to verify type of used OS

Returns: void

Definition at line 761 of file Db2.php.

     {
         // first us the compiled flag.
         $this->_isI5 = (php_uname('s') == 'OS400') ? true : false;
 
         // if this is set, then us it
         if (isset($this->_config['os'])){
             if (strtolower($this->_config['os']) === 'i5') {
                 $this->_isI5 = true;
             } else {
                 // any other value passed in, its null
                 $this->_isI5 = false;
             }
         }
 
     }

◆ _getExecuteMode()

_getExecuteMode ( )

Gets the execution mode

Returns: int the execution mode (DB2_AUTOCOMMIT_ON or DB2_AUTOCOMMIT_OFF)

Definition at line 248 of file Db2.php.

     {
         return $this->_execute_mode;
     }

◆ _i5LastInsertId()

_i5LastInsertId	(	$objectName = `null`,
		$idType = `null`
	)

protected

Definition at line 817 of file Db2.php.

     {
 
         if ($objectName === null) {
             $sql = 'SELECT IDENTITY_VAL_LOCAL() AS VAL FROM QSYS2.QSQPTABL';
             $value = $this->fetchOne($sql);
             return $value;
         }
 
         if (strtoupper($idType) === 'S'){
             //check i5_lib option
             $sequenceName = $objectName;
             return $this->lastSequenceId($sequenceName);
         }
 
             //returns last identity value for the specified table
         //if (strtoupper($idType) === 'I') {
         $tableName = $objectName;
         return $this->fetchOne('SELECT IDENTITY_VAL_LOCAL() from ' . $this->quoteIdentifier($tableName));
     }

◆ _i5listTables()

_i5listTables ( $schema = null )

protected

Db2 On I5 specific method

Returns a list of the tables in the database . Used only for DB2/400.

Returns: array

Definition at line 786 of file Db2.php.

     {
         //list of i5 libraries.
         $tables = array();
         if ($schema) {
             $tablesStatement = db2_tables($this->_connection, null, $schema);
             while ($rowTables = db2_fetch_assoc($tablesStatement) ) {
                 if ($rowTables['TABLE_NAME'] !== null) {
                     $tables[] = $rowTables['TABLE_NAME'];
                 }
             }
         } else {
             $schemaStatement = db2_tables($this->_connection);
             while ($schema = db2_fetch_assoc($schemaStatement)) {
                 if ($schema['TABLE_SCHEM'] !== null) {
                     // list of the tables which belongs to the selected library
                     $tablesStatement = db2_tables($this->_connection, NULL, $schema['TABLE_SCHEM']);
                     if (is_resource($tablesStatement)) {
                         while ($rowTables = db2_fetch_assoc($tablesStatement) ) {
                             if ($rowTables['TABLE_NAME'] !== null) {
                                 $tables[] = $rowTables['TABLE_NAME'];
                             }
                         }
                     }
                 }
             }
         }
 
         return $tables;
     }

◆ _quote()

_quote ( $value )

protected

Quote a raw string.

Parameters

string $value Raw string

Returns: string Quoted string

Use db2_escape_string() if it is present in the IBM DB2 extension. But some supported versions of PHP do not include this function, so fall back to default quoting in the parent class.

Definition at line 281 of file Db2.php.

     {
         if (is_int($value) || is_float($value)) {
             return $value;
         }
         if (function_exists('db2_escape_string')) {
             return "'" . db2_escape_string($value) . "'";
         }
         return parent::_quote($value);
     }

◆ _rollBack()

_rollBack ( )

protected

Rollback a transaction.

Returns: void

See also: Zend_Db_Adapter_Db2_Exception

Definition at line 608 of file Db2.php.

     {
         if (!db2_rollback($this->_connection)) {
             #require_once 'Zend/Db/Adapter/Db2/Exception.php';
             throw new Zend_Db_Adapter_Db2_Exception(
                 db2_conn_errormsg($this->_connection),
                 db2_conn_error($this->_connection));
         }
         $this->_setExecuteMode(DB2_AUTOCOMMIT_ON);
     }

◆ _setExecuteMode()

_setExecuteMode ( $mode )

Parameters

integer $mode

Returns: void

See also: Zend_Db_Adapter_Db2_Exception

Definition at line 257 of file Db2.php.

     {
         switch ($mode) {
             case DB2_AUTOCOMMIT_OFF:
             case DB2_AUTOCOMMIT_ON:
                 $this->_execute_mode = $mode;
                 db2_autocommit($this->_connection, $mode);
                 break;
             default:
                 #require_once 'Zend/Db/Adapter/Db2/Exception.php';
                 throw new Zend_Db_Adapter_Db2_Exception("execution mode not supported");
                 break;
         }
     }

◆ closeConnection()

closeConnection ( )

Force the connection to close.

Returns: void

Definition at line 216 of file Db2.php.

     {
         if ($this->isConnected()) {
             db2_close($this->_connection);
         }
         $this->_connection = null;
     }

◆ describeTable()

describeTable	(	$tableName,
		$schemaName = `null`
	)

Returns the column descriptions for a table.

The return value is an associative array keyed by the column name, as returned by the RDBMS.

The value of each array element is an associative array with the following keys:

SCHEMA_NAME => string; name of database or schema TABLE_NAME => string; COLUMN_NAME => string; column name COLUMN_POSITION => number; ordinal position of column in table DATA_TYPE => string; SQL datatype name of column DEFAULT => string; default expression of column, null if none NULLABLE => boolean; true if column can have nulls LENGTH => number; length of CHAR/VARCHAR SCALE => number; scale of NUMERIC/DECIMAL PRECISION => number; precision of NUMERIC/DECIMAL UNSIGNED => boolean; unsigned property of an integer type DB2 not supports UNSIGNED integer. PRIMARY => boolean; true if column is part of the primary key PRIMARY_POSITION => integer; position of column in primary key IDENTITY => integer; true if column is auto-generated with unique values

Parameters

string	$tableName
string	$schemaName	OPTIONAL

Returns: array

To avoid case issues, fetch using FETCH_NUM

The ordering of columns is defined by the query so we can map to variables to improve readability

In IBM DB2, an column can be IDENTITY even if it is not part of the PRIMARY KEY.

Definition at line 376 of file Db2.php.

     {
         // Ensure the connection is made so that _isI5 is set
         $this->_connect();
 
         if ($schemaName === null && $this->_config['schema'] != null) {
             $schemaName = $this->_config['schema'];
         }
 
         if (!$this->_isI5) {
 
             $sql = "SELECT DISTINCT c.tabschema, c.tabname, c.colname, c.colno,
                 c.typename, c.default, c.nulls, c.length, c.scale,
                 c.identity, tc.type AS tabconsttype, k.colseq
                 FROM syscat.columns c
                 LEFT JOIN (syscat.keycoluse k JOIN syscat.tabconst tc
                 ON (k.tabschema = tc.tabschema
                     AND k.tabname = tc.tabname
                     AND tc.type = 'P'))
                 ON (c.tabschema = k.tabschema
                     AND c.tabname = k.tabname
                     AND c.colname = k.colname)
                 WHERE "
                 . $this->quoteInto('UPPER(c.tabname) = UPPER(?)', $tableName);
 
             if ($schemaName) {
                $sql .= $this->quoteInto(' AND UPPER(c.tabschema) = UPPER(?)', $schemaName);
             }
 
             $sql .= " ORDER BY c.colno";
 
         } else {
 
             // DB2 On I5 specific query
             $sql = "SELECT DISTINCT C.TABLE_SCHEMA, C.TABLE_NAME, C.COLUMN_NAME, C.ORDINAL_POSITION,
                 C.DATA_TYPE, C.COLUMN_DEFAULT, C.NULLS ,C.LENGTH, C.SCALE, LEFT(C.IDENTITY,1),
                 LEFT(tc.TYPE, 1) AS tabconsttype, k.COLSEQ
                 FROM QSYS2.SYSCOLUMNS C
                 LEFT JOIN (QSYS2.syskeycst k JOIN QSYS2.SYSCST tc
                     ON (k.TABLE_SCHEMA = tc.TABLE_SCHEMA
                       AND k.TABLE_NAME = tc.TABLE_NAME
                       AND LEFT(tc.type,1) = 'P'))
                     ON (C.TABLE_SCHEMA = k.TABLE_SCHEMA
                        AND C.TABLE_NAME = k.TABLE_NAME
                        AND C.COLUMN_NAME = k.COLUMN_NAME)
                 WHERE "
                 . $this->quoteInto('UPPER(C.TABLE_NAME) = UPPER(?)', $tableName);
 
             if ($schemaName) {
                 $sql .= $this->quoteInto(' AND UPPER(C.TABLE_SCHEMA) = UPPER(?)', $schemaName);
             }
 
             $sql .= " ORDER BY C.ORDINAL_POSITION FOR FETCH ONLY";
         }
 
         $desc = array();
         $stmt = $this->query($sql);
 
         $result = $stmt->fetchAll(Zend_Db::FETCH_NUM);
 
         $tabschema      = 0;
         $tabname        = 1;
         $colname        = 2;
         $colno          = 3;
         $typename       = 4;
         $default        = 5;
         $nulls          = 6;
         $length         = 7;
         $scale          = 8;
         $identityCol    = 9;
         $tabconstType   = 10;
         $colseq         = 11;
 
         foreach ($result as $key => $row) {
             list ($primary, $primaryPosition, $identity) = array(false, null, false);
             if ($row[$tabconstType] == 'P') {
                 $primary = true;
                 $primaryPosition = $row[$colseq];
             }
             if ($row[$identityCol] == 'Y') {
                 $identity = true;
             }
 
             // only colname needs to be case adjusted
             $desc[$this->foldCase($row[$colname])] = array(
                 'SCHEMA_NAME'      => $this->foldCase($row[$tabschema]),
                 'TABLE_NAME'       => $this->foldCase($row[$tabname]),
                 'COLUMN_NAME'      => $this->foldCase($row[$colname]),
                 'COLUMN_POSITION'  => (!$this->_isI5) ? $row[$colno]+1 : $row[$colno],
                 'DATA_TYPE'        => $row[$typename],
                 'DEFAULT'          => $row[$default],
                 'NULLABLE'         => (bool) ($row[$nulls] == 'Y'),
                 'LENGTH'           => $row[$length],
                 'SCALE'            => $row[$scale],
                 'PRECISION'        => ($row[$typename] == 'DECIMAL' ? $row[$length] : 0),
                 'UNSIGNED'         => false,
                 'PRIMARY'          => $primary,
                 'PRIMARY_POSITION' => $primaryPosition,
                 'IDENTITY'         => $identity
             );
         }
 
         return $desc;
     }

◆ getQuoteIdentifierSymbol()

getQuoteIdentifierSymbol ( )

Returns: string

Definition at line 300 of file Db2.php.

     {
         $this->_connect();
         $info = db2_server_info($this->_connection);
         if ($info) {
             $identQuote = $info->IDENTIFIER_QUOTE_CHAR;
         } else {
             // db2_server_info() does not return result on some i5 OS version
             if ($this->_isI5) {
                 $identQuote ="'";
             }
         }
         return $identQuote;
     }

◆ getServerVersion()

getServerVersion ( )

Retrieve server version in PHP style

Returns: string

Definition at line 726 of file Db2.php.

     {
         $this->_connect();
         $server_info = db2_server_info($this->_connection);
         if ($server_info !== false) {
             $version = $server_info->DBMS_VER;
             if ($this->_isI5) {
                 $version = (int) substr($version, 0, 2) . '.' . (int) substr($version, 2, 2) . '.' . (int) substr($version, 4);
             }
             return $version;
         } else {
             return null;
         }
     }

◆ isConnected()

isConnected ( )

Test if a connection is active

Returns: boolean

Definition at line 205 of file Db2.php.

     {
         return ((bool) (is_resource($this->_connection)
                      && get_resource_type($this->_connection) == 'DB2 Connection'));
     }

◆ isI5()

isI5 ( )

Return whether or not this is running on i5

Returns: bool

Definition at line 746 of file Db2.php.

     {
         if ($this->_isI5 === null) {
             $this->_determineI5();
         }
 
         return (bool) $this->_isI5;
     }

◆ lastInsertId()

lastInsertId	(	$tableName = `null`,
		$primaryKey = `null`,
		$idType = `null`
	)

Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.

As a convention, on RDBMS brands that support sequences (e.g. Oracle, PostgreSQL, DB2), this method forms the name of a sequence from the arguments and returns the last id generated by that sequence. On RDBMS brands that support IDENTITY/AUTOINCREMENT columns, this method returns the last value generated for such a column, and the table name argument is disregarded.

The IDENTITY_VAL_LOCAL() function gives the last generated identity value in the current process, even if it was for a GENERATED column.

Parameters

string	$tableName	OPTIONAL
string	$primaryKey	OPTIONAL
string	$idType	OPTIONAL used for i5 platform to define sequence/idenity unique value

Returns: string

Definition at line 551 of file Db2.php.

     {
         $this->_connect();
 
         if ($this->_isI5) {
             return (string) $this->_i5LastInsertId($tableName, $idType);
         }
 
         if ($tableName !== null) {
             $sequenceName = $tableName;
             if ($primaryKey) {
                 $sequenceName .= "_$primaryKey";
             }
             $sequenceName .= '_seq';
             return $this->lastSequenceId($sequenceName);
         }
 
         $sql = 'SELECT IDENTITY_VAL_LOCAL() AS VAL FROM SYSIBM.SYSDUMMY1';
         $value = $this->fetchOne($sql);
         return (string) $value;
     }

◆ lastSequenceId()

lastSequenceId ( $sequenceName )

Return the most recent value from the specified sequence in the database. This is supported only on RDBMS brands that support sequences (e.g. Oracle, PostgreSQL, DB2). Other RDBMS brands return null.

Parameters

string $sequenceName

Returns: string

Definition at line 500 of file Db2.php.

     {
         $this->_connect();
 
         if (!$this->_isI5) {
             $quotedSequenceName = $this->quoteIdentifier($sequenceName, true);
             $sql = 'SELECT PREVVAL FOR ' . $quotedSequenceName . ' AS VAL FROM SYSIBM.SYSDUMMY1';
         } else {
             $quotedSequenceName = $sequenceName;
             $sql = 'SELECT PREVVAL FOR ' . $this->quoteIdentifier($sequenceName, true) . ' AS VAL FROM QSYS2.QSQPTABL';
         }
 
         $value = $this->fetchOne($sql);
         return (string) $value;
     }

◆ limit()

limit	(	$sql,
		$count,
		$offset = `0`
	)

Adds an adapter-specific LIMIT clause to the SELECT statement.

Parameters

string	$sql
integer	$count
integer	$offset	OPTIONAL

Returns: string

See also: Zend_Db_Adapter_Db2_Exception; Zend_Db_Adapter_Db2_Exception

DB2 does not implement the LIMIT clause as some RDBMS do. We have to simulate it with subqueries and ROWNUM. Unfortunately because we use the column wildcard "*", this puts an extra column into the query result set.

Definition at line 663 of file Db2.php.

     {
         $count = intval($count);
         if ($count <= 0) {
             #require_once 'Zend/Db/Adapter/Db2/Exception.php';
             throw new Zend_Db_Adapter_Db2_Exception("LIMIT argument count=$count is not valid");
         }
 
         $offset = intval($offset);
         if ($offset < 0) {
             #require_once 'Zend/Db/Adapter/Db2/Exception.php';
             throw new Zend_Db_Adapter_Db2_Exception("LIMIT argument offset=$offset is not valid");
         }
 
         if ($offset == 0) {
             $limit_sql = $sql . " FETCH FIRST $count ROWS ONLY";
             return $limit_sql;
         }
 
         $limit_sql = "SELECT z2.*
             FROM (
                 SELECT ROW_NUMBER() OVER() AS \"ZEND_DB_ROWNUM\", z1.*
                 FROM (
                     " . $sql . "
                 ) z1
             ) z2
             WHERE z2.zend_db_rownum BETWEEN " . ($offset+1) . " AND " . ($offset+$count);
         return $limit_sql;
     }

◆ listTables()

listTables ( $schema = null )

Returns a list of the tables in the database.

Parameters

string $schema OPTIONAL

Returns: array

Definition at line 320 of file Db2.php.

     {
         $this->_connect();
 
         if ($schema === null && $this->_config['schema'] != null) {
             $schema = $this->_config['schema'];
         }
 
         $tables = array();
 
         if (!$this->_isI5) {
             if ($schema) {
                 $stmt = db2_tables($this->_connection, null, $schema);
             } else {
                 $stmt = db2_tables($this->_connection);
             }
             while ($row = db2_fetch_assoc($stmt)) {
                 $tables[] = $row['TABLE_NAME'];
             }
         } else {
             $tables = $this->_i5listTables($schema);
         }
 
         return $tables;
     }

◆ nextSequenceId()

nextSequenceId ( $sequenceName )

Generate a new value from the specified sequence in the database, and return it. This is supported only on RDBMS brands that support sequences (e.g. Oracle, PostgreSQL, DB2). Other RDBMS brands return null.

Parameters

string $sequenceName

Returns: string

Definition at line 524 of file Db2.php.

     {
         $this->_connect();
         $sql = 'SELECT NEXTVAL FOR '.$this->quoteIdentifier($sequenceName, true).' AS VAL FROM SYSIBM.SYSDUMMY1';
         $value = $this->fetchOne($sql);
         return (string) $value;
     }

◆ prepare()

prepare ( $sql )

Returns an SQL statement for preparation.

Parameters

string $sql The SQL statement with placeholders.

Returns: Zend_Db_Statement_Db2

Definition at line 230 of file Db2.php.

     {
         $this->_connect();
         $stmtClass = $this->_defaultStmtClass;
         if (!class_exists($stmtClass)) {
             #require_once 'Zend/Loader.php';
             Zend_Loader::loadClass($stmtClass);
         }
         $stmt = new $stmtClass($this, $sql);
         $stmt->setFetchMode($this->_fetchMode);
         return $stmt;
     }

◆ setFetchMode()

setFetchMode ( $mode )

Set the fetch mode.

Parameters

integer $mode

Returns: void

Exceptions

Zend_Db_Adapter_Db2_Exception

See also: Zend_Db_Adapter_Db2_Exception; Zend_Db_Adapter_Db2_Exception

Definition at line 629 of file Db2.php.

     {
         switch ($mode) {
             case Zend_Db::FETCH_NUM:   // seq array
             case Zend_Db::FETCH_ASSOC: // assoc array
             case Zend_Db::FETCH_BOTH:  // seq+assoc array
             case Zend_Db::FETCH_OBJ:   // object
                 $this->_fetchMode = $mode;
                 break;
             case Zend_Db::FETCH_BOUND:   // bound to PHP variable
                 #require_once 'Zend/Db/Adapter/Db2/Exception.php';
                 throw new Zend_Db_Adapter_Db2_Exception('FETCH_BOUND is not supported yet');
                 break;
             default:
                 #require_once 'Zend/Db/Adapter/Db2/Exception.php';
                 throw new Zend_Db_Adapter_Db2_Exception("Invalid fetch mode '$mode' specified");
                 break;
         }
     }

◆ supportsParameters()

supportsParameters ( $type )

Check if the adapter supports real SQL parameters.

Parameters

string $type 'positional' or 'named'

Returns: bool

Definition at line 711 of file Db2.php.

     {
         if ($type == 'positional') {
             return true;
         }
 
         // if its 'named' or anything else
         return false;
     }

Field Documentation

◆ $_config

$_config

protected

Initial value:

= array(
        'dbname'       => null,
        'username'     => null,
        'password'     => null,
        'host'         => 'localhost',
        'port'         => '50000',
        'protocol'     => 'TCPIP',
        'persistent'   => false,
        'os'           => null,
        'schema'       => null
    )

Definition at line 65 of file Db2.php.

◆ $_defaultStmtClass

$_defaultStmtClass = 'Zend_Db_Statement_Db2'

protected

Definition at line 89 of file Db2.php.

◆ $_execute_mode

$_execute_mode = DB2_AUTOCOMMIT_ON

protected

Definition at line 82 of file Db2.php.

◆ $_isI5

$_isI5 = false

protected

Definition at line 90 of file Db2.php.

◆ $_numericDataTypes

$_numericDataTypes

protected

Initial value:

= array(
        Zend_Db::INT_TYPE    => Zend_Db::INT_TYPE,
        Zend_Db::BIGINT_TYPE => Zend_Db::BIGINT_TYPE,
        Zend_Db::FLOAT_TYPE  => Zend_Db::FLOAT_TYPE,
        'INTEGER'            => Zend_Db::INT_TYPE,
        'SMALLINT'           => Zend_Db::INT_TYPE,
        'BIGINT'             => Zend_Db::BIGINT_TYPE,
        'DECIMAL'            => Zend_Db::FLOAT_TYPE,
        'NUMERIC'            => Zend_Db::FLOAT_TYPE
    )

Definition at line 103 of file Db2.php.

The documentation for this class was generated from the following file:

vendor/magento/zendframework1/library/Zend/Db/Adapter/Db2.php

Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Member Function Documentation

◆ _beginTransaction()

◆ _commit()

◆ _connect()

◆ _determineI5()

◆ _getExecuteMode()

◆ _i5LastInsertId()

◆ _i5listTables()

◆ _quote()

◆ _rollBack()

◆ _setExecuteMode()

◆ closeConnection()

◆ describeTable()

◆ getQuoteIdentifierSymbol()

◆ getServerVersion()

◆ isConnected()

◆ isI5()

◆ lastInsertId()

◆ lastSequenceId()

◆ limit()

◆ listTables()

◆ nextSequenceId()

◆ prepare()

◆ setFetchMode()

◆ supportsParameters()

Field Documentation

◆ $_config

◆ $_defaultStmtClass

◆ $_execute_mode

◆ $_isI5

◆ $_numericDataTypes