Visual Cafe Pro Language Reference Method index | Bottom

Class: symantec.itools.db.pro.SessionMetaData

Purpose Returns information about a database connection.
Hierarchy java.lang.Object
|
+----symantec.itools.db.pro.SessionMetaData
Syntax public class SessionMetaData
extends Object
Description SessionMetaData returns information about a database connection.
See also Session

Method Index

Top | Bottom
allProceduresAreCallable( )
o Indicates whether or not all stored procedures can be called.
allTablesAreSelectable( )
o Indicates whether or not all database tables can be selected.
dataDefinitionCausesTransactionCommit( )
o Indicates whether or not a data definition causes a transaction commit.
dataDefinitionIgnoredInTransactions( )
o Indicates whether or not transactions ignore data definitions.
doesMaxRowSizeIncludeBlobs( )
o Indicates whether or not the maximum record size includes blobs.
getBestRowIdentifier(String, String, String, int, boolean)
o Returns a record's best identifier.
getCatalogs( )
o Returns a database's catalogs.
getCatalogSeparator( )
o Returns a database's catalog separator.
getCatalogTerm( )
o Returns a database's catalog term.
getColumnPrivileges(String, String, String, String)
o Returns a database column's privileges.
getColumns(String, String, String, String)
o Returns a database's matching columns.
getCrossReference(String, String, String, String, String, String)
o Returns a database's cross references.
getDatabaseProductName( )
o Returns a database's product name.
getDatabaseProductVersion( )
o Returns a database's version.
getDefaultTransactionIsolation( )
o Returns a default transaction isolation.
getDriverMajorVersion( )
o Returns a database driver's major version.
getDriverMinorVersion( )
o Returns a database driver's minor version.
getDriverName( )
o Returns a database driver's name.
getDriverVersion( )
o Returns a database driver's version.
getExportedKeys(String, String, String)
o Returns a database table's exported keys.
getExtraNameCharacters( )
o Returns extra name characters.
getIdentifierQuoteString( )
o Returns an identifier.
getImportedKeys(String, String, String)
o Returns a database table's imported keys.
getIndexInfo(String, String, String, boolean, boolean)
o Returns a database table's index information.
getMaxBinaryLiteralLength( )
o Returns the maximum length for a binary literal.
getMaxCatalogNameLength( )
o Returns the maximum length for a catalog name.
getMaxCharLiteralLength( )
o Returns the maximum length for a character literal.
getMaxColumnNameLength( )
o Returns the maximum length for a column name.
getMaxColumnsInGroupBy( )
o Returns the maximum number of columns in a GROUP BY clause.
getMaxColumnsInIndex( )
o Returns the maximum number of database columns in an index.
getMaxColumnsInOrderBy( )
o Returns the maximum number of database columns in an ORDER BY clause.
getMaxColumnsInSelect( )
o Returns the maximum number of database columns in a SELECT statement.
getMaxColumnsInTable( )
o Returns the maximum number of columns in a database table.
getMaxConnections( )
o Returns the maximum number of concurrent database connections.
getMaxCursorNameLength( )
o Returns the maximum length for a cursor name.
getMaxIndexLength( )
o Returns the maximum length for an index.
getMaxProcedureNameLength( )
o Returns the maximum length for a stored procedure's name.
getMaxRowSize( )
o Returns the maximum size of a record.
getMaxSchemaNameLength( )
o Returns the maximum length for a schema name.
getMaxStatementLength( )
o Returns the maximum length for a SQL statement.
getMaxStatements( )
o Returns the maximum number of SQL statements.
getMaxTableNameLength( )
o Returns the maximum length for a database table's name.
getMaxTablesInSelect( )
o Returns the maximum number of database tables in a SELECT statement.
getMaxUserNameLength( )
o Returns the maximum length for a user name.
getNumericFunctions( )
o Returns a database's numeric functions.
getPrimaryKeys(String, String, String)
o Returns a database table's primary keys.
getProcedureColumns(String, String, String, String)
o Returns a stored procedure's database columns.
getProcedures(String, String, String)
o Returns a database's stored procedures.
getProcedureTerm( )
o Returns a stored procedure's term.
getSchemas( )
o Returns a database's schemas.
getSchemaTerm( )
o Returns a database schema's term.
getSearchStringEscape( )
o Returns a search string's escape character.
getSQLKeywords( )
o Returns a database's SQL keywords.
getStringFunctions( )
o Returns a database's string functions.
getSystemFunctions( )
o Returns a database's system functions.
getTablePrivileges(String, String, String)
o Returns a database table's privileges.
getTables(String, String, String, String[])
o Returns a database's tables.
getTableTypes( )
o Returns a database's table types.
getTimeDateFunctions( )
o Returns a database's time and date functions.
getTypeInfo( )
o Returns a database's type information.
getURL( )
o Returns a dbANYWHERE Server's URL.
getUserName( )
o Returns a Session's user name.
getVersionColumns(String, String, String)
o Returns a database table's version columns.
isCatalogAtStart( )
o Indicates whether or not a database's catalog is at the start of the database.
isReadOnly( )
o Indicates whether or not a Session's data is read-only.
nullPlusNonNullIsNull( )
o Indicates whether or not NULL + a non-NULL value results in a NULL.
nullsAreSortedAtEnd( )
o Indicates whether or not NULLs are sorted at the end.
nullsAreSortedAtStart( )
o Indicates whether or not NULLs are sorted at the start.
nullsAreSortedHigh( )
o Indicates whether or not NULLs are sorted high.
nullsAreSortedLow( )
o Indicates whether or not NULLs are sorted low.
storesLowerCaseIdentifiers( )
o Indicates whether or not a database stores lower case identifiers.
storesLowerCaseQuotedIdentifiers( )
o Indicates whether or not a database stores lower case quoted identifiers.
storesMixedCaseIdentifiers( )
o Indicates whether or not a database stores mixed case identifiers.
storesMixedCaseQuotedIdentifiers( )
o Indicates whether or not a database stores mixed case quoted identifiers.
storesUpperCaseIdentifiers( )
o Indicates whether or not a database stores upper case identifiers.
storesUpperCaseQuotedIdentifiers( )
o Indicates whether or not a database stores upper case quoted identifiers.
supportsAlterTableWithAddColumn( )
o Indicates whether or not a database lets you add a column to a table.
supportsAlterTableWithDropColumn( )
o Indicates whether or not a database lets you delete a column from a table.
supportsANSI92EntryLevelSQL( )
o Indicates whether or not a database supports ANSI 92 entry level SQL.
supportsANSI92FullSQL( )
o Indicates whether or not a database supports ANSI 92 full SQL.
supportsANSI92IntermediateSQL( )
o Indicates whether or not a database supports ANSI 92 intermediate SQL.
supportsCatalogsInDataManipulation( )
o Indicates whether or not a database updates its catalogs when you manipulate its data.
supportsCatalogsInIndexDefinitions( )
o Indicates whether or not a database updates its catalogs when you define an index.
supportsCatalogsInPrivilegeDefinitions( )
o Indicates whether or not a database updates its catalogs when you define a privilege.
supportsCatalogsInProcedureCalls( )
o Indicates whether or not a database updates its catalogs when you call a stored procedure.
supportsCatalogsInTableDefinitions( )
o Indicates whether or not a database updates its catalogs when you define a table.
supportsColumnAliasing( )
o Indicates whether or not a database supports aliases for columns.
supportsConvert
o Indicates whether or not a database supports conversions from one specified data type to another specified data type.
o Syntaxes:
supportsConvert( )
supportsConvert(int, int)
supportsCoreSQLGrammar( )
o Indicates whether or not a database supports core SQL grammar.
supportsCorrelatedSubqueries( )
o Indicates whether or not a database supports correlated subqueries.
supportsDataDefinitionAndDataManipulationTransactions( )
o Indicates whether or not a database supports data definition and data manipulation transactions.
supportsDataManipulationTransactionsOnly( )
o Indicates whether or not a database supports data manipulation transactions only.
supportsDifferentTableCorrelationNames( )
o Indicates whether or not a database supports different table correlation names.
supportsExpressionsInOrderBy( )
o Indicates whether or not a database supports expression in ORDER BY clauses.
supportsExtendedSQLGrammar( )
o Indicates whether or not a database supports extended SQL grammar.
supportsFullOuterJoins( )
o Indicates whether or not a database supports full outer joins.
supportsGroupBy( )
o Indicates whether or not a database supports GROUP BY clauses.
supportsGroupByBeyondSelect( )
o Indicates whether or not a database supports GROUP BY clauses in SQL statements that are not SELECT statements.
supportsGroupByUnrelated( )
o Indicates whether or not a database supports GROUP BY clauses that have unrelated elements.
supportsIntegrityEnhancementFacility( )
o Indicates whether or not a database supports an integrity enhancement facility.
supportsLikeEscapeClause( )
o Indicates whether or not a database supports the "like" escape clause.
supportsLimitedOuterJoins( )
o Indicates whether or not a database supports limited outer joins.
supportsMinimumSQLGrammar( )
o Indicates whether or not a database supports minimum SQL grammar.
supportsMixedCaseIdentifiers( )
o Indicates whether or not a database supports mixed case identifiers.
supportsMixedCaseQuotedIdentifiers( )
o Indicates whether or not a database supports mixed case quoted identifiers.
supportsMultipleResultSets( )
o Indicates whether or not a database supports multiple result sets.
supportsMultipleTransactions( )
o Indicates whether or not a database supports multiple transactions.
supportsNonNullableColumns( )
o Indicates whether or not a database supports non-NULLable columns.
supportsOpenCursorsAcrossCommit( )
o Indicates whether or not a database supports open cursors across a commit.
supportsOpenCursorsAcrossRollback( )
o Indicates whether or not a database supports open cursors across a rollback.
supportsOpenStatementsAcrossCommit( )
o Indicates whether or not a database supports open SQL statements across a commit.
supportsOpenStatementsAcrossRollback( )
o Indicates whether or not a database supports open SQL statements across a rollback.
supportsOrderByUnrelated( )
o Indicates whether or not a database supports ORDER BY clauses with unrelated elements.
supportsOuterJoins( )
o Indicates whether or not a database supports outer joins.
supportsPositionedDelete( )
o Indicates whether or not a database supports positioned deletes.
supportsPositionedUpdate( )
o Indicates whether or not a database supports positioned updates.
supportsSchemasInDataManipulation( )
o Indicates whether or not a database updates its schemas when you manipulate its data.
supportsSchemasInIndexDefinitions( )
o Indicates whether or not a database updates its schemas when you define an index.
supportsSchemasInPrivilegeDefinitions( )
o Indicates whether or not a database updates its schemas when you define a privilege.
supportsSchemasInProcedureCalls( )
o Indicates whether or not a database updates its schemas when you call a stored procedure.
supportsSchemasInTableDefinitions( )
o Indicates whether or not a database updates its schemas when you define a table.
supportsSelectForUpdate( )
o Indicates whether or not a database supports "select for" updates.
supportsStoredProcedures( )
o Indicates whether or not a database supports stored procedures.
supportsSubqueriesInComparisons( )
o Indicates whether or not a database supports subqueries in comparisons.
supportsSubqueriesInExists( )
o Indicates whether or not a database supports subqueries in "exist"s.
supportsSubqueriesInIns( )
o Indicates whether or not a database supports subqueries in "in"s.
supportsSubqueriesInQuantifieds( )
o Indicates whether or not a database supports subqueries in "quantified"s.
supportsTableCorrelationNames( )
o Indicates whether or not a database supports table correlation names.
supportsTransactionIsolationLevel(int)
o Indicates whether or not a database supports a transaction isolation level.
supportsTransactions( )
o Indicates whether or not a database lets you perform a transaction.
supportsUnion( )
o Indicates whether or not a database supports UNION statements.
supportsUnionAll( )
o Indicates whether or not a database supports UNION ALL statements.
usesLocalFilePerTable( )
o Indicates whether or not a database uses a local file for each table.
usesLocalFiles( )
o Indicates whether or not a database uses local files.

