ADODB_netezza Class Reference

Inheritance diagram for ADODB_netezza:

Public Member Functions
	__construct ()
	MetaColumns ($table, $upper=true)
Public Member Functions inherited from ADODB_postgres64
	__construct ()
	ServerInfo ()
	IfNull ( $field, $ifNull)
	pg_insert_id ($tablename, $fieldname)
	_insertid ($table, $column)
	_affectedrows ()
	BeginTrans ()
	RowLock ($tables, $where, $col='1 as adodbignore')
	CommitTrans ($ok=true)
	RollbackTrans ()
	MetaTables ($ttype=false, $showSchema=false, $mask=false)
	qstr ($s, $magic_quotes=false)
	SQLDate ($fmt, $col=false)
	UpdateBlobFile ($table, $column, $path, $where, $blobtype='BLOB')
	BlobDelete ( $blob)
	GuessOID ($oid)
	BlobDecode ($blob, $maxsize=false, $hastrans=true)
	BlobEncode ($blob)
	UpdateBlob ($table, $column, $val, $where, $blobtype='BLOB')
	OffsetDate ($dayFraction, $date=false)
	MetaColumns ($table, $normalize=true)
	Param ($name, $type='C')
	MetaIndexes ($table, $primary=FALSE, $owner=false)
	_connect ($str, $user='', $pwd='', $db='', $ctype=0)
	_nconnect ($argHostname, $argUsername, $argPassword, $argDatabaseName)
	_pconnect ($str, $user='', $pwd='', $db='')
	_query ($sql, $inputarr=false)
	_errconnect ()
	ErrorMsg ()
	ErrorNo ()
	_close ()
	CharMax ()
	TextMax ()

Public Attributes
	$databaseType = 'netezza'
	$dataProvider = 'netezza'
	$hasInsertID = false
	$_resultid = false
	$concat_operator ='||'
	$random = 'random'
	$metaDatabasesSQL = "select objname from _v_object_data where objtype='database' order by 1"
	$metaTablesSQL = "select objname from _v_object_data where objtype='table' order by 1"
	$isoDates = true
	$sysDate = "CURRENT_DATE"
	$sysTimeStamp = "CURRENT_TIMESTAMP"
	$blobEncodeType = 'C'
	$metaColumnsSQL = "SELECT attname, atttype FROM _v_relation_column_def WHERE name = '%s' AND attnum > 0 ORDER BY attnum"
	$metaColumnsSQL1 = "SELECT attname, atttype FROM _v_relation_column_def WHERE name = '%s' AND attnum > 0 ORDER BY attnum"
	$metaKeySQL = ""
	$hasAffectedRows = true
	$hasLimit = true
	$true = 't'
	$false = 'f'
	$fmtDate = "'Y-m-d'"
	$fmtTimeStamp = "'Y-m-d G:i:s'"
	$ansiOuter = true
	$autoRollback = true
Public Attributes inherited from ADODB_postgres64
	$databaseType = 'postgres64'
	$dataProvider = 'postgres'
	$hasInsertID = true
	$_resultid = false
	$concat_operator ='||'
	$metaDatabasesSQL = "select datname from pg_database where datname not in ('template0','template1') order by 1"
	$metaTablesSQL
	$isoDates = true
	$sysDate = "CURRENT_DATE"
	$sysTimeStamp = "CURRENT_TIMESTAMP"
	$blobEncodeType = 'C'
	$metaColumnsSQL
	$metaColumnsSQL1
	$metaKeySQL
	$hasAffectedRows = true
	$hasLimit = false
	$true = 'TRUE'
	$false = 'FALSE'
	$fmtDate = "'Y-m-d'"
	$fmtTimeStamp = "'Y-m-d H:i:s'"
	$hasMoveFirst = true
	$hasGenID = true
	$_genIDSQL = "SELECT NEXTVAL('%s')"
	$_genSeqSQL = "CREATE SEQUENCE %s START %s"
	$_dropSeqSQL = "DROP SEQUENCE %s"
	$metaDefaultsSQL = "SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum"
	$random = 'random()'
	$autoRollback = true
	random function More...
	$uniqueIisR = true
	$_bindInputArray = false
	$disableBlobs = false
	$_pnum = 0

Additional Inherited Members
Protected Member Functions inherited from ADODB_postgres64
	_generateMetaColumnsSQL ($table, $schema)

Detailed Description

Definition at line 24 of file adodb-netezza.inc.php.

Constructor & Destructor Documentation

__construct()

ADODB_netezza::__construct

(

)

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

Member Function Documentation

MetaColumns()

ADODB_netezza::MetaColumns	(		$table,
			$upper = true
	)

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

References $rs.

Member Data Documentation

$_resultid

ADODB_netezza::$_resultid = false

Definition at line 28 of file adodb-netezza.inc.php.

$ansiOuter

ADODB_netezza::$ansiOuter = true

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

$autoRollback

ADODB_netezza::$autoRollback = true

Definition at line 49 of file adodb-netezza.inc.php.

$blobEncodeType

ADODB_netezza::$blobEncodeType = 'C'

Definition at line 36 of file adodb-netezza.inc.php.

$concat_operator

ADODB_netezza::$concat_operator ='||'

Definition at line 29 of file adodb-netezza.inc.php.

$databaseType

ADODB_netezza::$databaseType = 'netezza'

Definition at line 25 of file adodb-netezza.inc.php.

$dataProvider

ADODB_netezza::$dataProvider = 'netezza'

Definition at line 26 of file adodb-netezza.inc.php.

$false

ADODB_netezza::$false = 'f'

Definition at line 45 of file adodb-netezza.inc.php.

$fmtDate

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

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

$fmtTimeStamp

ADODB_netezza::$fmtTimeStamp = "'Y-m-d G:i:s'"

Definition at line 47 of file adodb-netezza.inc.php.

$hasAffectedRows

ADODB_netezza::$hasAffectedRows = true

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

$hasInsertID

ADODB_netezza::$hasInsertID = false

Definition at line 27 of file adodb-netezza.inc.php.

$hasLimit

ADODB_netezza::$hasLimit = true

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

$isoDates

ADODB_netezza::$isoDates = true

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

$metaColumnsSQL

ADODB_netezza::$metaColumnsSQL = "SELECT attname, atttype FROM _v_relation_column_def WHERE name = '%s' AND attnum > 0 ORDER BY attnum"

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

$metaColumnsSQL1

ADODB_netezza::$metaColumnsSQL1 = "SELECT attname, atttype FROM _v_relation_column_def WHERE name = '%s' AND attnum > 0 ORDER BY attnum"

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

$metaDatabasesSQL

ADODB_netezza::$metaDatabasesSQL = "select objname from _v_object_data where objtype='database' order by 1"

Definition at line 31 of file adodb-netezza.inc.php.

$metaKeySQL

ADODB_netezza::$metaKeySQL = ""

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

$metaTablesSQL

ADODB_netezza::$metaTablesSQL = "select objname from _v_object_data where objtype='table' order by 1"

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

$random

ADODB_netezza::$random = 'random'

Definition at line 30 of file adodb-netezza.inc.php.

$sysDate

ADODB_netezza::$sysDate = "CURRENT_DATE"

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

$sysTimeStamp

ADODB_netezza::$sysTimeStamp = "CURRENT_TIMESTAMP"

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

$true

ADODB_netezza::$true = 't'

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