ADODB_db2 Class Reference

Inheritance diagram for ADODB_db2:

Public Member Functions
	_insertid ()
	__construct ()
	_connect ($argDSN, $argUsername, $argPassword, $argDatabasename)
	_pconnect ($argDSN, $argUsername, $argPassword, $argDatabasename)
	DBTimeStamp ($ts, $isfld=false)
	SQLDate ($fmt, $col=false)
	ServerInfo ()
	CreateSequence ($seqname='adodbseq', $start=1)
	DropSequence ($seqname='adodbseq')
	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputArr=false, $secs2cache=0)
	GenID ($seq='adodbseq', $start=1)
	ErrorMsg ()
	ErrorNo ()
	BeginTrans ()
	CommitTrans ($ok=true)
	RollbackTrans ()
	MetaPrimaryKeys ($table, $owner=false)
	MetaForeignKeys ($table, $owner=FALSE, $upper=FALSE, $asociative=FALSE)
	MetaTables ($ttype=false, $schema=false, $mask=false)
	DB2Types ($t)
	MetaColumns ($table, $normalize=true)
	Prepare ($sql)
	_query ($sql, $inputarr=false)
	UpdateBlob ($table, $column, $val, $where, $blobtype='BLOB')
	_close ()
	_affectedrows ()

Public Attributes
	$databaseType = "db2"
	$fmtDate = "'Y-m-d'"
	$concat_operator = '||'
	$sysTime = 'CURRENT TIME'
	$sysDate = 'CURRENT DATE'
	$sysTimeStamp = 'CURRENT TIMESTAMP'
	$fmtTimeStamp = "'Y-m-d H:i:s'"
	$replaceQuote = "''"
	$dataProvider = "db2"
	$hasAffectedRows = true
	$binmode = DB2_BINARY
	$useFetchArray = false
	$_bindInputArray = false
	$_genIDSQL = "VALUES NEXTVAL FOR %s"
	$_genSeqSQL = "CREATE SEQUENCE %s START WITH %s NO MAXVALUE NO CYCLE"
	$_dropSeqSQL = "DROP SEQUENCE %s"
	$_autocommit = true
	$_haserrorfunctions = true
	$_lastAffectedRows = 0
	$uCaseTables = true
	$hasInsertID = true

Detailed Description

Definition at line 32 of file adodb-db2.inc.php.

Constructor & Destructor Documentation

__construct()

ADODB_db2::__construct

(

)

Definition at line 66 of file adodb-db2.inc.php.

Member Function Documentation

_affectedrows()

ADODB_db2::_affectedrows

(

)

Definition at line 713 of file adodb-db2.inc.php.

References $_lastAffectedRows.

_close()

ADODB_db2::_close

(

)

Definition at line 706 of file adodb-db2.inc.php.

_connect()

ADODB_db2::_connect	(		$argDSN,
			$argUsername,
			$argPassword,
			$argDatabasename
	)

Definition at line 72 of file adodb-db2.inc.php.

_insertid()

ADODB_db2::_insertid

(

)

Definition at line 61 of file adodb-db2.inc.php.

_pconnect()

ADODB_db2::_pconnect	(		$argDSN,
			$argUsername,
			$argPassword,
			$argDatabasename
	)

Definition at line 106 of file adodb-db2.inc.php.

_query()

ADODB_db2::_query	(		$sql,
			$inputarr = false
	)

Definition at line 628 of file adodb-db2.inc.php.

References $sql.

BeginTrans()

ADODB_db2::BeginTrans

(

)

Definition at line 308 of file adodb-db2.inc.php.

CommitTrans()

ADODB_db2::CommitTrans

(

$ok = true

)

Definition at line 317 of file adodb-db2.inc.php.

References RollbackTrans().

CreateSequence()

ADODB_db2::CreateSequence	(		$seqname = 'adodbseq',
			$start = 1
	)

Definition at line 230 of file adodb-db2.inc.php.

DB2Types()

ADODB_db2::DB2Types

(

$t

)

Definition at line 479 of file adodb-db2.inc.php.

Referenced by MetaColumns().

DBTimeStamp()

ADODB_db2::DBTimeStamp	(		$ts,
			$isfld = false
	)

Definition at line 139 of file adodb-db2.inc.php.

DropSequence()

ADODB_db2::DropSequence

(

$seqname = 'adodbseq'

)

Definition at line 238 of file adodb-db2.inc.php.

ErrorMsg()

ADODB_db2::ErrorMsg

(

)

Definition at line 278 of file adodb-db2.inc.php.

ErrorNo()

ADODB_db2::ErrorNo

(

)

Definition at line 287 of file adodb-db2.inc.php.

GenID()

ADODB_db2::GenID	(		$seq = 'adodbseq',
			$start = 1
	)

Definition at line 269 of file adodb-db2.inc.php.

MetaColumns()

ADODB_db2::MetaColumns	(		$table,
			$normalize = true
	)