Methods

Method index | Top | Bottom

Method: allProceduresAreCallable

Purpose Indicates whether or not all stored procedures can be called.
Syntax public boolean allProceduresAreCallable( )
Parameters None.
Description Indicates whether or not all procedures can be called.

Method: allTablesAreSelectable

Purpose Indicates whether or not all database tables can be selected.
Syntax public boolean allTablesAreSelectable( )
Parameters None.
Description Indicates whether or not all tables can be selected.

Method: dataDefinitionCausesTransactionCommit

Purpose Indicates whether or not a data definition causes a transaction commit.
Syntax public boolean dataDefinitionCausesTransactionCommit( )
Parameters None.
Description Indicates whether or not a data definition causes a transaction commit.

Method: dataDefinitionIgnoredInTransactions

Purpose Indicates whether or not transactions ignore data definitions.
Syntax public boolean dataDefinitionIgnoredInTransactions( )
Parameters None.
Description Indicates whether or not transactions ignore data definitions.

Method: doesMaxRowSizeIncludeBlobs

Purpose Indicates whether or not the maximum record size includes blobs.
Syntax public boolean doesMaxRowSizeIncludeBlobs( )
Parameters None.
Description Indicates whether or not the maximum row size includes blobs.

Method: getBestRowIdentifier

Purpose Returns a record's best identifier.
Syntax public RelationView getBestRowIdentifier(String catalog,
String schema,
String table,
int scope,
boolean nullable) throws SQLException
Parameters catalog =

