All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class com.ibm.as400.access.AS400JDBCDatabaseMetaData

java.lang.Object
   |
   +----com.ibm.as400.access.AS400JDBCDatabaseMetaData

public class AS400JDBCDatabaseMetaData
extends Object
implements DatabaseMetaData
The AS400JDBCDatabaseMetaData AS400JDBCDatabaseMetaData class provides information about the database as a whole.

Some of the methods in this class take arguments that are pattern strings. Such arguments are suffixed with "Pattern". Within a pattern string, "%" means match any substring of zero or more characters, and "_" means match exactly one character. Only entries matching the pattern string are returned.

Many of the methods here return lists of information in ResultSets. You can use the normal ResultSet methods to retrieve data from these ResultSets. The format of the ResultSets are described in the JDBC interface specification.

See Also:
AS400JDBCResultSet

Method Index

 o allProceduresAreCallable()
Indicates if all of the procedures returned by getProcedures() can be called by the current user.
 o allTablesAreSelectable()
Indicates if all of the tables returned by getTables() can be SELECTed by the current user.
 o dataDefinitionCausesTransactionCommit()
Indicates if a data definition statement within a transaction can force the transaction to commit.
 o dataDefinitionIgnoredInTransactions()
Indicates if a data definition statement within a transaction is ignored.
 o doesMaxRowSizeIncludeBlobs()
Indicates if getMaxRowSize() includes blobs when computing the maximum length of a single row.
 o getBestRowIdentifier(String, String, String, int, boolean)
Returns a description of a table's optimal set of columns that uniquely identifies a row.
 o getCatalogs()
Returns the catalog name available in this database.
 o getCatalogSeparator()
Returns the naming convention used when referring to tables.
 o getCatalogTerm()
Returns the DB2 for OS/400 SQL term for "catalog".
 o getColumnPrivileges(String, String, String, String)
Returns a description of the access rights for a table's columns.
 o getColumns(String, String, String, String)
Returns a description of the table's columns available in a catalog.
 o getCrossReference(String, String, String, String, String, String)
Returns a description of the foreign key columns in the foreign key table that references the primary key columns of the primary key table.
 o getDatabaseProductName()
Returns the name of this database product.
 o getDatabaseProductVersion()
Returns the version of this database product.
 o getDefaultTransactionIsolation()
Returns the default transaction isolation level.
 o getDriverMajorVersion()
Returns the major version number for this JDBC driver.
 o getDriverMinorVersion()
Returns the minor version number for this JDBC driver.
 o getDriverName()
Returns the name of this JDBC driver.
 o getDriverVersion()
Returns the version of this JDBC driver.
 o getExportedKeys(String, String, String)
Returns a description of the foreign key columns that reference a table's primary key columns.
 o getExtraNameCharacters()
Returns all of the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9, and _).
 o getIdentifierQuoteString()
Returns the string used to quote SQL identifiers.
 o getImportedKeys(String, String, String)
Returns a description of the primary key columns that are referenced by a table's foreign key columns.
 o getIndexInfo(String, String, String, boolean, boolean)
Returns a description of a table's indexes and statistics.
 o getMaxBinaryLiteralLength()
Returns the maximum length for an inline binary literal.
 o getMaxCatalogNameLength()
Returns the maximum length for a catalog name.
 o getMaxCharLiteralLength()
Returns the maximum length for a character literal.
 o getMaxColumnNameLength()
Returns the maximum length for a column name.
 o getMaxColumnsInGroupBy()
Returns the maximum number of columns in a GROUP BY clause.
 o getMaxColumnsInIndex()
Returns the maximum number of columns allowed in an index.
 o getMaxColumnsInOrderBy()
Returns the maximum number of columns in an ORDER BY clause.
 o getMaxColumnsInSelect()
Returns the maximum number of columns in a SELECT list.
 o getMaxColumnsInTable()
Returns the maximum number of columns in a table.
 o getMaxConnections()
Returns the number of active connections you can have at a time to this database.
 o getMaxCursorNameLength()
Returns the maximum cursor name length.
 o getMaxIndexLength()
Returns the maximum length of an index.
 o getMaxProcedureNameLength()
Returns the maximum length of a procedure name.
 o getMaxRowSize()
Returns the maximum length of a single row.
 o getMaxSchemaNameLength()
Returns the maximum length allowed for a schema name.
 o getMaxStatementLength()
Returns the maximum length of a SQL statement.
 o getMaxStatements()
Returns the number of active statements you can have open at one time.
 o getMaxTableNameLength()
Returns the maximum length of a table name.
 o getMaxTablesInSelect()
Returns the maximum number of tables in a SELECT.
 o getMaxUserNameLength()
Returns the maximum length of a user name.
 o getNumericFunctions()
Returns the list of supported math functions.
 o getPrimaryKeys(String, String, String)
Returns a description of the primary key columns.
 o getProcedureColumns(String, String, String, String)
Returns a description of a catalog's stored procedure parameters and result columns.
 o getProcedures(String, String, String)
Returns the description of the stored procedures available in a catalog.
 o getProcedureTerm()
Returns the DB2 for OS/400 SQL term for "procedure".
 o getSchemas()
Returns the schema names available in this database.
 o getSchemaTerm()
Returns the DB2 for OS/400 SQL term for "schema".
 o getSearchStringEscape()
Returns the string used to escape wildcard characters.
 o getSQLKeywords()
Returns the list of all of the database's SQL keywords that are not also SQL92 keywords.
 o getStringFunctions()
Returns the list of supported string functions.
 o getSystemFunctions()
Returns the list of supported system functions.
 o getTablePrivileges(String, String, String)
Returns the description of the access rights for each table available in a catalog.
 o getTables(String, String, String, String[])
Returns the description of the tables available in a catalog.
 o getTableTypes()
Returns the table types available in this database.
 o getTimeDateFunctions()
Returns the list of supported time and date functions.
 o getTypeInfo()
Returns a description of all of the standard SQL types supported by this database.
 o getURL()
Returns the URL for this database.
 o getUserName()
Returns the current user name as known to the database.
 o getVersionColumns(String, String, String)
Returns a description of a table's columns that are automatically updated when any value in a row is updated.
 o isCatalogAtStart()
Indicates if a catalog appears at the start or the end of a qualified name.
 o isReadOnly()
Indicates if the database is in read-only mode.
 o nullPlusNonNullIsNull()
Indicates if concatenations between null and non-null values are null.
 o nullsAreSortedAtEnd()
Indicates if null values are sorted at the end regardless of sort order.
 o nullsAreSortedAtStart()
Indicates if null values are sorted at the start regardless of sort order.
 o nullsAreSortedHigh()
Indicates if null values are sorted high.
 o nullsAreSortedLow()
Indicates if null values are sorted low.
 o storesLowerCaseIdentifiers()
Indicates if the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in lowercase.
 o storesLowerCaseQuotedIdentifiers()
Indicates if the database treats mixed case, quoted SQL identifiers as case insensitive and stores them in lowercase.
 o storesMixedCaseIdentifiers()
Indicates if the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in mixed case.
 o storesMixedCaseQuotedIdentifiers()
