ADODB_DB2 Class Reference

Inheritance diagram for ADODB_DB2:

List of all members.

Public Member Functions
	ADODB_DB2 ()
	IfNull ($field, $ifNull)
	ServerInfo ()
	_insertid ()
	RowLock ($tables, $where, $flds='1 as ignore')
&	MetaTables ($ttype=false, $showSchema=false, $qtable="%", $qschema="%")
&	MetaIndexes ($table, $primary=FALSE, $owner=false)
	SQLDate ($fmt, $col=false)
&	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputArr=false)
Public Attributes
	$databaseType = "db2"
	$concat_operator = '||'
	maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro
	$sysDate = 'CURRENT_DATE'
	cache for 1 hour
	$sysTimeStamp = 'CURRENT TIMESTAMP'
	name of function that returns the current date
	$fmtTimeStamp = "'Y-m-d-H.i.s'"
	used by DBDate() as the default date format used by the database
	$ansiOuter = true
	operator to use for right outer join in WHERE clause
	$identitySQL = 'values IDENTITY_VAL_LOCAL()'
	$_bindInputArray = true
	A boolean variable to state whether its a persistent connection or normal connection. */.
	$hasInsertID = true

---

Detailed Description

Definition at line 94 of file adodb-odbc_db2.inc.php.

---

Constructor & Destructor Documentation

ADODB_DB2.ADODB_DB2 (   )

Definition at line 107 of file adodb-odbc_db2.inc.php.

---

Member Function Documentation

ADODB_DB2._insertid (   )

Definition at line 126 of file adodb-odbc_db2.inc.php.

ADODB_DB2.IfNull (  $  field, $  ifNull )

Reimplemented from ADOConnection. Definition at line 113 of file adodb-odbc_db2.inc.php.

& ADODB_DB2.MetaIndexes (  $  table, $  primary = FALSE, $  owner = false )

List indexes on a table as an array. Parameters: table  table name to query primary  true to only show primary keys. Not actually used for most databases Returns: array of indexes on current table. Each element represents an index, and is itself an associative array. Array ( [name_of_index] => Array ( [unique] => true or false [columns] => Array ( [0] => firstname [1] => lastname ) ) Reimplemented from ADOConnection. Definition at line 181 of file adodb-odbc_db2.inc.php.

& ADODB_DB2.MetaTables (  $  ttype = false, $  showSchema = false, $  qtable = "%", $  qschema = "%" )

Definition at line 137 of file adodb-odbc_db2.inc.php.

ADODB_DB2.RowLock (  $  tables, $  where, $  flds = '1 as ignore' )

Definition at line 131 of file adodb-odbc_db2.inc.php.

& ADODB_DB2.SelectLimit (  $  sql, $  nrows = -1, $  offset = -1, $  inputArr = false )

Definition at line 275 of file adodb-odbc_db2.inc.php.

ADODB_DB2.ServerInfo (   )

Get server version info... Returns: An array with 2 elements: $arr['string'] is the description string, and $arr[version] is the version (also a string). Reimplemented from ADODB_odbc. Definition at line 118 of file adodb-odbc_db2.inc.php.

ADODB_DB2.SQLDate (  $  fmt, $  col = false )

Reimplemented from ADOConnection. Definition at line 221 of file adodb-odbc_db2.inc.php.

---

Member Data Documentation

ADODB_DB2.$_bindInputArray = true

A boolean variable to state whether its a persistent connection or normal connection. */. Reimplemented from ADODB_odbc. Definition at line 104 of file adodb-odbc_db2.inc.php.

ADODB_DB2.$ansiOuter = true

operator to use for right outer join in WHERE clause Reimplemented from ADOConnection. Definition at line 102 of file adodb-odbc_db2.inc.php.

ADODB_DB2.$concat_operator = '||'

maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro Reimplemented from ADOConnection. Definition at line 96 of file adodb-odbc_db2.inc.php.

ADODB_DB2.$databaseType = "db2"

Reimplemented from ADODB_odbc. Definition at line 95 of file adodb-odbc_db2.inc.php.

ADODB_DB2.$fmtTimeStamp = "'Y-m-d-H.i.s'"

used by DBDate() as the default date format used by the database Reimplemented from ADODB_odbc. Definition at line 101 of file adodb-odbc_db2.inc.php.

ADODB_DB2.$hasInsertID = true

Reimplemented from ADOConnection. Definition at line 105 of file adodb-odbc_db2.inc.php.

ADODB_DB2.$identitySQL = 'values IDENTITY_VAL_LOCAL()'

Definition at line 103 of file adodb-odbc_db2.inc.php.

ADODB_DB2.$sysDate = 'CURRENT_DATE'

cache for 1 hour Reimplemented from ADOConnection. Definition at line 97 of file adodb-odbc_db2.inc.php.

ADODB_DB2.$sysTimeStamp = 'CURRENT TIMESTAMP'

name of function that returns the current date Reimplemented from ADOConnection. Definition at line 98 of file adodb-odbc_db2.inc.php.

---

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

• typo3/sysext/adodb/adodb/drivers/adodb-odbc_db2.inc.php

---