schema =

table =

scope =

nullable =

Description Returns the best row identifier for a RelationView.

Method: getCatalogs

Purpose Returns a database's catalogs.
Syntax public RelationView getCatalogs( ) throws SQLException
Parameters None.
Description Returns a database's catalogs.

Method: getCatalogSeparator

Purpose Returns a database's catalog separator.
Syntax public String getCatalogSeparator( )
Parameters None.
Description Returns a catalog separator.

Method: getCatalogTerm

Purpose Returns a database's catalog term.
Syntax public String getCatalogTerm( )
Parameters None.
Description Returns a catalog term.

Method: getColumnPrivileges

Purpose Returns a database column's privileges.
Syntax public RelationView getColumnPrivileges(String catalog,
String schema,
String table,
String columnNamePattern) throws SQLException
Parameters catalog =

schema =

table =

columnNamePattern =

Description Returns a database column's privileges.

Method: getColumns

Purpose Returns a database's matching columns.
Syntax public RelationView getColumns(String catalog,
String schemaPattern,
String tableNamePattern,
String columnNamePattern) throws SQLException
Parameters catalog = Catalog name to match.

schemaPattern = Pattern for schema names to match.

tableNamePattern = Pattern for table names to match.

columnNamePattern = Pattern for columns names to match.

Description Returns a RelationView with a row for each matching column in the database. The RelationView has the following columns:
Column Data type Description
1 String Table catalog (may be NULL).
2 String Table schema.
3 String Table name.
4 String Column name.
5 short SQL type from symjava.sql.Types.
6 String SQL type name.
7 int Column size. For char or date types this is the maximum number of characters, for numeric or decimal types this is precision.
8 N/A Not used.
9 int Scale.
10 int Radix (typically either 10 or 2).
11 boolean Flag indicating whether or not the value can be NULL.
12 String Column description. May be NULL.
13 String Default value. May be NULL.
14 N/A Not used.
15 int Maximum number of bytes for char types. May be NULL.
16 int Index of column in table (starting at 1). May be NULL.
17 String Flag indicating whether or not the column is known not to be nullable. "NO" means that the column is known not to be nullable. "YES" means otherwise. May be NULL.

The rows are sorted by columns 1, 2, and 3.

Method: getCrossReference

Purpose Returns a database's cross references.
Syntax public RelationView getCrossReference(String primaryCatalog,
String primarySchema,
String primaryTable,
String foreignCatalog,
String foreignSchema,
String foreignTable) throws SQLException
Parameters primaryCatalog =

primarySchema =

primaryTable =

foreignCatalog =

foreignSchema =

foreignTable =

Description Returns a database's cross references.

Method: getDatabaseProductName

Purpose Returns a database's product name.
Syntax public String getDatabaseProductName( )
Parameters None.
Description Returns the database product name.

Method: getDatabaseProductVersion

Purpose Returns a database's version.
Syntax public String getDatabaseProductVersion( )
Parameters None.
Description Returns the database version.

Method: getDefaultTransactionIsolation

Purpose Returns a default transaction isolation.
Syntax public int getDefaultTransactionIsolation( )
Parameters None.
Description Returns the default transaction isolation.