Indicates if the database treats mixed case, quoted SQL identifiers as case insensitive and stores them in mixed case.
 o storesUpperCaseIdentifiers()
Indicates if the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in uppercase.
 o storesUpperCaseQuotedIdentifiers()
Indicates if the database treats mixed case, quoted SQL identifiers as case insensitive and stores them in uppercase.
 o supportsAlterTableWithAddColumn()
Indicates if ALTER TABLE with ADD COLUMN is supported.
 o supportsAlterTableWithDropColumn()
Indicates if ALTER TABLE with DROP COLUMN is supported.
 o supportsANSI92EntryLevelSQL()
Indicates if the ANSI92 entry-level SQL grammar is supported.
 o supportsANSI92FullSQL()
Indicates if the ANSI92, full SQL grammar is supported.
 o supportsANSI92IntermediateSQL()
Indicates if the ANSI92 intermediate-level SQL grammar is supported.
 o supportsCatalogsInDataManipulation()
Indicates if a catalog name can be used in a data manipulation statement.
 o supportsCatalogsInIndexDefinitions()
Indicates if a catalog name can be used in an index definition statement.
 o supportsCatalogsInPrivilegeDefinitions()
Indicates if a catalog name can be used in a privilege definition statement.
 o supportsCatalogsInProcedureCalls()
Indicates if a catalog name can be used in a procedure call statement.
 o supportsCatalogsInTableDefinitions()
Indicates if a catalog name can be used in a table definition statement.
 o supportsColumnAliasing()
Indicates if column aliasing is supported.
 o supportsConvert()
Indicates if the CONVERT function between SQL types is supported.
 o supportsConvert(int, int)
Indicates if CONVERT between the given SQL types is supported.
 o supportsCoreSQLGrammar()
Indicates if the ODBC Core SQL grammar is supported.
 o supportsCorrelatedSubqueries()
Indicates if the correlated subqueries are supported.
 o supportsDataDefinitionAndDataManipulationTransactions()
Indicates if both data definition and data manipulation statements are supported within a transaction.
 o supportsDataManipulationTransactionsOnly()
Indicates if data manipulation statements are supported within a transaction.
 o supportsDifferentTableCorrelationNames()
Indicates if table correlation names are supported, and if so, are they restricted to be different from the names of the tables.
 o supportsExpressionsInOrderBy()
Indicates if expressions in ORDER BY lists are supported.
 o supportsExtendedSQLGrammar()
Indicates if the ODBC Extended SQL grammar is supported.
 o supportsFullOuterJoins()
Indicates if full nested outer joins are supported.
 o supportsGroupBy()
Indicates if some form of the GROUP BY clause is supported.
 o supportsGroupByBeyondSelect()
Indicates if a GROUP BY clause can add columns not in the SELECT provided it specifies all of the columns in the SELECT.
 o supportsGroupByUnrelated()
Indicates if a GROUP BY clause can use columns not in the SELECT.
 o supportsIntegrityEnhancementFacility()
Indicates if the SQL Integrity Enhancement Facility is supported.
 o supportsLikeEscapeClause()
Indicates if the escape character in LIKE clauses is supported.
 o supportsLimitedOuterJoins()
Indicates if there is limited support for outer joins.
 o supportsMinimumSQLGrammar()
Indicates if the ODBC Minimum SQL grammar is supported.
 o supportsMixedCaseIdentifiers()
Indicates if the database treats mixed case, unquoted SQL identifiers as case sensitive and stores them in mixed case.
 o supportsMixedCaseQuotedIdentifiers()
Indicates if the database treats mixed case, quoted SQL identifiers as case sensitive and as a result stores them in mixed case.
 o supportsMultipleResultSets()
Indicates if multiple result sets from a single execute are supported.
 o supportsMultipleTransactions()
Indicates if multiple transactions can be open at once (on different connections).
 o supportsNonNullableColumns()
Indicates if columns can be defined as non-nullable.
 o supportsOpenCursorsAcrossCommit()
Indicates if cursors can remain open across commits.
 o supportsOpenCursorsAcrossRollback()
Indicates if cursors can remain open across rollback.
 o supportsOpenStatementsAcrossCommit()
Indicates if statements can remain open across commits.
 o supportsOpenStatementsAcrossRollback()
Indicates if statements can remain open across rollback.
 o supportsOrderByUnrelated()
Indicates if an ORDER BY clause can use columns not in the SELECT.
 o supportsOuterJoins()
Indicates if some form of outer join is supported.
 o supportsPositionedDelete()
Indicates if positioned DELETE is supported.
 o supportsPositionedUpdate()
Indicates if positioned UPDATE is supported.
 o supportsSchemasInDataManipulation()
Indicates if a schema name can be used in a data manipulation statement.
 o supportsSchemasInIndexDefinitions()
Indicates if a schema name can be used in an index definition statement.
 o supportsSchemasInPrivilegeDefinitions()
Indicates if a schema name be can used in a privilege definition statement.
 o supportsSchemasInProcedureCalls()
Indicates if a schema name be can used in a procedure call statement.
 o supportsSchemasInTableDefinitions()
Indicates if a schema name can be used in a table definition statement.
 o supportsSelectForUpdate()
Indicates if SELECT for UPDATE is supported.
 o supportsStoredProcedures()
Indicates if stored procedure calls using the stored procedure escape syntax are supported.
 o supportsSubqueriesInComparisons()
Indicates if subqueries in comparisons are supported.
 o supportsSubqueriesInExists()
Indicates if subqueries in EXISTS expressions are supported.
 o supportsSubqueriesInIns()
Indicates if subqueries in IN expressions are supported.
 o supportsSubqueriesInQuantifieds()
Indicates if subqueries in quantified expressions are supported.
 o supportsTableCorrelationNames()
Indicates if table correlation names are supported.
 o supportsTransactionIsolationLevel(int)
Indicates if the database supports the given transaction isolation level.
 o supportsTransactions()
Indicates if transactions are supported.
 o supportsUnion()
Indicates if SQL UNION is supported.
 o supportsUnionAll()
Indicates if SQL UNION ALL is supported.
 o toString()
Returns the name of the catalog.
 o usesLocalFilePerTable()
Indicates if the database uses a file for each table.
 o usesLocalFiles()
Indicates if the database stores tables in a local file.

Methods

 o allProceduresAreCallable
 public boolean allProceduresAreCallable() throws SQLException
Indicates if all of the procedures returned by getProcedures() can be called by the current user.

Returns:
Always false. This driver cannot determine if all of the procedures can be called by the current user.
Throws: SQLException
If an error occurs.
See Also:
getProcedures
 o allTablesAreSelectable
 public boolean allTablesAreSelectable() throws SQLException
Indicates if all of the tables returned by getTables() can be SELECTed by the current user.

Returns:
Always false. This driver cannot determine if all of the tables returned by getTables can be selected by the current user.
Throws: SQLException
If an error occurs.
See Also:
getTables
 o dataDefinitionCausesTransactionCommit
 public boolean dataDefinitionCausesTransactionCommit() throws SQLException
