ADODB_netezza Class Reference

Inheritance diagram for ADODB_netezza:

ADODB_postgres64 ADOConnection List of all members.

Public Member Functions

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

Public Attributes

 $databaseType = 'netezza'
 $dataProvider = 'netezza'
 $hasInsertID = false
 $_resultid = false
 $concat_operator = '||'
 maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro
 $random = 'random'
 string length ofperator
 $metaDatabasesSQL = "select objname from _v_object_data where objtype='database' order by 1"
 character set to use - only for interbase, postgres and oci8
 $metaTablesSQL = "select objname from _v_object_data where objtype='table' order by 1"
 $isoDates = true
 error function to call
 $sysDate = "CURRENT_DATE"
 cache for 1 hour
 $sysTimeStamp = "CURRENT_TIMESTAMP"
 name of function that returns the current date
 $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
 supports autoincrement ID?
 $hasLimit = true
 support mssql/access SELECT TOP 10 * FROM TABLE
 $true = 't'
 used by DBTimeStamp as the default timestamp fmt.
 $false = 'f'
 string that represents TRUE for a database
 $fmtDate = "'Y-m-d'"
 uppercase function
 $fmtTimeStamp = "'Y-m-d G: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
 $autoRollback = true
 random function

Detailed Description

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


Constructor & Destructor Documentation

ADODB_netezza.ADODB_netezza  ) 
 

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


Member Function Documentation

& ADODB_netezza.MetaColumns table,
upper = true
 

List columns in a database as an array of ADOFieldObjects. See top of file for definition of object.

Parameters:
$table table name to query
$normalize makes table name case-insensitive (required by some databases) is optional database schema to use - not supported by all databases.
Returns:
array of ADOFieldObjects for current table.

Reimplemented from ADOConnection.

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


Member Data Documentation

ADODB_netezza.$_resultid = false
 

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$ansiOuter = true
 

operator to use for right outer join in WHERE clause

Reimplemented from ADOConnection.

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

ADODB_netezza.$autoRollback = true
 

random function

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$blobEncodeType = 'C'
 

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$concat_operator = '||'
 

maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$databaseType = 'netezza'
 

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$dataProvider = 'netezza'
 

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$false = 'f'
 

string that represents TRUE for a database

Reimplemented from ADODB_postgres64.

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

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

uppercase function

Reimplemented from ADODB_postgres64.

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

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

used by DBDate() as the default date format used by the database

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$hasAffectedRows = true
 

supports autoincrement ID?

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$hasInsertID = false
 

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$hasLimit = true
 

support mssql/access SELECT TOP 10 * FROM TABLE

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$isoDates = true
 

error function to call

Reimplemented from ADODB_postgres64.

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

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

Reimplemented from ADODB_postgres64.

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

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

Reimplemented from ADODB_postgres64.

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

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

character set to use - only for interbase, postgres and oci8

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$metaKeySQL = ""
 

Reimplemented from ADODB_postgres64.

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

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

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$random = 'random'
 

string length ofperator

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$sysDate = "CURRENT_DATE"
 

cache for 1 hour

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$sysTimeStamp = "CURRENT_TIMESTAMP"
 

name of function that returns the current date

Reimplemented from ADODB_postgres64.

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

ADODB_netezza.$true = 't'
 

used by DBTimeStamp as the default timestamp fmt.

Reimplemented from ADODB_postgres64.

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


The documentation for this class was generated from the following file:
Generated on Fri Apr 7 10:48:44 2006 for TYPO3 by  doxygen 1.4.6