Method: getDriverMajorVersion

Purpose Returns a database driver's major version.
Syntax public int getDriverMajorVersion( )
Parameters None.
Description Returns the driver major version.

Method: getDriverMinorVersion

Purpose Returns a database driver's minor version.
Syntax public int getDriverMinorVersion( )
Parameters None.
Description Returns the driver minor version.

Method: getDriverName

Purpose Returns a database driver's name.
Syntax public String getDriverName( )
Parameters None.
Description Returns the driver name.

Method: getDriverVersion

Purpose Returns a database driver's version.
Syntax public String getDriverVersion( )
Parameters None.
Description Returns the driver version.

Method: getExportedKeys

Purpose Returns a database table's exported keys.
Syntax public RelationView getExportedKeys(String catalog,
String schema,
String table) throws SQLException
Parameters catalog =

schema =

table =

Description Returns a database table's exported keys.

Method: getExtraNameCharacters

Purpose Returns extra name characters.
Syntax public String getExtraNameCharacters( )
Parameters None.
Description Returns extra name characters.

Method: getIdentifierQuoteString

Purpose Returns an identifier.
Syntax public String getIdentifierQuoteString( )
Parameters None.
Description Returns an identifier.

Method: getImportedKeys

Purpose Returns a database table's imported keys.
Syntax public RelationView getImportedKeys(String catalog,
String schema,
String table) throws SQLException
Parameters catalog =

schema =

table =

Description Returns a database table's imported keys.

Method: getIndexInfo

Purpose Returns a database table's index information.
Syntax public RelationView getIndexInfo(String catalog,
String schema,
String table,
boolean unique,
boolean approximate) throws SQLException
Parameters catalog =

schema =

table =

unique =

approximate =

Description Returns a database table's index information.

Method: getMaxBinaryLiteralLength

Purpose Returns the maximum length for a binary literal.
Syntax public int getMaxBinaryLiteralLength( )
Parameters None.
Description Returns the maximum length for binary literals.

Method: getMaxCatalogNameLength

Purpose Returns the maximum length for a catalog name.
Syntax public int getMaxCatalogNameLength( )
Parameters None.
Description Returns the maximum length for a catalog name.

Method: getMaxCharLiteralLength

Purpose Returns the maximum length for a character literal.
Syntax public int getMaxCharLiteralLength( )
Parameters None.
Description Returns the maximum length for character literals.

Method: getMaxColumnNameLength

Purpose Returns the maximum length for a column name.
Syntax public int getMaxColumnNameLength( )
Parameters None.
Description Returns the maximum length for column names.

Method: getMaxColumnsInGroupBy

Purpose Returns the maximum number of columns in a GROUP BY clause.
Syntax public int getMaxColumnsInGroupBy( )
Parameters None.
Description Returns the maximum number of columns that can be in a GROUP BY clause in a SQL statement.

Method: getMaxColumnsInIndex

Purpose Returns the maximum number of database columns in an index.
Syntax public int getMaxColumnsInIndex( )
Parameters None.
Description Returns the maximum number of columns that can be in an index.

Method: getMaxColumnsInOrderBy

Purpose Returns the maximum number of database columns in an ORDER BY clause.
Syntax public int getMaxColumnsInOrderBy( )
Parameters None.
Description Returns the maximum number of columns that can be in an ORDER BY clause in a SQL statement.

Method: getMaxColumnsInSelect

Purpose Returns the maximum number of database columns in a SELECT statement.
Syntax public int getMaxColumnsInSelect( )
Parameters None.
Description Returns the maximum number of columns that can be in a SELECT statement.

Method: getMaxColumnsInTable

Purpose Returns the maximum number of columns in a database table.
Syntax public int getMaxColumnsInTable( )
Parameters None.
Description Returns the maximum number of columns that can be in a database table.

Method: getMaxConnections

Purpose Returns the maximum number of concurrent database connections.
Syntax public int getMaxConnections( )
Parameters None.
Description Returns the maximum number of concurrent connections the database supports.

Method: getMaxCursorNameLength

Purpose Returns the maximum length for a cursor name.
Syntax public int getMaxCursorNameLength( )
Parameters None.
Description Returns the maximum length for the database cursor name.

Method: getMaxIndexLength

Purpose Returns the maximum length for an index.
Syntax public int getMaxIndexLength( )
Parameters None.
Description Returns the maximum length allowed for an index.

Method: getMaxProcedureNameLength

Purpose Returns the maximum length for a stored procedure's name.
Syntax public int getMaxProcedureNameLength( )
Parameters None.
Description Returns the maximum length for a procedure name.

Method: getMaxRowSize

Purpose Returns the maximum size of a record.
Syntax public int getMaxRowSize( )
Parameters None.
Description Returns the maximum row size.

Method: getMaxSchemaNameLength

Purpose Returns the maximum length for a schema name.
Syntax public int getMaxSchemaNameLength( )
Parameters None.
Description Returns the maximum length for a schema name.

Method: getMaxStatementLength

Purpose Returns the maximum length for a SQL statement.
Syntax public int getMaxStatementLength( )
Parameters None.
Description Returns the maximum statement length.

Method: getMaxStatements

Purpose Returns the maximum number of SQL statements.
Syntax public int getMaxStatements( )
Parameters None.
Description Returns the maximum number of statements.

Method: getMaxTableNameLength

Purpose Returns the maximum length for a database table's name.
Syntax public int getMaxTableNameLength( )
Parameters None.
Description Returns the maximum length for a database table name.

Method: getMaxTablesInSelect