Indicates if a data definition statement within a transaction can force the transaction to commit.

Returns:
Always false. A data definition statement within a transaction does not force the transaction to commit.
Throws: SQLException
If an error occurs.
 o dataDefinitionIgnoredInTransactions
 public boolean dataDefinitionIgnoredInTransactions() throws SQLException
Indicates if a data definition statement within a transaction is ignored.

Returns:
Always false. A data definition statement within a transaction is not ignored.
Throws: SQLException
If an error occurs.
 o doesMaxRowSizeIncludeBlobs
 public boolean doesMaxRowSizeIncludeBlobs() throws SQLException
Indicates if getMaxRowSize() includes blobs when computing the maximum length of a single row.

Returns:
Always true. getMaxRowSize() does include blobs when computing the maximum length of a single row.
Throws: SQLException
If an error occurs.
 o getBestRowIdentifier
 public ResultSet getBestRowIdentifier(String catalog,
                                       String schema,
                                       String table,
                                       int scope,
                                       boolean nullable) throws SQLException
Returns a description of a table's optimal set of columns that uniquely identifies a row.

Parameters:
catalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
schema - The schema name. If null is specified, the default library specified in the URL will be used. If null is specified and a default library was not specified in the URL, the first library specified in the libraries properties file will be used. If null is specified and a default library was not specified in the URL and a library was not specified in the libraries properties file, QGPL will be used. If empty string is specified, an empty result set will be returned.
table - The table name. If null or empty string is specified, an empty result set will be returned.
scope - The scope of interest. Valid values are: bestRowTemporary and bestRowTransaction. bestRowSession is not allowed because it cannot be guaranteed that the row will remain valid for the session. If bestRowSession is specified, an empty result set will be returned. If bestRowTransaction is specified, autocommit is false, and transaction is set to repeatable read, then results will be returned; otherwise, an empty result set will be returned.
nullable - The value indicating if columns that are nullable should be included.
Returns:
The ResultSet containing a table's optimal set of columns that uniquely identify a row.
Throws: SQLException
If an error occurs.
 o getCatalogs
 public ResultSet getCatalogs() throws SQLException
Returns the catalog name available in this database. This will return a ResultSet with a single row, whose value is the server name.

Returns:
The ResultSet containing the server name.
Throws: SQLException
If an error occurs.
 o getCatalogSeparator
 public String getCatalogSeparator() throws SQLException
Returns the naming convention used when referring to tables. This depends on the naming convention specified in the connection properties.

Returns:
If using SQL naming convention, "." will be returned. If using AS/400 system naming convention, "/" will be returned.
Throws: SQLException
If an error occurs.
See Also:
connect
 o getCatalogTerm
 public String getCatalogTerm() throws SQLException
Returns the DB2 for OS/400 SQL term for "catalog".

Returns:
The term "System".
Throws: SQLException
If an error occurs.
 o getColumnPrivileges
 public ResultSet getColumnPrivileges(String catalog,
                                      String schema,
                                      String table,
                                      String columnPattern) throws SQLException
Returns a description of the access rights for a table's columns.

Parameters:
catalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
schema - The schema name. If null is specified, the default library specified in the URL will be used. If null is specified and a default library was not specified in the URL, the first library specified in the libraries properties file will be used. If null is specified and a default library was not specified in the URL and a library was not specified in the libraries properties file, QGPL will be used. If empty string is specified, an empty result set will be returned.
table - The table name. If null or empty string is specified, an empty result set will be returned.
columnPattern - The column name pattern. If null is specified, no value will be sent to the server and the server default of *all will be used. If empty string is specified, an empty result set will be returned.
Returns:
The ResultSet containing access rights for a table's columns.
Throws: SQLException
If an error occurs.
 o getColumns
 public ResultSet getColumns(String catalog,
                             String schemaPattern,
                             String tablePattern,
                             String columnPattern) throws SQLException
Returns a description of the table's columns available in a catalog.

Parameters:
catalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
schemaPattern - The schema name pattern. If null is specified, no value will be sent to the server and the server default of *USRLIBL will be used. If empty string is specified, an empty result set will be returned.
tablePattern - The table name pattern. If null is specified, no value will be sent to the server and the server default of *ALL will be used. If empty string is specified, an empty result set will be returned.
columnPattern - The column name pattern. If null is specified, no value will be sent to the server and the server default of *ALL will be used. If empty string is specified, an empty result set will be returned.
Returns:
The ResultSet containing the table's columns available in a catalog.
Throws: SQLException
If an error occurs.
 o getCrossReference
 public ResultSet getCrossReference(String primaryCatalog,
                                    String primarySchema,
                                    String primaryTable,
                                    String foreignCatalog,
                                    String foreignSchema,
                                    String foreignTable) throws SQLException
Returns a description of the foreign key columns in the foreign key table that references the primary key columns of the primary key table. This is a description of how the primary table imports the foreign table's key.

Parameters:
primaryCatalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
primarySchema - The name of the schema where the primary table is located. If null is specified, the default library specified in the URL will be used. If null is specified and a default library was not specified in the URL, the first library specified in the libraries properties file will be used. If null is specified,a default library was not specified in the URL, and a library was not specified in the libraries properties file, QGPL will be used. If empty string is specified, an empty result set will be returned.
primaryTable - The primary table name. If null or empty string is specified, an empty result set will be returned.
foreignCatalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
foreignSchema - The name of the schema where the primary table is located. If null is specified, the default library specified in the URL will be used. If null is specified and a default library was not specified in the URL, the first library specified in the libraries properties file will be used. If null is specified, a default library was not specified in the URL, and a library was not specified in the libraries properties file, QGPL will be used. If empty string is specified, an empty result set will be returned.
foreignTable - The foreign table name. If null or empty string is specified, an empty result set will be returned.
Returns:
The ResultSet containing the description of the foreign key columns in the foreign key table that references the primary key columns of the primary key table.
Throws: SQLException
If an error occurs.
See Also:
getImportedKeys, getExportedKeys
 o getDatabaseProductName
 public String getDatabaseProductName() throws SQLException
Returns the name of this database product.

Returns:
The database product name.
Throws: SQLException
If an error occurs.
See Also:
getDatabaseProductVersion
 o getDatabaseProductVersion
 public String getDatabaseProductVersion() throws SQLException
Returns the version of this database product.

Returns:
The product version.
Throws: SQLException
If an error occurs.
See Also:
getDatabaseProductName
 o getDefaultTransactionIsolation
 public int getDefaultTransactionIsolation() throws SQLException
Returns the default transaction isolation level.

Returns:
The default transaction isolation level.
Throws: SQLException
If an error occurs.
See Also:
supportsTransactionIsolationLevel
 o getDriverMajorVersion
 public int getDriverMajorVersion()
Returns the major version number for this JDBC driver.

Returns:
The major version number.
See Also:
getDriverMinorVersion, getDriverName, getDriverVersion, getMajorVersion
 o getDriverMinorVersion
 public int getDriverMinorVersion()
Returns the minor version number for this JDBC driver.

