Data Source Information Property Group
|
Property |
Default Value |
Mode Read Write |
Comments |
|
DBPROP_ACTIVESESSIONS |
200 |
R |
No Effect |
|
DBPROP_ASYNCTXNABORT |
FALSE |
R |
|
|
DBPROP_ASYNCTXNCOMMIT |
FALSE |
R |
|
|
DBPROP_BYREFACCESSORS |
TRUE |
R |
|
|
DBPROP_CATALOGLOCATION |
0 |
R |
Not Supported |
|
DBPROP_CATALOGTERM |
|
R |
Not Supported |
|
DBPROP_CATALOGUSAGE |
0 |
R |
Not Supported |
|
DBPROP_COLUMNDEFINITION |
1 |
R |
|
|
DBPROP_CONCATNULLBEHAVIOR |
0 |
R |
|
|
DBPROP_CONNECTIONSTATUS |
DBPROPVAL_CS_INITIALIZED |
R |
|
|
DBPROP_DATASOURCENAME |
Data Source specified in DBPROP_INIT_DATASOURCE |
R |
DBC Name |
|
DBPROP_DATASOURCEREADONLY |
FALSE |
R |
|
|
DBPROP_DBMSNAME |
Teradata |
R |
|
|
DBPROP_DBMSVER |
Version of Teradata installed |
R |
Teradata Version |
|
DBPROP_DSOTHREADMODEL |
DBPROVAL_RT_FREETHREAD |
R |
|
|
DBPROP_DSOTHREADINGMODEL |
DBPROPVAL_FREETHREAD |
R |
|
|
DBPROP_GROUPBY |
DBPROPVAL_GB_EQUALS_SELECT |
R |
|
|
DBPROP_HETEROGENEOUSTABLES |
0 |
R |
|
|
DBPROP_IDENTIFIERCASE |
DBPROPVAL_IC_SENSITIVE |
R |
|
|
DBPROP_MAXINDEXSIZE |
255 |
R |
Maximum number of bytes allowed in an index. |
|
DBPROP_MAXROWSIZE |
64256 |
R |
Maximum size of a single row in a table |
|
DBPROP_MAXROWSIZEINCLUDESBLOB |
TRUE |
R |
|
|
DBPROP_MAXTABLESINSELECT |
15 |
R |
Maximum number of tables that can be specified in a select statement. This number can be ignored. |
|
DBPROP_MULTIPLEPARAMSETS |
TRUE |
R |
|
|
DBPROP_MULTIPLERESULTS |
DBPROPVAL_MR_SUPPORTED |
R |
|
|
DBPROP_MULTIPLESTORAGEOBJECTS |
FALSE |
R |
|
|
DBPROP_MULTITABLEUPDATE |
FALSE |
R |
|
|
DBPROP_NULLCOLLATION |
DBPROPVAL_NC_LOW |
R |
|
|
DBPROP_OLEOBJECTS |
DBPROPVAL_OO_BLOB |
R |
|
|
DBPROP_OPENROWSETSUPPORT |
DBPROPVAL_ORS_TABLE |
R |
|
|
DBPROP_ORDERBYCOLUMNSINSELECT |
FALSE |
R |
|
|
DBPROP_OUTPUTPARAMETERAVAILABILITY |
DBPROPVAL_OA_ATROWRELEASE |
R |
|
|
DBPROP_PERSISTENTIDTYPE |
DBPROPVAL_PT_NAME |
R |
|
|
DBPROP_PREPAREABORTBEHAVIOR |
DBPROPVAL_CB_PRESERVE |
R |
|
|
DBPROP_PREPARECOMMITBEHVIOR |
DBPROPVAL_CB_PRESERVE |
R |
|
|
DBPROP_PROCEDURETERM |
MACRO PROCEDURE |
R |
|
|
DBPROP_PROVIDERFILENAME |
TDOLEDB.DLL |
R |
|
|
DBPROP_PROVIDERFRIENDLYNAME |
OLE DB Provider for Teradata |
R |
|
|
DBPROP_PROVIDEROLEDBVER |
03.00 |
R |
|
|
DBPROP_PROVIDERVER |
01.00.00 |
R |
|
|
DBPROP_QUOTEDIDENTIFIERCASE |
DBPROPVAL_IC_SENSITIVE |
R |
|
|
DBPROP_ROWSETCONVERSIONONCOMMAND |
TRUE |
R |
|
|
DBPROP_ROWSETCONVERSIONSONCOMMAND |
TRUE |
R |
|
|
DBPROP_SCHEMATERM |
DATABASE |
R |
|
|
DBPROP_SCHEMAUSAGE |
DBPROPVAL_SU_DML_STATEMENTS DBPROPVAL_SU_TABLE_DEFINITION DBPROPVAL_SU_INDEX_DEFINITION DBPROPVAL_SU_PRIVILEGE_DEFINITION |
R |
|
|
DBPROP_SERVERNAME |
Name specified in DBPROP_DATASOURCENAME |
R |
TDPID |
|
DBPROP_SQLSUPPORT |
DBPROPVAL_ODBC_MINIMUM DBPROPVAL_ODBC_CORE DBPROPVAL_SQL_ANSI89_IEF DBPROPVAL_ESCAPECLAUSES |
R |
|
|
DBPROP_STRUCTUREDSTORAGE |
DBPROPVAL_SS_SQUENTIALSTREAM |
R |
|
|
DBPROP_SUBQUERIES |
DBPROPVAL_SQ_CORRELATEDSUBQUERIES DBRPOPVAL_SQ_COMPARISON DBPROPVAL_EXISTS DBPROPVAL_SQ_QUANTIFIED |
R |
|
|
DBPROP_SUPPORTEDTXNDDL |
DBPROPVAL_TC_DML |
R |
Transaction can only contain DML. |
|
DBPROP_SUPPORTEDTXNISORETAIN |
0 |
R |
|
|
DBPROP_SUPPORTEDTXNISQLEVELS |
DBPROPVAL_TI_READUNCOMMITTED DBPROPVAL_TI_SERIALIZABLE |
R |
Type of Locking Modifier supported by Teradata. |
|
DBPROP_TABLETERM |
TABLE |
R |
|
|
DBPROP_USERNAME |
User name specified in DBPROP_AUTH_USERID |
R |
User Name |