Purpose Returns the maximum number of database tables in a SELECT statement.
Syntax public int getMaxTablesInSelect( )
Parameters None.
Description Returns the maximum number of tables that can be in a SELECT statement.

Method: getMaxUserNameLength

Purpose Returns the maximum length for a user name.
Syntax public int getMaxUserNameLength( )
Parameters None.
Description Returns the maximum length for a user name.

Method: getNumericFunctions

Purpose Returns a database's numeric functions.
Syntax public String getNumericFunctions( ) throws SQLException
Parameters None.
Description Returns a comma-delimited list of all numeric functions supported by the database engine.

Method: getPrimaryKeys

Purpose Returns a database table's primary keys.
Syntax public RelationView getPrimaryKeys(String catalog,
String schema,
String table) throws SQLException
Parameters catalog =

schema =

table =

Description Returns a database table's primary keys.

Method: getProcedureColumns

Purpose Returns a stored procedure's database columns.
Syntax public RelationView getProcedureColumns(String catalog,
String schemaPattern,
String procedureNamePattern,
String columnNamePattern) throws SQLException
Parameters catalog =

schemaPattern =

procedureNamePattern =

columnNamePattern =

Description

Method: getProcedures

Purpose Returns a database's stored procedures.
Syntax public RelationView getProcedures(String catalog,
String schemaPattern,
String procedureNamePattern) throws SQLException
Parameters catalog =

schemaPattern =

procedureNamePattern =

Description Returns a database's stored procedures.

Method: getProcedureTerm

Purpose Returns a stored procedure's term.
Syntax public String getProcedureTerm( )
Parameters None.
Description Returns a procedure term.

Method: getSchemas

Purpose Returns a database's schemas.
Syntax public RelationView getSchemas( ) throws SQLException
Parameters None.
Description Returns a database's schemas.

Method: getSchemaTerm

Purpose Returns a database schema's term.
Syntax public String getSchemaTerm( )
Parameters None.
Description Returns a schema term.

Method: getSearchStringEscape

Purpose Returns a search string's escape character.
Syntax public String getSearchStringEscape( )
Parameters None.
Description

Method: getSQLKeywords

Purpose Returns a database's SQL keywords.
Syntax public String getSQLKeywords( ) throws SQLException
Parameters None.
Description Returns a comma-delimited list of all database-specific SQL keywords.Return a String containing a comma-delimited list of non-standard SQL keywords supported by the database engine.

Method: getStringFunctions

Purpose Returns a database's string functions.
Syntax public String getStringFunctions( ) throws SQLException
Parameters None.
Description Returns a comma-delimited list of all string functions. Return a String containing a comma-delimited list of string functions supported by the database engine.

Method: getSystemFunctions

Purpose Returns a database's system functions.
Syntax public String getSystemFunctions( ) throws SQLException
Parameters None.
Description Returns a comma-delimited list of all system functions. Return a String containing a comma-delimited list of system functions supported by the database engine.

Method: getTablePrivileges

Purpose Returns a database table's privileges.
Syntax public RelationView getTablePrivileges(String catalog,
String schemaPattern,
String tableNamePattern) throws SQLException
Parameters catalog =

schemaPattern =

tableNamePattern =

Description Returns a database table's privileges.

Method: getTables

Purpose Returns a database's tables.
Syntax public RelationView getTables(String catalog,
String schemaPattern,
String tableNamePattern,
String types[ ]) throws SQLException
Parameters catalog = Catalog name to match.

schemaPattern = Pattern for schema names to match.

tableNamePattern = Pattern for table names to match.

types[ ] = Table types to match. Can be NULL.

Description Returns a RelationView with a row for each matching table in the database. The RelationView has the following columns:
Column Data type Description
1 String Table catalog (may be NULL).
2 String Table schema.
3 String Table name.
4 String Table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".
5 String Table description.

The results are sorted by columns 4, 1, 2, and 3.

Method: getTableTypes

Purpose Returns a database's table types.
Syntax public RelationView getTableTypes( ) throws SQLException
Parameters None.
Description Returns a database's table types.

Method: getTimeDateFunctions

Purpose Returns a database's time and date functions.
Syntax public String getTimeDateFunctions( ) throws SQLException
Parameters None.
Description Returns a comma-delimited list of all TimeDate functions. Return a String containing a comma-delimited list of TimeDate functions supported by the database engine.

Method: getTypeInfo

Purpose Returns a database's type information.
Syntax public RelationView getTypeInfo( ) throws SQLException
Parameters None.
Description Returns a database's type information.

Method: getURL

Purpose Returns a dbANYWHERE Server's URL.
Syntax public String getURL( ) throws SQLException
Parameters None.
Description Returns a URL.

Method: getUserName

Purpose Returns a Session's user name.
Syntax public String getUserName( )
Parameters None.
Description Returns a user name.

Method: getVersionColumns

Purpose Returns a database table's version columns.
Syntax public RelationView getVersionColumns(String catalog,
String schema,
String table) throws SQLException
Parameters catalog =

schema =

table =

Description

Method: isCatalogAtStart

Purpose Indicates whether or not a database's catalog is at the start of the database.
Syntax public boolean isCatalogAtStart( )
Parameters None.
Description Indicates whether or not the catalog is at the start.

Method: isReadOnly

Purpose Indicates whether or not a Session's data is read-only.
Syntax public boolean isReadOnly( )
Parameters None.
Description Indicates whether or not the session's data is read only.

Method: nullPlusNonNullIsNull

Purpose Indicates whether or not NULL + a non-NULL value results in a NULL.
Syntax public boolean nullPlusNonNullIsNull( )
Parameters None.
Description Indicates whether or not NULL plus non-NULL is NULL.