Returns:
The minor version number.
See Also:
getDriverMajorVersion, getDriverName, getDriverVersion, getMinorVersion
 o getDriverName
 public String getDriverName() throws SQLException
Returns the name of this JDBC driver.

Returns:
The driver name.
Throws: SQLException
If an error occurs.
See Also:
getDriverMinorVersion, getDriverMajorVersion, getDriverVersion
 o getDriverVersion
 public String getDriverVersion() throws SQLException
Returns the version of this JDBC driver.

Returns:
The driver version.
Throws: SQLException
If an error occurs.
See Also:
getDriverMinorVersion, getDriverMajorVersion, getDriverName
 o getExportedKeys
 public ResultSet getExportedKeys(String catalog,
                                  String schema,
                                  String table) throws SQLException
Returns a description of the foreign key columns that reference a table's primary key columns. This is the foreign keys exported by a table.

Parameters:
catalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
schema - The schema name. If null is specified, the default library specified in the URL will be used. If null is specified and a default library was not specified in the URL, the first library specified in the libraries properties file will be used. If null is specified, a default library was not specified in the URL, and a library was not specified in the libraries properties file, QGPL will be used. If empty string is specified, an empty result set will be returned.
table - The table name. If null or empty string is specified, an empty result set will be returned.
Returns:
The ResultSet containing the description of the foreign key columns that reference a table's primary key columns.
Throws: SQLException
If an error occurs.
See Also:
getImportedKeys, getCrossReference
 o getExtraNameCharacters
 public String getExtraNameCharacters() throws SQLException
Returns all of the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9, and _).

Returns:
The String containing the "extra" characters.
Throws: SQLException
If an error occurs.
 o getIdentifierQuoteString
 public String getIdentifierQuoteString() throws SQLException
Returns the string used to quote SQL identifiers.

Returns:
The quote string.
Throws: SQLException
If an error occurs.
 o getImportedKeys
 public ResultSet getImportedKeys(String catalog,
                                  String schema,
                                  String table) throws SQLException
Returns a description of the primary key columns that are referenced by a table's foreign key columns. This is the primary keys imported by a table.

Parameters:
catalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
schema - The schema name. If null is specified, the default library specified in the URL will be used. If null is specified and a default library was not specified in the URL, the first library specified in the libraries properties file will be used. If null is specified, a default library was not specified in the URL, and a library was not specified in the libraries properties file, QGPL will be used. If empty string is specified, an empty result set will be returned.
table - The table name. If null or empty string is specified, an empty result set will be returned.
Returns:
The ResultSets containing the description of the primary key columns that are referenced by a table's foreign key columns.
Throws: SQLException
If an error occurs.
See Also:
getExportedKeys, getCrossReference
 o getIndexInfo
 public ResultSet getIndexInfo(String catalog,
                               String schema,
                               String table,
                               boolean unique,
                               boolean approximate) throws SQLException
Returns a description of a table's indexes and statistics.

Parameters:
catalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
schema - The schema name. If null is specified, the default library specified in the URL will be used. If null is specified and a default library was not specified in the URL, the first library specified in the libraries properties file will be used. If null is specified, a default library was not specified in the URL, and a library was not specified in the libraries properties file, QGPL will be used. If empty string is specified, an empty result set will be returned.
table - The table name. If null or empty string is specified, an empty result set will be returned.
unique - The value indicating if unique indexes should be returned. If true, only indexes for unique values will be returned. If false, all indexes will be returned.
approximate - The value indicating if the result is allowed to reflect approximate or out-of-date values. This value will be ignored.
Returns:
The ResultSet containing the description of a table's indexes and statistics.
Throws: SQLException
If an error occurs.
 o getMaxBinaryLiteralLength
 public int getMaxBinaryLiteralLength() throws SQLException
Returns the maximum length for an inline binary literal.

Returns:
The maximum length (in bytes).
Throws: SQLException
If an error occurs.
 o getMaxCatalogNameLength
 public int getMaxCatalogNameLength() throws SQLException
Returns the maximum length for a catalog name.

Returns:
The maximum length (in bytes).
Throws: SQLException
If an error occurs.
 o getMaxCharLiteralLength
 public int getMaxCharLiteralLength() throws SQLException
Returns the maximum length for a character literal.

Returns:
The maximum length (in bytes).
Throws: SQLException
If an error occurs.
 o getMaxColumnNameLength
 public int getMaxColumnNameLength() throws SQLException
Returns the maximum length for a column name.

Returns:
The maximum length (in bytes).
Throws: SQLException
If an error occurs.
 o getMaxColumnsInGroupBy
 public int getMaxColumnsInGroupBy() throws SQLException
Returns the maximum number of columns in a GROUP BY clause.

Returns:
The maximum number of columns.
Throws: SQLException
If an error occurs.
 o getMaxColumnsInIndex
 public int getMaxColumnsInIndex() throws SQLException
Returns the maximum number of columns allowed in an index.

Returns:
The maximum number of columns.
Throws: SQLException
If an error occurs.
 o getMaxColumnsInOrderBy
 public int getMaxColumnsInOrderBy() throws SQLException
Returns the maximum number of columns in an ORDER BY clause.

Returns:
The maximum number of columns.
Throws: SQLException
If an error occurs.
 o getMaxColumnsInSelect
 public int getMaxColumnsInSelect() throws SQLException
Returns the maximum number of columns in a SELECT list.

Returns:
The maximum number of columns.
Throws: SQLException
If an error occurs.
 o getMaxColumnsInTable
 public int getMaxColumnsInTable() throws SQLException
Returns the maximum number of columns in a table.

Returns:
The maximum number of columns.
Throws: SQLException
If an error occurs.
 o getMaxConnections
 public int getMaxConnections() throws SQLException
Returns the number of active connections you can have at a time to this database.

Returns:
The maximum number of connections or 0 if no limit.
Throws: SQLException
If an error occurs.
 o getMaxCursorNameLength
 public int getMaxCursorNameLength() throws SQLException
Returns the maximum cursor name length.

Returns:
The maximum length (in bytes).
Throws: SQLException
If an error occurs.
 o getMaxIndexLength
 public int getMaxIndexLength() throws SQLException
Returns the maximum length of an index.

Returns:
The maximum length (in bytes).
Throws: SQLException
If an error occurs.
 o getMaxProcedureNameLength
 public int getMaxProcedureNameLength() throws SQLException
Returns the maximum length of a procedure name.

Returns:
The maximum length (in bytes).
Throws: SQLException
If an error occurs.
 o getMaxRowSize
 public int getMaxRowSize() throws SQLException
Returns the maximum length of a single row.

Returns:
The maximum length (in bytes).
Throws: SQLException
If an error occurs.
 o getMaxSchemaNameLength
 public int getMaxSchemaNameLength() throws SQLException
Returns the maximum length allowed for a schema name.

Returns:
The maximum length (in bytes).
Throws: SQLException
If an error occurs.
 o getMaxStatementLength
 public int getMaxStatementLength() throws SQLException
Returns the maximum length of a SQL statement.

