Inheritance diagram for Zend_Db_Adapter_Pdo_Ibm:

Public Member Functions
	_connect ()

	prepare ($sql)

	listTables ()

	describeTable ($tableName, $schemaName=null)

	insert ($table, array $bind)

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

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

	lastSequenceId ($sequenceName)

	nextSequenceId ($sequenceName)

	getServerVersion ()

Public Member Functions inherited from Zend_Db_Adapter_Pdo_Abstract
	isConnected ()

	closeConnection ()

	prepare ($sql)

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

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

	exec ($sql)

	setFetchMode ($mode)

	supportsParameters ($type)

	getServerVersion ()

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
	_dsn ()

	_checkRequiredOptions (array $config)

Protected Member Functions inherited from Zend_Db_Adapter_Pdo_Abstract
	_dsn ()

	_connect ()

	_quote ($value)

	_beginTransaction ()

	_commit ()

	_rollBack ()

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
	$_pdoType = 'ibm'

	$_serverType = null

	$_numericDataTypes

Protected Attributes inherited from Zend_Db_Adapter_Pdo_Abstract
	$_defaultStmtClass = 'Zend_Db_Statement_Pdo'

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 44 of file Ibm.php.

Member Function Documentation

◆ _checkRequiredOptions()

_checkRequiredOptions ( array $config )

protected

Checks required options

Parameters

array $config

Exceptions

Zend_Db_Adapter_Exception

Returns: void

See also: Zend_Db_Adapter_Exception

Definition at line 174 of file Ibm.php.

     {
         parent::_checkRequiredOptions($config);
 
         if (array_key_exists('host', $this->_config) &&
         !array_key_exists('port', $config)) {
             #require_once 'Zend/Db/Adapter/Exception.php';
             throw new Zend_Db_Adapter_Exception("Configuration must have a key for 'port' when 'host' is specified");
         }
     }

◆ _connect()

_connect ( )

Creates a PDO object and connects to the database.

The IBM data server is set. Current options are DB2 or IDS

Todo:: also differentiate between z/OS and i/5

Returns: void

Exceptions

Zend_Db_Adapter_Exception

See also: Zend_Db_Adapter_Exception

Definition at line 96 of file Ibm.php.

     {
         if ($this->_connection) {
             return;
         }
         parent::_connect();
 
         $this->getConnection()->setAttribute(Zend_Db::ATTR_STRINGIFY_FETCHES, true);
 
         try {
             if ($this->_serverType === null) {
                 $server = substr($this->getConnection()->getAttribute(PDO::ATTR_SERVER_INFO), 0, 3);
 
                 switch ($server) {
                     case 'DB2':
                         $this->_serverType = new Zend_Db_Adapter_Pdo_Ibm_Db2($this);
 
                         // Add DB2-specific numeric types
                         $this->_numericDataTypes['DECFLOAT'] = Zend_Db::FLOAT_TYPE;
                         $this->_numericDataTypes['DOUBLE']   = Zend_Db::FLOAT_TYPE;
                         $this->_numericDataTypes['NUM']      = Zend_Db::FLOAT_TYPE;
 
                         break;
                     case 'IDS':
                         $this->_serverType = new Zend_Db_Adapter_Pdo_Ibm_Ids($this);
 
                         // Add IDS-specific numeric types
                         $this->_numericDataTypes['SERIAL']       = Zend_Db::INT_TYPE;
                         $this->_numericDataTypes['SERIAL8']      = Zend_Db::BIGINT_TYPE;
                         $this->_numericDataTypes['INT8']         = Zend_Db::BIGINT_TYPE;
                         $this->_numericDataTypes['SMALLFLOAT']   = Zend_Db::FLOAT_TYPE;
                         $this->_numericDataTypes['MONEY']        = Zend_Db::FLOAT_TYPE;
 
                         break;
                     }
             }
         } catch (PDOException $e) {
             #require_once 'Zend/Db/Adapter/Exception.php';
             $error = strpos($e->getMessage(), 'driver does not support that attribute');
             if ($error) {
                 throw new Zend_Db_Adapter_Exception("PDO_IBM driver extension is downlevel.  Please use driver release version 1.2.1 or later", 0, $e);
             } else {
                 throw new Zend_Db_Adapter_Exception($e->getMessage(), $e->getCode(), $e);
             }
         }
     }

◆ _dsn()

_dsn ( )

protected

Creates a PDO DSN for the adapter from $this->_config settings.

Returns: string

Definition at line 149 of file Ibm.php.

     {
         $this->_checkRequiredOptions($this->_config);
 
         // check if using full connection string
         if (array_key_exists('host', $this->_config)) {
             $dsn = ';DATABASE=' . $this->_config['dbname']
             . ';HOSTNAME=' . $this->_config['host']
             . ';PORT='     . $this->_config['port']
             // PDO_IBM supports only DB2 TCPIP protocol
             . ';PROTOCOL=' . 'TCPIP;';
         } else {
             // catalogued connection
             $dsn = $this->_config['dbname'];
         }
         return $this->_pdoType . ': ' . $dsn;
     }

