User`s guide

6 Using Database Toolbox Functions
6-70
Retrieving Object Properties Using the get Function
In this section...
“Database Connection Objects” on page 6-70
“Cursor Objects” on page 6-71
“Driver Objects” on page 6-72
“Database Metadata Objects” on page 6-72
“Drivermanager Objects” on page 6-73
“Resultset Objects” on page 6-73
“Resultset Metadata Objects” on page 6-73
Database Connection Objects
Allowable property names and returned values for database connection objects appear in
the following table.
Property Value
'AutoCommit' Status of the AutoCommit flag. It is either on or off, as
specified by set.
'Catalog' Name of the catalog in the data source. You might need
to extract a single catalog name from 'Catalog' for
functions such as columns, which accept only a single
catalog.
'Driver' Driver used for a JDBC connection, as specified by
database.
'Handle' Identifies a JDBC connection object.
'Instance' Name of the data source for an ODBC connection or the
name of a database for a JDBC connection, as specified by
database.
'Message' Error message returned by database.
'ReadOnly' 1 if the database is read only; 0 if the database is writable.
'TimeOut' Value for LoginTimeout.
'TransactionIsolation' Value of the current transaction isolation mode.