Returns:
The maximum length (in bytes).
Throws: SQLException
If an error occurs.
 o getMaxStatements
 public int getMaxStatements() throws SQLException
Returns the number of active statements you can have open at one time.

Returns:
The maximum number of statements or 0 if no limit.
Throws: SQLException
If an error occurs.
 o getMaxTableNameLength
 public int getMaxTableNameLength() throws SQLException
Returns the maximum length of a table name.

Returns:
The maximum length (in bytes).
Throws: SQLException
If an error occurs.
 o getMaxTablesInSelect
 public int getMaxTablesInSelect() throws SQLException
Returns the maximum number of tables in a SELECT.

Returns:
The maximum number of tables.
Throws: SQLException
If an error occurs.
 o getMaxUserNameLength
 public int getMaxUserNameLength() throws SQLException
Returns the maximum length of a user name.

Returns:
The maximum length (in bytes).
Throws: SQLException
If an error occurs.
 o getNumericFunctions
 public String getNumericFunctions() throws SQLException
Returns the list of supported math functions.

Returns:
The list of supported math functions, separated by commas.
Throws: SQLException
If an error occurs.
 o getPrimaryKeys
 public ResultSet getPrimaryKeys(String catalog,
                                 String schema,
                                 String table) throws SQLException
Returns a description of the primary key columns.

Parameters:
catalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
schema - The schema name. If null is specified, the default library specified in the URL will be used. If null is specified and a default library was not specified in the URL, the first library specified in the libraries properties file will be used. If null is specified, a default library was not specified in the URL, and a library was not specified in the libraries properties file, QGPL will be used. If empty string is specified, an empty result set will be returned.
table - The table name. If null or empty string is specified, an empty result set will be returned.
Returns:
The ResultSet containing the description of the primary key columns.
Throws: SQLException
If an error occurs.
 o getProcedureColumns
 public ResultSet getProcedureColumns(String catalog,
                                      String schemaPattern,
                                      String procedurePattern,
                                      String columnPattern) throws SQLException
Returns a description of a catalog's stored procedure parameters and result columns.

Parameters:
catalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
schemaPattern - The schema name pattern. If null is specified, it will not be included in the selection criteria. If empty string is specified, an empty result set will be returned.
procedurePattern - The procedure name pattern. If null is specified, it will not be included in the selection criteria. If empty string is specified, an empty result set will be returned.
columnPattern - The column name pattern. If null is specified, it will not be included in the selection criteria. If empty string is specified, an empty result set will be returned.
Returns:
The ResultSet containing the description of the catalog's stored procedure parameters and result columns.
Throws: SQLException
If an error occurs.
 o getProcedures
 public ResultSet getProcedures(String catalog,
                                String schemaPattern,
                                String procedurePattern) throws SQLException
Returns the description of the stored procedures available in a catalog.

Parameters:
catalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
schemaPattern - The schema name pattern. If null is specified, it will not be included in the selection criteria. If empty string is specified, an empty result set will be returned.
procedurePattern - The procedure name pattern. If null is specified, it will not be included in the selection criteria. If empty string is specified, an empty result set will be returned.
Returns:
The ResultSet containing the description of the stored procedures available in the catalog.
Throws: SQLException
If an error occurs.
 o getProcedureTerm
 public String getProcedureTerm() throws SQLException
Returns the DB2 for OS/400 SQL term for "procedure".

Returns:
The term for "procedure".
Throws: SQLException
If an error occurs.
 o getSchemas
 public ResultSet getSchemas() throws SQLException
Returns the schema names available in this database. This will return a ResultSet with a list of all the libraries.

Returns:
The ResultSet containing the list of all the libraries.
Throws: SQLException
If an error occurs.
 o getSchemaTerm
 public String getSchemaTerm() throws SQLException
Returns the DB2 for OS/400 SQL term for "schema".

Returns:
The term for schema.
Throws: SQLException
If an error occurs.
 o getSearchStringEscape
 public String getSearchStringEscape() throws SQLException
Returns the string used to escape wildcard characters. This is the string that can be used to escape '_' or '%' in string patterns.

Returns:
The escape string.
Throws: SQLException
If an error occurs.
 o getSQLKeywords
 public String getSQLKeywords() throws SQLException
Returns the list of all of the database's SQL keywords that are not also SQL92 keywords.

Returns:
The list of SQL keywords, separated by commas.
Throws: SQLException
If an error occurs.
 o getStringFunctions
 public String getStringFunctions() throws SQLException
Returns the list of supported string functions.

Returns:
The list of supported string functions, separated by commas.
Throws: SQLException
If an error occurs.
 o getSystemFunctions
 public String getSystemFunctions() throws SQLException
Returns the list of supported system functions.

Returns:
The list of supported system functions, separated by commas.
Throws: SQLException
If an error occurs.
 o getTablePrivileges
 public ResultSet getTablePrivileges(String catalog,
                                     String schemaPattern,
                                     String tablePattern) throws SQLException
Returns the description of the access rights for each table available in a catalog. Note that a table privilege applies to one or more columns in a table.

Parameters:
catalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
schemaPattern - The schema name pattern. If null is specified, no value will be sent to the server and the server default of *USRLIBL will be used. If empty string is specified, an empty result set will be returned.
tablePattern - The table name. If null is specified, no value will be sent to the server and the server default of *ALL will be used. If empty string is specified, an empty result set will be returned.
Returns:
The ResultSet containing the description of the access rights for each table available in the catalog.
Throws: SQLException
If an error occurs.
 o getTables
 public ResultSet getTables(String catalog,
                            String schemaPattern,
                            String tablePattern,
                            String tableTypes[]) throws SQLException
Returns the description of the tables available in a catalog.

Parameters:
catalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
schemaPattern - The schema name pattern. If null is specified, no value will be sent to the server and the server default of *USRLIBL will be used. If empty string is specified, an empty result set will be returned.
tablePattern - The table name pattern. If null is specified, no value will be sent to the server and the server default of *ALL will be used. If empty string is specified, an empty result set will be returned.
tableTypes - The list of table types to include, or null to include all table types. Valid types are: TABLE, VIEW, and SYSTEM TABLE.
Returns:
The ResultSet containing the description of the tables available in the catalog.
Throws: SQLException
If an error occurs.
 o getTableTypes
 public ResultSet getTableTypes() throws SQLException
Returns the table types available in this database.

Returns:
The ResultSet containing the table types available in this database.
Throws: SQLException
If an error occurs.
 o getTimeDateFunctions
 public String getTimeDateFunctions() throws SQLException
Returns the list of supported time and date functions.

Returns:
The list of supported time and data functions, separated by commas.
Throws: SQLException
If an error occurs.
 o getTypeInfo
 public ResultSet getTypeInfo() throws SQLException
Returns a description of all of the standard SQL types supported by this database.

Returns:
The ResultSet containing the description of all the standard SQL types supported by this database.
Throws: SQLException
If an error occurs.
 o getURL
 public String getURL() throws SQLException
Returns the URL for this database.

Returns:
The URL for this database.
Throws: SQLException
If an error occurs.
 o getUserName
 public String getUserName() throws SQLException
Returns the current user name as known to the database.