◆ 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 PRIMARY => boolean; true if column is part of the primary key PRIMARY_POSITION => integer; position of column in primary key

Todo:: Discover integer unsigned property.

Parameters

string	$tableName
string	$schemaName	OPTIONAL

Returns: array

Definition at line 242 of file Ibm.php.

     {
         $this->_connect();
         return $this->_serverType->describeTable($tableName, $schemaName);
     }

◆ getServerVersion()

getServerVersion ( )

Retrieve server version in PHP style Pdo_Idm doesn't support getAttribute(PDO::ATTR_SERVER_VERSION)

Returns: string

Definition at line 342 of file Ibm.php.

     {
         try {
             $stmt = $this->query('SELECT service_level, fixpack_num FROM TABLE (sysproc.env_get_inst_info()) as INSTANCEINFO');
             $result = $stmt->fetchAll(Zend_Db::FETCH_NUM);
             if (count($result)) {
                 $matches = null;
                 if (preg_match('/((?:[0-9]{1,2}\.){1,3}[0-9]{1,2})/', $result[0][0], $matches)) {
                     return $matches[1];
                 } else {
                     return null;
                 }
             }
             return null;
         } catch (PDOException $e) {
             return null;
         }
     }

◆ insert()

insert	(		$table,
		array	$bind
	)

Inserts a table row with specified data. Special handling for PDO_IBM remove empty slots

Parameters

mixed	$table	The table to insert data into.
array	$bind	Column-value pairs.

Returns: int The number of affected rows.

Definition at line 257 of file Ibm.php.

     {
         $this->_connect();
         $newbind = array();
         if (is_array($bind)) {
             foreach ($bind as $name => $value) {
                 if($value !== null) {
                     $newbind[$name] = $value;
                 }
             }
         }
 
         return parent::insert($table, $newbind);
     }

◆ lastInsertId()

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

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

Parameters

string	$tableName	OPTIONAL
string	$primaryKey	OPTIONAL

Returns: integer

Definition at line 294 of file Ibm.php.

     {
         $this->_connect();
 
          if ($tableName !== null) {
             $sequenceName = $tableName;
             if ($primaryKey) {
                 $sequenceName .= "_$primaryKey";
             }
             $sequenceName .= '_seq';
             return $this->lastSequenceId($sequenceName);
         }
 
         $id = $this->getConnection()->lastInsertId();
 
         return $id;
     }

◆ lastSequenceId()

lastSequenceId ( $sequenceName )

Return the most recent value from the specified sequence in the database.

Parameters

string $sequenceName

Returns: integer

Definition at line 318 of file Ibm.php.

     {
         $this->_connect();
         return $this->_serverType->lastSequenceId($sequenceName);
     }

◆ 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

Definition at line 280 of file Ibm.php.

     {
        $this->_connect();
        return $this->_serverType->limit($sql, $count, $offset);
     }

◆ listTables()

listTables ( )

Returns a list of the tables in the database.

Returns: array

Definition at line 207 of file Ibm.php.

     {
         $this->_connect();
         return $this->_serverType->listTables();
     }

◆ nextSequenceId()

nextSequenceId ( $sequenceName )

Generate a new value from the specified sequence in the database, and return it.

Parameters

string $sequenceName

Returns: integer

Definition at line 331 of file Ibm.php.

     {
         $this->_connect();
         return $this->_serverType->nextSequenceId($sequenceName);
     }

◆ prepare()

prepare ( $sql )

Prepares an SQL statement.

Parameters

string	$sql	The SQL statement with placeholders.
array	$bind	An array of data to bind to the placeholders.

Returns: PDOStatement

Definition at line 193 of file Ibm.php.

     {
         $this->_connect();
         $stmtClass = $this->_defaultStmtClass;
         $stmt = new $stmtClass($this, $sql);
         $stmt->setFetchMode($this->_fetchMode);
         return $stmt;
     }

Field Documentation

◆ $_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,
                        'DEC'                => Zend_Db::FLOAT_TYPE,
                        'REAL'               => Zend_Db::FLOAT_TYPE,
                        'NUMERIC'            => Zend_Db::FLOAT_TYPE,
                        'DOUBLE PRECISION'   => Zend_Db::FLOAT_TYPE,
                        'FLOAT'              => Zend_Db::FLOAT_TYPE
                        )

Definition at line 71 of file Ibm.php.

◆ $_pdoType

$_pdoType = 'ibm'

protected

Definition at line 51 of file Ibm.php.

◆ $_serverType

$_serverType = null

protected

Definition at line 58 of file Ibm.php.

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

vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Ibm.php

Public Member Functions

Protected Member Functions

Protected Attributes

Detailed Description

Member Function Documentation

◆ _checkRequiredOptions()

◆ _connect()

◆ _dsn()

◆ describeTable()

◆ getServerVersion()

◆ insert()

◆ lastInsertId()

◆ lastSequenceId()

◆ limit()

◆ listTables()

◆ nextSequenceId()

◆ prepare()

Field Documentation

◆ $_numericDataTypes

◆ $_pdoType

◆ $_serverType