public interface ServerDatabaseConnection
Modifier and Type | Interface and Description |
---|---|
static interface |
ServerDatabaseConnection.DBInfo
Defines basic information about the database.
|
Modifier and Type | Method and Description |
---|---|
void |
dropTable(java.lang.String tableName)
Drops the supplied table.
|
ServerDatabaseConnection.DBInfo |
getDBInfo()
Returns the database information.
|
RowSet |
getDBQueryColumns(java.lang.String queryText)
Returns a list of the columns returned by a specified database query.
|
RowSet |
getDBTableColumns(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName)
Returns a list of the columns in a specified database table.
|
RowSet |
getDBTables(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName,
boolean includeUserTables,
boolean includeSystemTables,
boolean includeViews,
boolean includeSynonyms)
Returns a summary of the tables available on this database connection
which match the specified arguments.
|
boolean |
isDBTableVisible(java.lang.String catalogName,
java.lang.String schemaName,
java.lang.String tableName)
Returns
true if the specified table is visible to this connection. |
boolean isDBTableVisible(java.lang.String catalogName, java.lang.String schemaName, java.lang.String tableName) throws ServerResourceException
true
if the specified table is visible to this connection.catalogName
- the catalog nameschemaName
- the schema nametableName
- the table nametrue
if the specified table existsServerResourceException
- if the server resource cannot be accessedRowSet getDBTables(java.lang.String catalogName, java.lang.String schemaName, java.lang.String tableName, boolean includeUserTables, boolean includeSystemTables, boolean includeViews, boolean includeSynonyms) throws ServerResourceException
catalogName
- pattern for the catalog nameschemaName
- pattern for the schema nametableName
- pattern for the table nameincludeUserTables
- indicates whether user tables should be includedincludeSystemTables
- indicates whether systemtables should be includedincludeViews
- indicates whether views should be includedincludeSynonyms
- indicates whether synonyms should be includedServerResourceException
- if the server resource cannot be accessedRowSet getDBTableColumns(java.lang.String catalogName, java.lang.String schemaName, java.lang.String tableName) throws ServerResourceException
StorageType
constants that provide the
closest match for the storage types for the columns in the database table.catalogName
- the catalog nameschemaName
- the schema nametableName
- the base table nameServerResourceException
- if the server resource cannot be accessedStorageType
RowSet getDBQueryColumns(java.lang.String queryText) throws ServerResourceException
queryText
- the text of the queryServerResourceException
- if the server resource cannot be accessedvoid dropTable(java.lang.String tableName) throws ServerResourceException
tableName
- the table to be dropped.ServerResourceException
ServerDatabaseConnection.DBInfo getDBInfo() throws ServerResourceException
ServerResourceException
(C) Copyright IBM Corp. 1994, 2015. All Rights Reserved.