|
|||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||
PreparedStatement
object's batch of commands.
DatabaseManager,
DatabaseTable, and DatabaseIndex to represent database
errors that may occur.PreparedStatement object
and returns the result set generated by the query.
PreparedStatement object.
ResultSet
object's columns.
CREATE INDEX [indexname] ON tablename [USING indextype] (column);
CREATE TABLE tablename (column list);
CREATE INDEX [indexname] ON tablename [USING indextype] (column);
CREATE TABLE tablename (column list);
DELETE FROM tablename [ WHERE condition ]
DROP INDEX tablename.column;
DROP TABLE tablename;
DROP INDEX tablename.column;
DROP TABLE tablename;
INSERT INTO tablename (columns,...) VALUES (values,...);
INSERT INTO tablename (columns,...) SELECT ...;
UPDATE tablename SET columns [ WHERE condition ]
FunctionProvider to lookup the description if the function has not been set yet, and
Select.GroupByList to check for GROUP BY columns that need to be
forced to aggregate.
Array object.
java.math.BigDecimal value.
Blob object.
boolean value.
byte value.
Reader
object, which is the given number of characters long.
Clob object.
value.
- setDate(int, Date, Calendar) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to the given
java.sql.Date value,
using the given Calendar object.
- setDebugLevel(int) -
Static method in class ModSQL.Driver
- Set the desired debug level.
- setDistinct() -
Method in class ModSQL.AbstractAggregate
- Specify that this aggregate should eliminate duplicate values before
aggregating rows.
- setDistinct() -
Method in interface ModSQL.Aggregate
- Specify that this aggregate should eliminate duplicate values before
aggregating rows.
- setDouble(int, double) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to a Java
double value.
- setEscapeProcessing(boolean) -
Method in class ModSQL.PreparedStatement
- If escape scanning is on (the default), the driver will do
escape substitution before sending the SQL to the database.
- setFetchDirection(int) -
Method in class ModSQL.ResultSet
- Give a hint as to the direction in which the rows in this result set
will be processed.
- setFetchDirection(int) -
Method in class ModSQL.PreparedStatement
- Give a hint as to the direction in which the rows in a result set
will be processed.
- setFetchSize(int) -
Method in class ModSQL.ResultSet
- Give the JDBC driver a hint as to the number of rows that should
be fetched from the database when more rows are needed for this result
set.
- setFetchSize(int) -
Method in class ModSQL.PreparedStatement
- Give the JDBC driver a hint as to the number of rows that should
be fetched from the database when more rows are needed.
- setFloat(int, float) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to a Java
float value.
- setInt(int, int) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to a Java
int value.
- setLong(int, long) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to a Java
long value.
- setMaxFieldSize(int) -
Method in class ModSQL.PreparedStatement
- The maxFieldSize limit (in bytes) is set to limit the size of
data that can be returned for any column value; it only applies
to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and
LONGVARCHAR fields.
- setMaxRows(int) -
Method in class ModSQL.PreparedStatement
- The maxRows limit is set to limit the number of rows that any
ResultSet can contain.
- setNull(int, int) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to SQL
NULL.
- setNull(int, int, String) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to SQL
NULL.
- setObject(int, Object) -
Method in class ModSQL.PreparedStatement
- Sets the value of the designated parameter using the given object.
- setObject(int, Object, int) -
Method in class ModSQL.PreparedStatement
- Sets the value of the designated parameter with the given object.
- setObject(int, Object, int, int) -
Method in class ModSQL.PreparedStatement
- Sets the value of the designated parameter with the given object.
- setQueryTimeout(int) -
Method in class ModSQL.PreparedStatement
- The queryTimeout limit is the number of seconds the driver will
wait for a Statement to execute.
- setReadOnly(boolean) -
Method in class ModSQL.Connection
- You can put a connection in read-only mode as a hint to enable
database optimizations.
- setRef(int, Ref) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to the given
REF(<structured-type>) value.
- setShort(int, short) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to a Java
short value.
- setString(int, String) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to a Java
String value.
- setTable(Table) -
Method in class ModSQL.Operator_In
- Specify the table to be scanned.
- setTable(Table) -
Method in class ModSQL.Operator_Exists
- Specify the table to be scanned.
- setTime(int, Time) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to a
java.sql.Time value.
- setTime(int, Time, Calendar) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to the given
java.sql.Time value,
using the given Calendar object.
- setTimestamp(int, Timestamp) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to a
java.sql.Timestamp value.
- setTimestamp(int, Timestamp, Calendar) -
Method in class ModSQL.PreparedStatement
- Sets the designated parameter to the given
java.sql.Timestamp value,
using the given Calendar object.
- setTransactionIsolation(int) -
Method in class ModSQL.Connection
- You can call this method to try to change the transaction
isolation level using one of the TRANSACTION_* values.
- setTypeMap(Map) -
Method in class ModSQL.Connection
- Not implemented.
- setUnicodeStream(int, InputStream, int) -
Method in class ModSQL.PreparedStatement
- Deprecated.
- setupTableReader() -
Method in class ModSQL.Select
- Create and setup TableReader object (with no parent).
- setupTableReader(TableReader) -
Method in class ModSQL.Select
- Create and setup TableReader object.
- setValue(Object) -
Method in class ModSQL.ColumnValue
- Set cached value and mark the value as valid.
- sig -
Variable in class TemporaryDatabase.TableData
-
- SIGN -
Static variable in class ModSQL.Function_Math
- Function is SIGN().
- sign(Number) -
Static method in class ModSQL.NumberMath
- Determine the sign of a number.
- single_object -
Variable in class ModSQL.Operator_Is
- Single column row for use when we don't have a row-constructor.
- size -
Variable in class AsciiDatabase.ColumnProperties
-
- size -
Variable in class AsciiDatabase.SourceProperties
-
- size() -
Method in class TemporaryDatabase.TableData
-
- source -
Variable in class ModSQL.Insert
- Rows of data to insert.
- source -
Variable in class AsciiDatabase.RowId
-
- sourceid -
Variable in class AsciiDatabase.AsciiTable
- Current row within the current record.
- SourceProperties - class AsciiDatabase.SourceProperties.
- Properties of an individual column as it is read from the
data file.
- SourceProperties() -
Constructor for class AsciiDatabase.SourceProperties
-
- sources -
Variable in class AsciiDatabase.AsciiTable
- Properties of the table's source rows.
- SQLExceptionWithCause - exception ModSQL.SQLExceptionWithCause.
- Updated version of SQLException implementing Java 1.4 cause objects.
- SQLExceptionWithCause() -
Constructor for class ModSQL.SQLExceptionWithCause
- Default constructor.
- SQLExceptionWithCause(String) -
Constructor for class ModSQL.SQLExceptionWithCause
- Exception with a specific reason.
- SQLExceptionWithCause(String, Throwable) -
Constructor for class ModSQL.SQLExceptionWithCause
- Exception that was caused by some other exception.
- SQLExceptionWithCause(Throwable) -
Constructor for class ModSQL.SQLExceptionWithCause
- Exception that was caused by some other exception.
- sqlkeywords -
Static variable in class ModSQL.Expression
- List of SQL keywords.
- SQRT -
Static variable in class ModSQL.Function_Math
- Function is SQRT().
- sqrt(Number) -
Static method in class ModSQL.NumberMath
- Returns the correctly rounded positive square root of a Number object.
- SSN -
Variable in class SampleDatabase.EmployeeAddressTable_Row
-
- start_group -
Variable in class ModSQL.Select
- Index in columns of start of GROUP BY.
- start_having -
Variable in class ModSQL.Select
- Index in columns of start of HAVING.
- start_order -
Variable in class ModSQL.Select
- Index in columns of start of ORDER BY.
- start_where -
Variable in class ModSQL.Select
- Index in columns of start of WHERE.
- startrecordsize -
Static variable in class AsciiDatabase.AsciiTable
- Initial record size for variable length record files.
- State -
Variable in class SampleDatabase.EmployeeAddressTable_Row
-
- statement -
Variable in class ModSQL.ResultSet
- Statement that was used to generate this result set.
- STDEV -
Static variable in class ModSQL.Aggregate_Math
- Function is STDEV().
- storesLowerCaseIdentifiers() -
Method in class ModSQL.DatabaseMetaData
- Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in lower case?
- storesLowerCaseQuotedIdentifiers() -
Method in class ModSQL.DatabaseMetaData
- Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in lower case?
- storesMixedCaseIdentifiers() -
Method in class ModSQL.DatabaseMetaData
- Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in mixed case?
- storesMixedCaseQuotedIdentifiers() -
Method in class ModSQL.DatabaseMetaData
- Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in mixed case?
- storesUpperCaseIdentifiers() -
Method in class ModSQL.DatabaseMetaData
- Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in upper case?
- storesUpperCaseQuotedIdentifiers() -
Method in class ModSQL.DatabaseMetaData
- Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in upper case?
- stream -
Variable in class AsciiDatabase.AsciiReader
- Stream used for uncompressed file.
- streampos -
Variable in class AsciiDatabase.AsciiReader
- Current stream position.
- SUBSTR -
Static variable in class ModSQL.Function_String
- Function is SUBSTR().
- subtract(Number, Number) -
Static method in class ModSQL.NumberMath
- Subtract two Number objects to produce an appropriate Number object.
- SUM -
Static variable in class ModSQL.Aggregate_Math
- Function is SUM().
- sum_double -
Variable in class ModSQL.Aggregate_Math
- Current sum as a DOUBLE.
- sum_long -
Variable in class ModSQL.Aggregate_Math
- Current sum as a BIGINT.
- sum_square -
Variable in class ModSQL.Aggregate_Math
- Current sum of squares.
- supportsAlterTableWithAddColumn() -
Method in class ModSQL.DatabaseMetaData
- Is "ALTER TABLE" with add column supported?
- supportsAlterTableWithDropColumn() -
Method in class ModSQL.DatabaseMetaData
- Is "ALTER TABLE" with drop column supported?
- supportsANSI92EntryLevelSQL() -
Method in class ModSQL.DatabaseMetaData
- Is the ANSI92 entry level SQL grammar supported?
All JDBC-Compliant drivers must return true.
- supportsANSI92FullSQL() -
Method in class ModSQL.DatabaseMetaData
- Is the ANSI92 full SQL grammar supported?
- supportsANSI92IntermediateSQL() -
Method in class ModSQL.DatabaseMetaData
- Is the ANSI92 intermediate SQL grammar supported?
- supportsBatchUpdates() -
Method in class ModSQL.DatabaseMetaData
- Return true if the driver supports batch updates, else return false.
- supportsCatalogsInDataManipulation() -
Method in class ModSQL.DatabaseMetaData
- Can a catalog name be used in a data manipulation statement?
- supportsCatalogsInIndexDefinitions() -
Method in class ModSQL.DatabaseMetaData
- Can a catalog name be used in an index definition statement?
- supportsCatalogsInPrivilegeDefinitions() -
Method in class ModSQL.DatabaseMetaData
- Can a catalog name be used in a privilege definition statement?
- supportsCatalogsInProcedureCalls() -
Method in class ModSQL.DatabaseMetaData
- Can a catalog name be used in a procedure call statement?
- supportsCatalogsInTableDefinitions() -
Method in class ModSQL.DatabaseMetaData
- Can a catalog name be used in a table definition statement?
- supportsColumnAliasing() -
Method in class ModSQL.DatabaseMetaData
- Is column aliasing supported?
- supportsConvert() -
Method in class ModSQL.DatabaseMetaData
- Is the CONVERT function between SQL types supported?
- supportsConvert(int, int) -
Method in class ModSQL.DatabaseMetaData
- Is CONVERT between the given SQL types supported?
- supportsCoreSQLGrammar() -
Method in class ModSQL.DatabaseMetaData
- Is the ODBC Core SQL grammar supported?
- supportsCorrelatedSubqueries() -
Method in class ModSQL.DatabaseMetaData
- Are correlated subqueries supported?
A JDBC-Compliant driver always returns true.
- supportsDataDefinitionAndDataManipulationTransactions() -
Method in class ModSQL.DatabaseMetaData
- Are both data definition and data manipulation statements
within a transaction supported?
- supportsDataManipulationTransactionsOnly() -
Method in class ModSQL.DatabaseMetaData
- Are only data manipulation statements within a transaction
supported?
- supportsDifferentTableCorrelationNames() -
Method in class ModSQL.DatabaseMetaData
- If table correlation names are supported, are they restricted
to be different from the names of the tables?
- supportsExpressionsInOrderBy() -
Method in class ModSQL.DatabaseMetaData
- Are expressions in "ORDER BY" lists supported?
- supportsExtendedSQLGrammar() -
Method in class ModSQL.DatabaseMetaData
- Is the ODBC Extended SQL grammar supported?
- supportsFullOuterJoins() -
Method in class ModSQL.DatabaseMetaData
- Are full nested outer joins supported?
- supportsGroupBy() -
Method in class ModSQL.DatabaseMetaData
- Is some form of "GROUP BY" clause supported?
- supportsGroupByBeyondSelect() -
Method in class ModSQL.DatabaseMetaData
- Can a "GROUP BY" clause add columns not in the SELECT
provided it specifies all the columns in the SELECT?
- supportsGroupByUnrelated() -
Method in class ModSQL.DatabaseMetaData
- Can a "GROUP BY" clause use columns not in the SELECT?
- supportsIntegrityEnhancementFacility() -
Method in class ModSQL.DatabaseMetaData
- Is the SQL Integrity Enhancement Facility supported?
- supportsLikeEscapeClause() -
Method in class ModSQL.DatabaseMetaData
- Is the escape character in "LIKE" clauses supported?
A JDBC-Compliant driver always returns true.
- supportsLimitedOuterJoins() -
Method in class ModSQL.DatabaseMetaData
- Is there limited support for outer joins? (This will be true
if supportFullOuterJoins is true.)
- supportsMinimumSQLGrammar() -
Method in class ModSQL.DatabaseMetaData
- Is the ODBC Minimum SQL grammar supported?
All JDBC-Compliant drivers must return true.
- supportsMixedCaseIdentifiers() -
Method in class ModSQL.DatabaseMetaData
- Does the database treat mixed case unquoted SQL identifiers as
case sensitive and as a result store them in mixed case?
- supportsMixedCaseQuotedIdentifiers() -
Method in class ModSQL.DatabaseMetaData
- Does the database treat mixed case quoted SQL identifiers as
case sensitive and as a result store them in mixed case?
A JDBC-Compliant driver will always return true.
- supportsMultipleResultSets() -
Method in class ModSQL.DatabaseMetaData
- Are multiple ResultSets from a single execute supported?
- supportsMultipleTransactions() -
Method in class ModSQL.DatabaseMetaData
- Can we have multiple transactions open at once (on different
connections)?
- supportsNonNullableColumns() -
Method in class ModSQL.DatabaseMetaData
- Can columns be defined as non-nullable?
A JDBC-Compliant driver always returns true.
- supportsOpenCursorsAcrossCommit() -
Method in class ModSQL.DatabaseMetaData
- Can cursors remain open across commits?
- supportsOpenCursorsAcrossRollback() -
Method in class ModSQL.DatabaseMetaData
- Can cursors remain open across rollbacks?
- supportsOpenStatementsAcrossCommit() -
Method in class ModSQL.DatabaseMetaData
- Can statements remain open across commits?
- supportsOpenStatementsAcrossRollback() -
Method in class ModSQL.DatabaseMetaData
- Can statements remain open across rollbacks?
- supportsOrderByUnrelated() -
Method in class ModSQL.DatabaseMetaData
- Can an "ORDER BY" clause use columns not in the SELECT?
- supportsOuterJoins() -
Method in class ModSQL.DatabaseMetaData
- Is some form of outer join supported?
- supportsPositionedDelete() -
Method in class ModSQL.DatabaseMetaData
- Is positioned DELETE supported?
- supportsPositionedUpdate() -
Method in class ModSQL.DatabaseMetaData
- Is positioned UPDATE supported?
- supportsResultSetConcurrency(int, int) -
Method in class ModSQL.DatabaseMetaData
- Does the database support the concurrency type in combination
with the given result set type?
- supportsResultSetType(int) -
Method in class ModSQL.DatabaseMetaData
- Does the database support the given result set type?
- supportsSchemasInDataManipulation() -
Method in class ModSQL.DatabaseMetaData
- Can a schema name be used in a data manipulation statement?
- supportsSchemasInIndexDefinitions() -
Method in class ModSQL.DatabaseMetaData
- Can a schema name be used in an index definition statement?
- supportsSchemasInPrivilegeDefinitions() -
Method in class ModSQL.DatabaseMetaData
- Can a schema name be used in a privilege definition statement?
- supportsSchemasInProcedureCalls() -
Method in class ModSQL.DatabaseMetaData
- Can a schema name be used in a procedure call statement?
- supportsSchemasInTableDefinitions() -
Method in class ModSQL.DatabaseMetaData
- Can a schema name be used in a table definition statement?
- supportsSelectForUpdate() -
Method in class ModSQL.DatabaseMetaData
- Is SELECT for UPDATE supported?
- supportsStoredProcedures() -
Method in class ModSQL.DatabaseMetaData
- Are stored procedure calls using the stored procedure escape
syntax supported?
- supportsSubqueriesInComparisons() -
Method in class ModSQL.DatabaseMetaData
- Are subqueries in comparison expressions supported?
A JDBC-Compliant driver always returns true.
- supportsSubqueriesInExists() -
Method in class ModSQL.DatabaseMetaData
- Are subqueries in 'exists' expressions supported?
A JDBC-Compliant driver always returns true.
- supportsSubqueriesInIns() -
Method in class ModSQL.DatabaseMetaData
- Are subqueries in 'in' statements supported?
A JDBC-Compliant driver always returns true.
- supportsSubqueriesInQuantifieds() -
Method in class ModSQL.DatabaseMetaData
- Are subqueries in quantified expressions supported?
A JDBC-Compliant driver always returns true.
- supportsTableCorrelationNames() -
Method in class ModSQL.DatabaseMetaData
- Are table correlation names supported?
A JDBC-Compliant driver always returns true.
- supportsTransactionIsolationLevel(int) -
Method in class ModSQL.DatabaseMetaData
- Does the database support the given transaction isolation level?
- supportsTransactions() -
Method in class ModSQL.DatabaseMetaData
- Are transactions supported? If not, commit is a noop and the
isolation level is TRANSACTION_NONE.
- supportsUnion() -
Method in class ModSQL.DatabaseMetaData
- Is SQL UNION supported?
- supportsUnionAll() -
Method in class ModSQL.DatabaseMetaData
- Is SQL UNION ALL supported?
- sval -
Variable in class AsciiDatabase.ColumnOption
-
|
|||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||