Returns:
The current user name as known to the database.
Throws: SQLException
If an error occurs.
 o getVersionColumns
 public ResultSet getVersionColumns(String catalog,
                                    String schema,
                                    String table) throws SQLException
Returns a description of a table's columns that are automatically updated when any value in a row is updated.

Parameters:
catalog - The catalog name. If null is specified, this parameter will be ignored. If empty string is specified, an empty result set will be returned.
schema - The schema name. If null is specified, the default library specified in the URL will be used. If null is specified and a default library was not specified in the URL, the first library specified in the libraries properties file will be used. If null is specified, a default library was not specified in the URL, and a library was not specified in the libraries properties file, QGPL will be used. If empty string is specified, an empty result set will be returned.
table - The table name. If null or empty string is specified, an empty result set will be returned.
Returns:
The ResultSet containing the description of the table's columns that are automatically updated when any value in a row is updated.
Throws: SQLException
If an error occurs.
 o isCatalogAtStart
 public boolean isCatalogAtStart() throws SQLException
Indicates if a catalog appears at the start or the end of a qualified name.

Returns:
Always true. Catalog appears at the start of a qualified name.
Throws: SQLException
If an error occurs.
 o isReadOnly
 public boolean isReadOnly() throws SQLException
Indicates if the database is in read-only mode.

Returns:
true if in read-only mode; false otherwise.
Throws: SQLException
If an error occurs.
 o nullPlusNonNullIsNull
 public boolean nullPlusNonNullIsNull() throws SQLException
Indicates if concatenations between null and non-null values are null.

Returns:
Always true. Concatenations between null and non-null values are null.
Throws: SQLException
If an error occurs.
 o nullsAreSortedAtEnd
 public boolean nullsAreSortedAtEnd() throws SQLException
Indicates if null values are sorted at the end regardless of sort order.

Returns:
Always false. Null values are not sorted at the end regardless of sort order.
Throws: SQLException
If an error occurs.
 o nullsAreSortedAtStart
 public boolean nullsAreSortedAtStart() throws SQLException
Indicates if null values are sorted at the start regardless of sort order.

Returns:
Always false. Null values are not sorted at the start regardless of sort order.
Throws: SQLException
If an error occurs.
 o nullsAreSortedHigh
 public boolean nullsAreSortedHigh() throws SQLException
Indicates if null values are sorted high.

Returns:
Always true. Null values are sorted high.
Throws: SQLException
If an error occurs.
 o nullsAreSortedLow
 public boolean nullsAreSortedLow() throws SQLException
Indicates if null values are sorted low.

Returns:
Always false. Null values are not sorted low.
Throws: SQLException
If an error occurs.
 o storesLowerCaseIdentifiers
 public boolean storesLowerCaseIdentifiers() throws SQLException
Indicates if the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in lowercase.

Returns:
Always false. The database does not treat mixed case, unquoted SQL identifiers as case insensitive and store them in lowercase.
Throws: SQLException
If an error occurs.
 o storesLowerCaseQuotedIdentifiers
 public boolean storesLowerCaseQuotedIdentifiers() throws SQLException
Indicates if the database treats mixed case, quoted SQL identifiers as case insensitive and stores them in lowercase.

Returns:
Always false. The database does not treat mixed case, quoted SQL identifiers as case insensitive and store them in lowercase.
Throws: SQLException
If an error occurs.
 o storesMixedCaseIdentifiers
 public boolean storesMixedCaseIdentifiers() throws SQLException
Indicates if the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in mixed case.

Returns:
Always false. The database does not treat mixed case, unquoted SQL identifiers as case insensitive and store them in mixed case.
Throws: SQLException
If an error occurs.
 o storesMixedCaseQuotedIdentifiers
 public boolean storesMixedCaseQuotedIdentifiers() throws SQLException
Indicates if the database treats mixed case, quoted SQL identifiers as case insensitive and stores them in mixed case.

Returns:
Always true. The database does treat mixed case, quoted SQL identifiers as case insensitive and store them in mixed case.
Throws: SQLException
If an error occurs.
 o storesUpperCaseIdentifiers
 public boolean storesUpperCaseIdentifiers() throws SQLException
Indicates if the database treats mixed case, unquoted SQL identifiers as case insensitive and stores them in uppercase.

Returns:
Always true. The database does treat mixed case, unquoted SQL identifiers as case insensitive and store them in uppercase.
Throws: SQLException
If an error occurs.
 o storesUpperCaseQuotedIdentifiers
 public boolean storesUpperCaseQuotedIdentifiers() throws SQLException
Indicates if the database treats mixed case, quoted SQL identifiers as case insensitive and stores them in uppercase.

Returns:
Always false. The database does not treat mixed case, quoted SQL identifiers as case insensitive and store them in uppercase.
Throws: SQLException
If an error occurs.
 o supportsAlterTableWithAddColumn
 public boolean supportsAlterTableWithAddColumn() throws SQLException
Indicates if ALTER TABLE with ADD COLUMN is supported.

Returns:
Always true. ALTER TABLE with ADD COLUMN is supported.
Throws: SQLException
If an error occurs.
 o supportsAlterTableWithDropColumn
 public boolean supportsAlterTableWithDropColumn() throws SQLException
Indicates if ALTER TABLE with DROP COLUMN is supported.

Returns:
Always true. ALTER TABLE with DROP COLUMN is not supported.
Throws: SQLException
If an error occurs.
See Also:
supportsAlterTableWithAddColumn
 o supportsANSI92EntryLevelSQL
 public boolean supportsANSI92EntryLevelSQL() throws SQLException
Indicates if the ANSI92 entry-level SQL grammar is supported.

Returns:
Always true. The ANSI92 entry-level SQL grammar is supported.
Throws: SQLException
If an error occurs.
 o supportsANSI92FullSQL
 public boolean supportsANSI92FullSQL() throws SQLException
Indicates if the ANSI92, full SQL grammar is supported.

Returns:
Always false. ANSI92, full SQL grammar is not supported.
Throws: SQLException
If an error occurs.
 o supportsANSI92IntermediateSQL
 public boolean supportsANSI92IntermediateSQL() throws SQLException
Indicates if the ANSI92 intermediate-level SQL grammar is supported.

Returns:
Always false. ANSI92 intermediate-level SQL grammar is not supported.
Throws: SQLException
If an error occurs.
 o supportsCatalogsInDataManipulation
 public boolean supportsCatalogsInDataManipulation() throws SQLException
Indicates if a catalog name can be used in a data manipulation statement.

Returns:
Always false. A catalog name can not be used in a data manipulation statement.
Throws: SQLException
If an error occurs.
 o supportsCatalogsInIndexDefinitions
 public boolean supportsCatalogsInIndexDefinitions() throws SQLException
Indicates if a catalog name can be used in an index definition statement.

Returns:
Always false. A catalog name can not be used in an index definition statement.
Throws: SQLException
If an error occurs.
 o supportsCatalogsInPrivilegeDefinitions
 public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException
Indicates if a catalog name can be used in a privilege definition statement.