Method: nullsAreSortedAtEnd

Purpose Indicates whether or not NULLs are sorted at the end.
Syntax public boolean nullsAreSortedAtEnd( )
Parameters None.
Description Indicates whether or not the NULLs are sorted at end.

Method: nullsAreSortedAtStart

Purpose Indicates whether or not NULLs are sorted at the start.
Syntax public boolean nullsAreSortedAtStart( )
Parameters None.
Description Indicates whether or not the NULLs are sorted at start.

Method: nullsAreSortedHigh

Purpose Indicates whether or not NULLs are sorted high.
Syntax public boolean nullsAreSortedHigh( )
Parameters None.
Description Indicates whether or not the NULLs are sorted high.

Method: nullsAreSortedLow

Purpose Indicates whether or not NULLs are sorted low.
Syntax public boolean nullsAreSortedLow( )
Parameters None.
Description Indicates whether or not the NULLs are sorted low.

Method: storesLowerCaseIdentifiers

Purpose Indicates whether or not a database stores lower case identifiers.
Syntax public boolean storesLowerCaseIdentifiers( )
Parameters None.
Description Indicates whether or not the database stores lower case identifiers.

Method: storesLowerCaseQuotedIdentifiers

Purpose Indicates whether or not a database stores lower case quoted identifiers.
Syntax public boolean storesLowerCaseQuotedIdentifiers( )
Parameters None.
Description Indicates whether or not the database stores lower case quoted identifiers.

Method: storesMixedCaseIdentifiers

Purpose Indicates whether or not a database stores mixed case identifiers.
Syntax public boolean storesMixedCaseIdentifiers( )
Parameters None.
Description Indicates whether or not the database stores mixed case identifiers.

Method: storesMixedCaseQuotedIdentifiers

Purpose Indicates whether or not a database stores mixed case quoted identifiers.
Syntax public boolean storesMixedCaseQuotedIdentifiers( )
Parameters None.
Description Indicates whether or not the database stores mixed case quoted identifiers.

Method: storesUpperCaseIdentifiers

Purpose Indicates whether or not a database stores upper case identifiers.
Syntax public boolean storesUpperCaseIdentifiers( )
Parameters None.
Description Indicates whether or not the database stores upper case identifiers.

Method: storesUpperCaseQuotedIdentifiers

Purpose Indicates whether or not a database stores upper case quoted identifiers.
Syntax public boolean storesUpperCaseQuotedIdentifiers( )
Parameters None.
Description Indicates whether or not the database stores upper case quoted identifiers.

Method: supportsAlterTableWithAddColumn

Purpose Indicates whether or not a database lets you add a column to a table.
Syntax public boolean supportsAlterTableWithAddColumn( )
Parameters None.
Description Indicates whether or not the database supports an alter table with an add column.

Method: supportsAlterTableWithDropColumn

Purpose Indicates whether or not a database lets you delete a column from a table.
Syntax public boolean supportsAlterTableWithDropColumn( )
Parameters None.
Description Indicates whether or not the database supports an alter table with a drop column.

Method: supportsANSI92EntryLevelSQL

Purpose Indicates whether or not a database supports ANSI 92 entry level SQL.
Syntax public boolean supportsANSI92EntryLevelSQL( )
Parameters None.
Description Indicates whether or not the database supports ANSI 92 entry level SQL.

Method: supportsANSI92FullSQL

Purpose Indicates whether or not a database supports ANSI 92 full SQL.
Syntax public boolean supportsANSI92FullSQL( )
Parameters None.
Description Indicates whether or not the database supports ANSI 92 full SQL.

Method: supportsANSI92IntermediateSQL

Purpose Indicates whether or not a database supports ANSI 92 intermediate SQL.
Syntax public boolean supportsANSI92IntermediateSQL( )
Parameters None.
Description Indicates whether or not the database supports ANSI 92 intermediate SQL.

Method: supportsCatalogsInDataManipulation

Purpose Indicates whether or not a database updates its catalogs when you manipulate its data.
Syntax public boolean supportsCatalogsInDataManipulation( )
Parameters None.
Description Indicates whether or not a database supports catalogs in data manipulation.

Method: supportsCatalogsInIndexDefinitions

Purpose Indicates whether or not a database updates its catalogs when you define an index.
Syntax public boolean supportsCatalogsInIndexDefinitions( )
Parameters None.
Description Indicates whether or not a database supports catalogs in index definitions.

Method: supportsCatalogsInPrivilegeDefinitions

Purpose Indicates whether or not a database updates its catalogs when you define a privilege.
Syntax public boolean supportsCatalogsInPrivilegeDefinitions( )
Parameters None.
Description Indicates whether or not a database supports catalogs in privilege definitions.

Method: supportsCatalogsInProcedureCalls

Purpose Indicates whether or not a database updates its catalogs when you call a stored procedure.
Syntax public boolean supportsCatalogsInProcedureCalls( )
Parameters None.
Description Indicates whether or not a database supports catalogs in procedure calls.

Method: supportsCatalogsInTableDefinitions

Purpose Indicates whether or not a database updates its catalogs when you define a table.
Syntax public boolean supportsCatalogsInTableDefinitions( )
Parameters None.
Description Indicates whether or not a database supports catalogs in table definitions.

Method: supportsColumnAliasing

Purpose Indicates whether or not a database supports aliases for columns.
Syntax public boolean supportsColumnAliasing( )
Parameters None.
Description Indicates whether or not the database supports column aliasing.

Method: supportsConvert

Purpose Indicates whether or not a database supports conversions from one specified data type to another specified data type.
Syntax public boolean supportsConvert( ) throws SQLException
public boolean supportsConvert(int fromType,
int toType) throws SQLException
Parameters fromType =