Definition at line 519 of file adodb-db2.inc.php.

References $rs, and DB2Types().

MetaForeignKeys()

ADODB_db2::MetaForeignKeys	(		$table,
			$owner = FALSE,
			$upper = FALSE,
			$asociative = FALSE
	)

Definition at line 368 of file adodb-db2.inc.php.

References $rs.

MetaPrimaryKeys()

ADODB_db2::MetaPrimaryKeys	(		$table,
			$owner = false
	)

Definition at line 338 of file adodb-db2.inc.php.

References $rs.

MetaTables()

ADODB_db2::MetaTables	(		$ttype = false,
			$schema = false,
			$mask = false
	)

Definition at line 414 of file adodb-db2.inc.php.

References $rs.

Prepare()

ADODB_db2::Prepare

(

$sql

)

Definition at line 616 of file adodb-db2.inc.php.

References $sql.

RollbackTrans()

ADODB_db2::RollbackTrans

(

)

Definition at line 328 of file adodb-db2.inc.php.

Referenced by CommitTrans().

SelectLimit()

ADODB_db2::SelectLimit	(		$sql,
			$nrows = -1,
			$offset = -1,
			$inputArr = false,
			$secs2cache = 0
	)

Definition at line 244 of file adodb-db2.inc.php.

References $rs, and $sql.

ServerInfo()

ADODB_db2::ServerInfo

(

)

Definition at line 213 of file adodb-db2.inc.php.

SQLDate()

ADODB_db2::SQLDate	(		$fmt,
			$col = false
	)

Definition at line 147 of file adodb-db2.inc.php.

References $concat_operator, and $sysDate.

UpdateBlob()

ADODB_db2::UpdateBlob	(		$table,
			$column,
			$val,
			$where,
			$blobtype = 'BLOB'
	)

Definition at line 700 of file adodb-db2.inc.php.

Member Data Documentation

$_autocommit

ADODB_db2::$_autocommit = true

Definition at line 54 of file adodb-db2.inc.php.

$_bindInputArray

ADODB_db2::$_bindInputArray = false

Definition at line 50 of file adodb-db2.inc.php.

$_dropSeqSQL

ADODB_db2::$_dropSeqSQL = "DROP SEQUENCE %s"

Definition at line 53 of file adodb-db2.inc.php.

$_genIDSQL

ADODB_db2::$_genIDSQL = "VALUES NEXTVAL FOR %s"

Definition at line 51 of file adodb-db2.inc.php.

$_genSeqSQL

ADODB_db2::$_genSeqSQL = "CREATE SEQUENCE %s START WITH %s NO MAXVALUE NO CYCLE"

Definition at line 52 of file adodb-db2.inc.php.

$_haserrorfunctions

ADODB_db2::$_haserrorfunctions = true

Definition at line 55 of file adodb-db2.inc.php.

$_lastAffectedRows

ADODB_db2::$_lastAffectedRows = 0

Definition at line 56 of file adodb-db2.inc.php.

Referenced by _affectedrows().

$binmode

ADODB_db2::$binmode = DB2_BINARY

Definition at line 46 of file adodb-db2.inc.php.

$concat_operator

ADODB_db2::$concat_operator = '||'

Definition at line 35 of file adodb-db2.inc.php.

Referenced by SQLDate().

$databaseType

ADODB_db2::$databaseType = "db2"

Definition at line 33 of file adodb-db2.inc.php.

$dataProvider

ADODB_db2::$dataProvider = "db2"

Definition at line 43 of file adodb-db2.inc.php.

$fmtDate

ADODB_db2::$fmtDate = "'Y-m-d'"

Definition at line 34 of file adodb-db2.inc.php.

$fmtTimeStamp

ADODB_db2::$fmtTimeStamp = "'Y-m-d H:i:s'"

Definition at line 41 of file adodb-db2.inc.php.

$hasAffectedRows

ADODB_db2::$hasAffectedRows = true

Definition at line 44 of file adodb-db2.inc.php.

$hasInsertID

ADODB_db2::$hasInsertID = true

Definition at line 58 of file adodb-db2.inc.php.

$replaceQuote

ADODB_db2::$replaceQuote = "''"

Definition at line 42 of file adodb-db2.inc.php.

$sysDate

ADODB_db2::$sysDate = 'CURRENT DATE'

Definition at line 38 of file adodb-db2.inc.php.

Referenced by SQLDate().

$sysTime

ADODB_db2::$sysTime = 'CURRENT TIME'

Definition at line 37 of file adodb-db2.inc.php.

$sysTimeStamp

ADODB_db2::$sysTimeStamp = 'CURRENT TIMESTAMP'

Definition at line 39 of file adodb-db2.inc.php.

$uCaseTables

ADODB_db2::$uCaseTables = true

Definition at line 57 of file adodb-db2.inc.php.

$useFetchArray

ADODB_db2::$useFetchArray = false

Definition at line 48 of file adodb-db2.inc.php.