Returns:
Always false. A catalog name can not be used in a privilege definition statement.
Throws: SQLException
If an error occurs.
 o supportsCatalogsInProcedureCalls
 public boolean supportsCatalogsInProcedureCalls() throws SQLException
Indicates if a catalog name can be used in a procedure call statement.

Returns:
Always false. A catalog name can not be used in a procedure call statement.
Throws: SQLException
If an error occurs.
 o supportsCatalogsInTableDefinitions
 public boolean supportsCatalogsInTableDefinitions() throws SQLException
Indicates if a catalog name can be used in a table definition statement.

Returns:
Always false. A catalog name can not be used in a table definition statement.
Throws: SQLException
If an error occurs.
 o supportsColumnAliasing
 public boolean supportsColumnAliasing() throws SQLException
Indicates if column aliasing is supported. Column aliasing means that the SQL AS clause can be used to provide names for computed columns or to provide alias names for column as required.

Returns:
Always true. Column aliasing is supported.
Throws: SQLException
If an error occurs.
 o supportsConvert
 public boolean supportsConvert() throws SQLException
Indicates if the CONVERT function between SQL types is supported.

Returns:
true if the CONVERT function between SQL types is supported; false otherwise.
Throws: SQLException
If an error occurs.
 o supportsConvert
 public boolean supportsConvert(int fromType,
                                int toType) throws SQLException
Indicates if CONVERT between the given SQL types is supported.

Parameters:
fromType - The SQL type code defined in java.sql.Types.
toType - The SQL type code defined in java.sql.Types.
Returns:
true if CONVERT between the given SQL types is supported; false otherwise.
Throws: SQLException
If an error occurs.
See Also:
Types
 o supportsCoreSQLGrammar
 public boolean supportsCoreSQLGrammar() throws SQLException
Indicates if the ODBC Core SQL grammar is supported.

Returns:
Always true. The ODBC Core SQL grammar is supported.
Throws: SQLException
If an error occurs.
 o supportsCorrelatedSubqueries
 public boolean supportsCorrelatedSubqueries() throws SQLException
Indicates if the correlated subqueries are supported.

Returns:
Always true. Correlated subqueries are supported.
Throws: SQLException
If an error occurs.
 o supportsDataDefinitionAndDataManipulationTransactions
 public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException
Indicates if both data definition and data manipulation statements are supported within a transaction.

Returns:
Always true. Data definition and data manipulation statements are both supported within a transaction.
Throws: SQLException
If an error occurs.
 o supportsDataManipulationTransactionsOnly
 public boolean supportsDataManipulationTransactionsOnly() throws SQLException
Indicates if data manipulation statements are supported within a transaction.

Returns:
Always false. Data manipulation statements are not supported within a transaction.
Throws: SQLException
If an error occurs.
 o supportsDifferentTableCorrelationNames
 public boolean supportsDifferentTableCorrelationNames() throws SQLException
Indicates if table correlation names are supported, and if so, are they restricted to be different from the names of the tables.

Returns:
Always false. Table correlation names are not restricted to be different from the names of the tables.
Throws: SQLException
If an error occurs.
 o supportsExpressionsInOrderBy
 public boolean supportsExpressionsInOrderBy() throws SQLException
Indicates if expressions in ORDER BY lists are supported.

Returns:
Always false. Expression in ORDER BY lists are not supported.
Throws: SQLException
If an error occurs.
 o supportsExtendedSQLGrammar
 public boolean supportsExtendedSQLGrammar() throws SQLException
Indicates if the ODBC Extended SQL grammar is supported.

Returns:
Always false. The ODBC Extended SQL grammar is not supported.
Throws: SQLException
If an error occurs.
 o supportsFullOuterJoins
 public boolean supportsFullOuterJoins() throws SQLException
Indicates if full nested outer joins are supported.

Returns:
Always false. Full nested outer joins are not supported.
Throws: SQLException
If an error occurs.
 o supportsGroupBy
 public boolean supportsGroupBy() throws SQLException
Indicates if some form of the GROUP BY clause is supported.

Returns:
Always true. Some form of GROUP BY clause is supported.
Throws: SQLException
If an error occurs.
 o supportsGroupByBeyondSelect
 public boolean supportsGroupByBeyondSelect() throws SQLException
Indicates if a GROUP BY clause can add columns not in the SELECT provided it specifies all of the columns in the SELECT.

Returns:
Always true. A GROUP BY clause can add columns not in the SELECT provided it specifies all of the columns in the SELECT.
Throws: SQLException
If an error occurs.
 o supportsGroupByUnrelated
 public boolean supportsGroupByUnrelated() throws SQLException
Indicates if a GROUP BY clause can use columns not in the SELECT.

Returns:
Always true. A GROUP BY clause can use columns not in the SELECT.
Throws: SQLException
If an error occurs.
 o supportsIntegrityEnhancementFacility
 public boolean supportsIntegrityEnhancementFacility() throws SQLException
Indicates if the SQL Integrity Enhancement Facility is supported.

Returns:
Always false. The SQL Integrity Enhancement Facility is not supported.
Throws: SQLException
If an error occurs.
 o supportsLikeEscapeClause
 public boolean supportsLikeEscapeClause() throws SQLException
Indicates if the escape character in LIKE clauses is supported.

Returns:
Always true. The escape character in LIKE clauses is supported.
Throws: SQLException
If an error occurs.
 o supportsLimitedOuterJoins
 public boolean supportsLimitedOuterJoins() throws SQLException
Indicates if there is limited support for outer joins.

Returns:
Always true. There is limited support for outer joins.
Throws: SQLException
If an error occurs.
 o supportsMinimumSQLGrammar
 public boolean supportsMinimumSQLGrammar() throws SQLException
Indicates if the ODBC Minimum SQL grammar is supported.

Returns:
Always true. The ODBC Minimum SQL grammar is supported.
Throws: SQLException
If an error occurs.
 o supportsMixedCaseIdentifiers
 public boolean supportsMixedCaseIdentifiers() throws SQLException
Indicates if the database treats mixed case, unquoted SQL identifiers as case sensitive and stores them in mixed case.

Returns:
Always false. The database does not treat mixed case, unquoted SQL identifiers as case sensitive and as a result store them in mixed case.
Throws: SQLException
If an error occurs.
 o supportsMixedCaseQuotedIdentifiers
 public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException
Indicates if the database treats mixed case, quoted SQL identifiers as case sensitive and as a result stores them in mixed case.

Returns:
Always true. The database does treat mixed case, quoted SQL identifiers as case sensitive and stores them in mixed case.
Throws: SQLException
If an error occurs.
 o supportsMultipleResultSets
 public boolean supportsMultipleResultSets() throws SQLException
Indicates if multiple result sets from a single execute are supported.

Returns:
Always true. Multiple result sets from a single execute are supported.
Throws: SQLException
If an error occurs.
 o supportsMultipleTransactions
 public boolean supportsMultipleTransactions() throws SQLException
Indicates if multiple transactions can be open at once (on different connections).