toType =

Description Indicates whether or not the database supports conversions from a fromType value to a toType value.

Method: supportsCoreSQLGrammar

Purpose Indicates whether or not a database supports core SQL grammar.
Syntax public boolean supportsCoreSQLGrammar( )
Parameters None.
Description Indicates whether or not a database supports core SQL grammar.

Method: supportsCorrelatedSubqueries

Purpose Indicates whether or not a database supports correlated subqueries.
Syntax public boolean supportsCorrelatedSubqueries( )
Parameters None.
Description Indicates whether or not a database supports correlated subqueries.

Method: supportsDataDefinitionAndDataManipulationTransactions

Purpose Indicates whether or not a database supports data definition and data manipulation transactions.
Syntax public boolean supportsDataDefinitionAndDataManipulationTransactions( )
Parameters None.
Description Indicates whether or not a database supports data definition and data manipulation transactions.

Method: supportsDataManipulationTransactionsOnly

Purpose Indicates whether or not a database supports data manipulation transactions only.
Syntax public boolean supportsDataManipulationTransactionsOnly( )
Parameters None.
Description Indicates whether or not a database supports only data manipulation transactions.

Method: supportsDifferentTableCorrelationNames

Purpose Indicates whether or not a database supports different table correlation names.
Syntax public boolean supportsDifferentTableCorrelationNames( )
Parameters None.
Description Indicates whether or not the database supports different table correlation names.

Method: supportsExpressionsInOrderBy

Purpose Indicates whether or not a database supports expression in ORDER BY clauses.
Syntax public boolean supportsExpressionsInOrderBy( )
Parameters None.
Description Indicates whether or not the database supports expression in the SQL statement's ORDER BY clause.

Method: supportsExtendedSQLGrammar

Purpose Indicates whether or not a database supports extended SQL grammar.
Syntax public boolean supportsExtendedSQLGrammar( )
Parameters None.
Description Indicates whether or not a database supports extended SQL grammar.

Method: supportsFullOuterJoins

Purpose Indicates whether or not a database supports full outer joins.
Syntax public boolean supportsFullOuterJoins( )
Parameters None.
Description Indicates whether or not the database supports full outer joins.

Method: supportsGroupBy

Purpose Indicates whether or not a database supports GROUP BY clauses.
Syntax public boolean supportsGroupBy( )
Parameters None.
Description Indicates whether or not the database supports the GROUP BY clause in the SQL statement.

Method: supportsGroupByBeyondSelect

Purpose Indicates whether or not a database supports GROUP BY clauses in SQL statements that are not SELECT statements.
Syntax public boolean supportsGroupByBeyondSelect( )
Parameters None.
Description

Method: supportsGroupByUnrelated

Purpose Indicates whether or not a database supports GROUP BY clauses that have unrelated elements.
Syntax public boolean supportsGroupByUnrelated( )
Parameters None.
Description

Method: supportsIntegrityEnhancementFacility

Purpose Indicates whether or not a database supports an integrity enhancement facility.
Syntax public boolean supportsIntegrityEnhancementFacility( )
Parameters None.
Description Indicates whether or not a database supports an integrity enhancement facility.

Method: supportsLikeEscapeClause

Purpose Indicates whether or not a database supports the "like" escape clause.
Syntax public boolean supportsLikeEscapeClause( )
Parameters None.
Description

Method: supportsLimitedOuterJoins

Purpose Indicates whether or not a database supports limited outer joins.
Syntax public boolean supportsLimitedOuterJoins( )
Parameters None.
Description Indicates whether or not the database supports limited outer joins.

Method: supportsMinimumSQLGrammar

Purpose Indicates whether or not a database supports minimum SQL grammar.
Syntax public boolean supportsMinimumSQLGrammar( )
Parameters None.
Description Indicates whether or not a database supports minimum SQL grammar.

Method: supportsMixedCaseIdentifiers

Purpose Indicates whether or not a database supports mixed case identifiers.
Syntax public boolean supportsMixedCaseIdentifiers( )
Parameters None.
Description Indicates whether or not the database supports mixed case identifiers.

Method: supportsMixedCaseQuotedIdentifiers

Purpose Indicates whether or not a database supports mixed case quoted identifiers.
Syntax public boolean supportsMixedCaseQuotedIdentifiers( )
Parameters None.
Description Indicates whether or not the database supports mixed case quoted identifiers.

Method: supportsMultipleResultSets

Purpose Indicates whether or not a database supports multiple result sets.
Syntax public boolean supportsMultipleResultSets( )
Parameters None.
Description Indicates whether or not the database supports multiple result sets.

Method: supportsMultipleTransactions

Purpose Indicates whether or not a database supports multiple transactions.
Syntax public boolean supportsMultipleTransactions( )
Parameters None.
Description Indicates whether or not the database supports multiple transactions.

Method: supportsNonNullableColumns

Purpose Indicates whether or not a database supports non-NULLable columns.
Syntax public boolean supportsNonNullableColumns( )
Parameters None.
Description Indicates whether or not the database supports non-NULLable columns.

Method: supportsOpenCursorsAcrossCommit

Purpose Indicates whether or not a database supports open cursors across a commit.
Syntax public boolean supportsOpenCursorsAcrossCommit( )
Parameters None.
Description Indicates whether or not the database supports open cursors across a commit.

Method: supportsOpenCursorsAcrossRollback

Purpose Indicates whether or not a database supports open cursors across a rollback.
Syntax public boolean supportsOpenCursorsAcrossRollback( )
Parameters None.
Description Indicates whether or not the database supports open cursors across a rollback.

