ADODB_netezza Class Reference
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" | |
| Use 'true' to store the item compressed (uses zlib). | |
| $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.
Member Function Documentation
| ADODB_netezza.ADODB_netezza | ( | ) |
Definition at line 51 of file adodb-netezza.inc.php.
| & ADODB_netezza.MetaColumns | ( | $ | table, | |
| $ | normalize = 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 ADODB_postgres64.
Definition at line 56 of file adodb-netezza.inc.php.
References $ADODB_FETCH_MODE, $rs, ADOConnection.Execute(), and ADOConnection.SetFetchMode().
Member Data Documentation
| ADODB_netezza.$databaseType = 'netezza' |
| ADODB_netezza.$dataProvider = 'netezza' |
| ADODB_netezza.$hasInsertID = false |
| ADODB_netezza.$_resultid = false |
| 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.$random = 'random' |
string length ofperator
Reimplemented from ADODB_postgres64.
Definition at line 28 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.$metaTablesSQL = "select objname from _v_object_data where objtype='table' order by 1" |
| ADODB_netezza.$isoDates = true |
error function to call
Reimplemented from ADODB_postgres64.
Definition at line 31 of file adodb-netezza.inc.php.
| ADODB_netezza.$sysDate = "CURRENT_DATE" |
Use 'true' to store the item compressed (uses zlib).
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.$blobEncodeType = 'C' |
| ADODB_netezza.$metaColumnsSQL = "SELECT attname, atttype FROM _v_relation_column_def WHERE name = '%s' AND attnum > 0 ORDER BY attnum" |
| ADODB_netezza.$metaColumnsSQL1 = "SELECT attname, atttype FROM _v_relation_column_def WHERE name = '%s' AND attnum > 0 ORDER BY attnum" |
| ADODB_netezza.$metaKeySQL = "" |
| ADODB_netezza.$hasAffectedRows = true |
supports autoincrement ID?
Reimplemented from ADODB_postgres64.
Definition at line 40 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.$true = 't' |
used by DBTimeStamp as the default timestamp fmt.
Reimplemented from ADODB_postgres64.
Definition at line 42 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.$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.
The documentation for this class was generated from the following file:
- typo3/sysext/adodb/adodb/drivers/adodb-netezza.inc.php