Returns:
Always true. Multiple transactions can be open at once on different connections.
Throws: SQLException
If an error occurs.
 o supportsNonNullableColumns
 public boolean supportsNonNullableColumns() throws SQLException
Indicates if columns can be defined as non-nullable.

Returns:
Always true. Columns can be defined as non-nullable.
Throws: SQLException
If an error occurs.
 o supportsOpenCursorsAcrossCommit
 public boolean supportsOpenCursorsAcrossCommit() throws SQLException
Indicates if cursors can remain open across commits.

Returns:
Always true. Cursors can remain open across commits.
Throws: SQLException
If an error occurs.
 o supportsOpenCursorsAcrossRollback
 public boolean supportsOpenCursorsAcrossRollback() throws SQLException
Indicates if cursors can remain open across rollback.

Returns:
Always true. Cursors can remain open across rollback.
Throws: SQLException
If an error occurs.
 o supportsOpenStatementsAcrossCommit
 public boolean supportsOpenStatementsAcrossCommit() throws SQLException
Indicates if statements can remain open across commits.

Returns:
Always true. Statements can remain open across commits.
Throws: SQLException
If an error occurs.
 o supportsOpenStatementsAcrossRollback
 public boolean supportsOpenStatementsAcrossRollback() throws SQLException
Indicates if statements can remain open across rollback.

Returns:
Always true. Statements can remain open across rollback.
Throws: SQLException
If an error occurs.
 o supportsOrderByUnrelated
 public boolean supportsOrderByUnrelated() throws SQLException
Indicates if an ORDER BY clause can use columns not in the SELECT.

Returns:
Always false. ORDER BY cannot use columns not in the SELECT.
Throws: SQLException
If an error occurs.
 o supportsOuterJoins
 public boolean supportsOuterJoins() throws SQLException
Indicates if some form of outer join is supported.

Returns:
Always true. Some form of outer join is supported.
Throws: SQLException
If an error occurs.
 o supportsPositionedDelete
 public boolean supportsPositionedDelete() throws SQLException
Indicates if positioned DELETE is supported.

Returns:
Always true. Positioned DELETE is supported.
Throws: SQLException
If an error occurs.
 o supportsPositionedUpdate
 public boolean supportsPositionedUpdate() throws SQLException
Indicates if positioned UPDATE is supported.

Returns:
Always true. Positioned UPDATE is supported.
Throws: SQLException
If an error occurs.
 o supportsSchemasInDataManipulation
 public boolean supportsSchemasInDataManipulation() throws SQLException
Indicates if a schema name can be used in a data manipulation statement.

Returns:
Always true. A schema name can be used in a data manipulation statement.
Throws: SQLException
If an error occurs.
 o supportsSchemasInIndexDefinitions
 public boolean supportsSchemasInIndexDefinitions() throws SQLException
Indicates if a schema name can be used in an index definition statement.

Returns:
Always true. A schema name can be used in an index definition statement.
Throws: SQLException
If an error occurs.
 o supportsSchemasInPrivilegeDefinitions
 public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException
Indicates if a schema name be can used in a privilege definition statement.

Returns:
Always true. A schema name can be used in a privilege definition statement.
Throws: SQLException
If an error occurs.
 o supportsSchemasInProcedureCalls
 public boolean supportsSchemasInProcedureCalls() throws SQLException
Indicates if a schema name be can used in a procedure call statement.

Returns:
Always true. A schema name can be used in a procedure call statement.
Throws: SQLException
If an error occurs.
 o supportsSchemasInTableDefinitions
 public boolean supportsSchemasInTableDefinitions() throws SQLException
Indicates if a schema name can be used in a table definition statement.

Returns:
Always true. A schema name can be used in a table definition statement.
Throws: SQLException
If an error occurs.
 o supportsSelectForUpdate
 public boolean supportsSelectForUpdate() throws SQLException
Indicates if SELECT for UPDATE is supported.

Returns:
Always true. SELECT for UPDATE is supported.
Throws: SQLException
If an error occurs.
 o supportsStoredProcedures
 public boolean supportsStoredProcedures() throws SQLException
Indicates if stored procedure calls using the stored procedure escape syntax are supported.

Returns:
Always true. Stored procedure calls using the stored procedure escape syntax are supported.
Throws: SQLException
If an error occurs.
 o supportsSubqueriesInComparisons
 public boolean supportsSubqueriesInComparisons() throws SQLException
Indicates if subqueries in comparisons are supported.

Returns:
Always true. Subqueries in comparisons are supported.
Throws: SQLException
If an error occurs.
 o supportsSubqueriesInExists
 public boolean supportsSubqueriesInExists() throws SQLException
Indicates if subqueries in EXISTS expressions are supported.

Returns:
Always true. Subqueries in EXISTS expressions are supported.
Throws: SQLException
If an error occurs.
 o supportsSubqueriesInIns
 public boolean supportsSubqueriesInIns() throws SQLException
Indicates if subqueries in IN expressions are supported.

Returns:
Always true. Subqueries in IN expressions are supported.
Throws: SQLException
If an error occurs.
 o supportsSubqueriesInQuantifieds
 public boolean supportsSubqueriesInQuantifieds() throws SQLException
Indicates if subqueries in quantified expressions are supported.

Returns:
Always true. Subqueries in quantified expressions are supported.
Throws: SQLException
If an error occurs.
 o supportsTableCorrelationNames
 public boolean supportsTableCorrelationNames() throws SQLException
Indicates if table correlation names are supported.

Returns:
Always true. Table correlation names are supported.
Throws: SQLException
If an error occurs.
 o supportsTransactionIsolationLevel
 public boolean supportsTransactionIsolationLevel(int level) throws SQLException
Indicates if the database supports the given transaction isolation level.

Parameters:
level - One of the Connection.TRANSACTION_* values.
Returns:
true if the database supports the given transaction isolation level; false otherwise.
Throws: SQLException
If an error occurs.
 o supportsTransactions
 public boolean supportsTransactions() throws SQLException
Indicates if transactions are supported.

Returns:
Always true. Transactions are supported.
Throws: SQLException
If an error occurs.
 o supportsUnion
 public boolean supportsUnion() throws SQLException
Indicates if SQL UNION is supported.

Returns:
Always true. SQL UNION is supported.
Throws: SQLException
If an error occurs.
 o supportsUnionAll
 public boolean supportsUnionAll() throws SQLException
Indicates if SQL UNION ALL is supported.

Returns:
Always true. SQL UNION ALL is supported.
Throws: SQLException
If an error occurs.
 o toString
 public String toString()
Returns the name of the catalog.

Returns:
The name of the catalog.
Overrides:
toString in class Object
 o usesLocalFilePerTable
 public boolean usesLocalFilePerTable() throws SQLException
Indicates if the database uses a file for each table.

Returns:
Always false. The database does not use a file for each table.
Throws: SQLException
If an error occurs.
 o usesLocalFiles
 public boolean usesLocalFiles() throws SQLException
Indicates if the database stores tables in a local file.

Returns:
Always false. The database does not store tables in a local file.
Throws: SQLException
If an error occurs.

All Packages  Class Hierarchy  This Package  Previous  Next  Index