Method: supportsOpenStatementsAcrossCommit

Purpose Indicates whether or not a database supports open SQL statements across a commit.
Syntax public boolean supportsOpenStatementsAcrossCommit( )
Parameters None.
Description Indicates whether or not the database supports open statements across a commit.

Method: supportsOpenStatementsAcrossRollback

Purpose Indicates whether or not a database supports open SQL statements across a rollback.
Syntax public boolean supportsOpenStatementsAcrossRollback( )
Parameters None.
Description Indicates whether or not a database supports open statements across a rollback.

Method: supportsOrderByUnrelated

Purpose Indicates whether or not a database supports ORDER BY clauses with unrelated elements.
Syntax public boolean supportsOrderByUnrelated( )
Parameters None.
Description

Method: supportsOuterJoins

Purpose Indicates whether or not a database supports outer joins.
Syntax public boolean supportsOuterJoins( )
Parameters None.
Description Indicates whether or not the database supports outer joins.

Method: supportsPositionedDelete

Purpose Indicates whether or not a database supports positioned deletes.
Syntax public boolean supportsPositionedDelete( )
Parameters None.
Description Indicates whether or not a database supports a positioned delete.

Method: supportsPositionedUpdate

Purpose Indicates whether or not a database supports positioned updates.
Syntax public boolean supportsPositionedUpdate( )
Parameters None.
Description Indicates whether or not a database supports a positioned update.

Method: supportsSchemasInDataManipulation

Purpose Indicates whether or not a database updates its schemas when you manipulate its data.
Syntax public boolean supportsSchemasInDataManipulation( )
Parameters None.
Description Indicates whether or not a database supports schemas in data manipulation.

Method: supportsSchemasInIndexDefinitions

Purpose Indicates whether or not a database updates its schemas when you define an index.
Syntax public boolean supportsSchemasInIndexDefinitions( )
Parameters None.
Description Indicates whether or not a database supports schemas in index definitions.

Method: supportsSchemasInPrivilegeDefinitions

Purpose Indicates whether or not a database updates its schemas when you define a privilege.
Syntax public boolean supportsSchemasInPrivilegeDefinitions( )
Parameters None.
Description Indicates whether or not a database supports schemas in privilege definitions.

Method: supportsSchemasInProcedureCalls

Purpose Indicates whether or not a database updates its schemas when you call a stored procedure.
Syntax public boolean supportsSchemasInProcedureCalls( )
Parameters None.
Description Indicates whether or not a database supports schemas in procedure calls.

Method: supportsSchemasInTableDefinitions

Purpose Indicates whether or not a database updates its schemas when you define a table.
Syntax public boolean supportsSchemasInTableDefinitions( )
Parameters None.
Description Indicates whether or not a database supports schemas in table definitions.

Method: supportsSelectForUpdate

Purpose Indicates whether or not a database supports "select for" updates.
Syntax public boolean supportsSelectForUpdate( )
Parameters None.
Description

Method: supportsStoredProcedures

Purpose Indicates whether or not a database supports stored procedures.
Syntax public boolean supportsStoredProcedures( )
Parameters None.
Description Indicates whether or not the database supports stored procedures.

Method: supportsSubqueriesInComparisons

Purpose Indicates whether or not a database supports subqueries in comparisons.
Syntax public boolean supportsSubqueriesInComparisons( )
Parameters None.
Description Indicates whether or not a database supports subqueries in comparisons.

Method: supportsSubqueriesInExists

Purpose Indicates whether or not a database supports subqueries in "exist"s.
Syntax public boolean supportsSubqueriesInExists( )
Parameters None.
Description

Method: supportsSubqueriesInIns

Purpose Indicates whether or not a database supports subqueries in "in"s.
Syntax public boolean supportsSubqueriesInIns( )
Parameters None.
Description

Method: supportsSubqueriesInQuantifieds

Purpose Indicates whether or not a database supports subqueries in "quantified"s.
Syntax public boolean supportsSubqueriesInQuantifieds( )
Parameters None.
Description

Method: supportsTableCorrelationNames

Purpose Indicates whether or not a database supports table correlation names.
Syntax public boolean supportsTableCorrelationNames( )
Parameters None.
Description Indicates whether or not the database supports table correlation names.

Method: supportsTransactionIsolationLevel

Purpose Indicates whether or not a database supports a transaction isolation level.
Syntax public boolean supportsTransactionIsolationLevel(int level) throws SQLException
Parameters level =
Description Indicates whether or not the database supports a transaction isolation level.

Method: supportsTransactions

Purpose Indicates whether or not a database lets you perform a transaction.
Syntax public boolean supportsTransactions( )
Parameters None.
Description Indicates whether or not a database supports transactions.

Method: supportsUnion

Purpose Indicates whether or not a database supports UNION statements.
Syntax public boolean supportsUnion( )
Parameters None.
Description Indicates whether or not a database supports unions.

Method: supportsUnionAll

Purpose Indicates whether or not a database supports UNION ALL statements.
Syntax public boolean supportsUnionAll( )
Parameters None.
Description Indicates whether or not a database supports union all.

Method: usesLocalFilePerTable

Purpose Indicates whether or not a database uses a local file for each table.
Syntax public boolean usesLocalFilePerTable( )
Parameters None.
Description Indicates whether or not the database uses a local file for each table.

Method: usesLocalFiles

Purpose Indicates whether or not a database uses local files.
Syntax public boolean usesLocalFiles( )
Parameters None.
Description Indicates whether or not the database uses local files.
Method index | Top

Copyright © 1996 Symantec Corporation. All rights reserved.