< A B C D E F G H I J L M N O P Q R S T U V W Y Z

<

() - Static method in class ModSQL.Driver
Attempt to register a new instance of this class with the DriverManager.
() - Static method in class ModSQL.DriverConfig
Read configuration file.

A

ABS - Static variable in class ModSQL.Function_Math
Function is ABS().
abs(Number) - Static method in class ModSQL.NumberMath
Returns the absolute value of a Number object.
absolute(int) - Method in class ModSQL.ResultSet
Move to an absolute row number in the result set.
absolute(Object) - Method in interface ModSQL.DatabaseTable
Move to an absolute rowid in the table.
absolute(Object) - Method in class ModSQL.SelectTable
Move to an absolute rowid in the table.
absolute(Object) - Method in class SampleDatabase.TableTemplate
 
absolute(Object) - Method in class TemporaryDatabase.Table
 
absolute(Object) - Method in class AsciiDatabase.AsciiTable
Seek to an absolute row id.
AbstractAggregate - class ModSQL.AbstractAggregate.
Abstract implementation of Aggregate to simplify the implementation of real aggregate functions.
AbstractAggregate() - Constructor for class ModSQL.AbstractAggregate
 
AbstractFunction - class ModSQL.AbstractFunction.
Abstract implementation of Function to simplify the implementation of real functions.
AbstractFunction() - Constructor for class ModSQL.AbstractFunction
Default constructor.
acceptsURL(String) - Method in class ModSQL.Driver
Returns true if the driver thinks that it can open a connection to the given URL.
access() - Method in class TemporaryDatabase.TableData
 
add() - Method in class TemporaryDatabase.TableData
Add a new row.
Add(Number, double) - Static method in class AsciiDatabase.AsciiTable
Add a double to a Number.
add(Number, Number) - Static method in class ModSQL.NumberMath
Add two Number objects to produce an appropriate Number object.
add(Object, long) - Method in class ModSQL.IndexTableRowset
Add count rows starting at rowid.
addAllParameters(Function) - Method in class ModSQL.Operator
Add all of x's parameters to this function.
addAllParametersNegate(Function) - Method in class ModSQL.Operator
Add all of x's parameters to this function but apply the negation operator to each before adding them.
addAllParametersNot(Function) - Method in class ModSQL.Operator
Add all of x's parameters to this function but apply the NOT operator to each before adding them.
addBatch() - Method in class ModSQL.PreparedStatement
Adds a set of parameters to this PreparedStatement object's batch of commands.
addBatch(String) - Method in class ModSQL.PreparedStatement
Adds a SQL command to the current batch of commmands for the statement.
addColumn(String, int, int) - Method in interface ModSQL.DatabaseTable
Add a new column to the table.
addColumn(String, int, int) - Method in class ModSQL.SelectTable
Add a new column.
addColumn(String, int, int) - Method in class SampleDatabase.TableTemplate
 
addColumn(String, int, int) - Method in class TemporaryDatabase.Table
 
addColumn(String, int, int) - Method in class AsciiDatabase.AsciiTable
Add a column to the database.
AddDataFile(String) - Method in class AsciiDatabase.AsciiTable
Add a new data file to the table.
addDistinctValue(Object) - Method in class ModSQL.AbstractAggregate
Add a value to the set of distinct values.
addParameter(Function) - Method in class ModSQL.AbstractFunction
Adds a parameter to the list of parameters maintained by this function.
addParameter(Function) - Method in class ModSQL.Operator_Logical
Adds a function to the list of parameters maintained by this operator.
addParameter(Function) - Method in class ModSQL.Operator_Add
Adds a function to the list of parameters maintained by this operator.
addParameter(Function) - Method in class ModSQL.IndirectFunction
Adds a parameter to the list of parameters.
addParameter(Function) - Method in class ModSQL.Select
Adds a value (function) to the list of parameters maintained by this function.
addParameter(Function) - Method in class ModSQL.Literal
Adds a parameter to the list of parameters.
addParameter(Function) - Method in class ModSQL.ColumnValue
Adds a parameter to the list of parameters.
addParameter(Function) - Method in interface ModSQL.Function
Adds a value (function) to the list of parameters required by this function.
addParameter(Function) - Method in class ModSQL.Aggregate_Count
Adds a value (function) to the list of parameters maintained by this function.
addParameter(Function) - Method in class ModSQL.Operator_Multiply
Adds a function to the list of parameters maintained by this operator.
Address - Variable in class SampleDatabase.EmployeeAddressTable_Row
 
addRow() - Method in interface ModSQL.DatabaseTable
Add a new row to the database.
addRow() - Method in class ModSQL.SelectTable
Add a new row.
addRow() - Method in class SampleDatabase.TableTemplate
 
addRow() - Method in class TemporaryDatabase.Table
 
addRow() - Method in class AsciiDatabase.AsciiTable
Add a new row.
addRow(Function) - Method in class ModSQL.LiteralTable
Add a row to the table.
after_last - Variable in class ModSQL.IndexTable_Sort
 
after_last - Variable in class ModSQL.IndexTable_Hash
 
afterlast - Variable in class ModSQL.SelectTable
Are we after the last row?
afterLast() - Method in class ModSQL.ResultSet
Moves to the end of the result set, just after the last row.
afterLast() - Method in class ModSQL.IndexTable_Sort
 
afterLast() - Method in class ModSQL.IndexTable_Hash
 
afterLast() - Method in interface ModSQL.DatabaseTableBase
Moves the table cursor to a position after the last row in the table.
afterLast() - Method in class ModSQL.SelectTable
Set current row to after last row in table.
afterLast() - Method in class SampleDatabase.TableTemplate
 
afterLast() - Method in class TemporaryDatabase.Table
 
afterLast() - Method in class AsciiDatabase.AsciiTable
Position pointer after last row.
aggregate - Variable in class ModSQL.Select
Are we grouping or aggregating?
Aggregate - interface ModSQL.Aggregate.
Refinement of Function interface for aggregate functions.
Aggregate_Count - class ModSQL.Aggregate_Count.
Implementation of SQL aggregate function COUNT().
Aggregate_Count() - Constructor for class ModSQL.Aggregate_Count
 
Aggregate_Math - class ModSQL.Aggregate_Math.
Implementation of SQL aggregate functions SUM(), AVG() and STDEV().
Aggregate_Math(int) - Constructor for class ModSQL.Aggregate_Math
Constructor.
Aggregate_MinMax - class ModSQL.Aggregate_MinMax.
Implementation of SQL aggregate functions MIN() and MAX().
Aggregate_MinMax(boolean) - Constructor for class ModSQL.Aggregate_MinMax
Constructor.
aliases - Variable in class ModSQL.TableReader
Aliases for open tables.
all_constant - Variable in class ModSQL.AbstractFunction
Are all parameters constant?
allProceduresAreCallable() - Method in class ModSQL.DatabaseMetaData
Can all the procedures returned by getProcedures be called by the current user?
allTablesAreSelectable() - Method in class ModSQL.DatabaseMetaData
Can all the tables returned by getTable be SELECTed by the current user?
and - Variable in class ModSQL.Operator_Logical
True for AND, false for OR.
AntiqueOwners_Row - class SampleDatabase.AntiqueOwners_Row.
See TableTemplate for information about this class.
AntiqueOwners_Row(String, String, String) - Constructor for class SampleDatabase.AntiqueOwners_Row
 
AntiqueOwners_Table - class SampleDatabase.AntiqueOwners_Table.
See TableTemplate for information about this class.
AntiqueOwners_Table() - Constructor for class SampleDatabase.AntiqueOwners_Table
 
Antiques_Row - class SampleDatabase.Antiques_Row.
See TableTemplate for information about this class.
Antiques_Row(String, String, String, double) - Constructor for class SampleDatabase.Antiques_Row
 
Antiques_Table - class SampleDatabase.Antiques_Table.
See TableTemplate for information about this class.
Antiques_Table() - Constructor for class SampleDatabase.Antiques_Table
 
AsciiDatabase - package AsciiDatabase
 
AsciiReader - class AsciiDatabase.AsciiReader.
A fully buffered, random access reader capable of reading both fixed sized blocks and carrage return terminated lines.
AsciiReader(String) - Constructor for class AsciiDatabase.AsciiReader
Open an uncompressed file by name.
AsciiReader(String, boolean) - Constructor for class AsciiDatabase.AsciiReader
Open an uncompressed or compressed file by name.
AsciiTable - class AsciiDatabase.AsciiTable.
A DatabaseTable that can represent any flat ascii file as a table for ModSQL to query.
AsciiTable(String, String) - Constructor for class AsciiDatabase.AsciiTable
Open existing table.
AsciiTable(String, String, String) - Constructor for class AsciiDatabase.AsciiTable
Opens existing table.
AVG - Static variable in class ModSQL.Aggregate_Math
Function is AVG().

B

before_first - Variable in class ModSQL.IndexTable_Sort
 
before_first - Variable in class ModSQL.IndexTable_Hash
 
beforefirst - Variable in class ModSQL.ResultSet
True if we are before the first row.
beforefirst - Variable in class ModSQL.SelectTable
Are we before the first row?
beforeFirst() - Method in class ModSQL.ResultSet
Moves to the front of the result set, just before the first row.
beforeFirst() - Method in class ModSQL.Select
Reset the table to before the first row.
beforeFirst() - Method in interface ModSQL.Table
Reset the table to before the first row.
beforeFirst() - Method in class ModSQL.IndexTable_Sort
 
beforeFirst() - Method in class ModSQL.IndexTable_Hash
 
beforeFirst() - Method in interface ModSQL.DatabaseTableBase
Moves the table cursor to a position before the first row in the table.
beforeFirst() - Method in class ModSQL.SelectTable
Reset current row to before the first row in table.
beforeFirst() - Method in class ModSQL.LiteralTable
Reset the table to before the first row.
beforeFirst() - Method in class SampleDatabase.TableTemplate
 
beforeFirst() - Method in class TemporaryDatabase.Table
 
beforeFirst() - Method in class AsciiDatabase.AsciiTable
Position pointer before first row.
Benefits - Variable in class SampleDatabase.EmployeeStatisticsTable_Row
 
BETWEEN - Static variable in class ModSQL.Operator_Compare
Comparison operator (between).
binfileVersion - Static variable in class AsciiDatabase.AsciiTable
Version number of compiled table definition file.
buffer - Variable in class ModSQL.IndexTable_Sort
 
buffer - Variable in class ModSQL.IndexTable_Hash
 
buffer - Variable in class AsciiDatabase.AsciiReader
Buffer used to improve performance of small reads.
buffersize - Static variable in class AsciiDatabase.AsciiReader
Default buffer size for uncompressed files.
BUFFERSIZE - Static variable in class ModSQL.IndexTable_Sort
 
BUFFERSIZE - Static variable in class ModSQL.IndexTable_Hash
 
BuyerID - Variable in class SampleDatabase.Antiques_Row
 

C

calculateTableSignature() - Method in class AsciiDatabase.AsciiTable
Calculate a unique signature for this table.
cancel() - Method in class ModSQL.PreparedStatement
Cancel can be used by one thread to cancel a statement that is being executed by another thread.
cancelRowUpdates() - Method in class ModSQL.ResultSet
The cancelRowUpdates() method may be called after calling an updateXXX() method(s) and before calling updateRow() to rollback the updates made to a row.
cardinality(BitSet) - Static method in class ModSQL.TableReader
Implements java.util.BitSet.cardinality().
cause - Variable in class ModSQL.SQLExceptionWithCause
Cause of exception.
CEIL - Static variable in class ModSQL.Function_Math
Function is CEIL().
ceil(Number) - Static method in class ModSQL.NumberMath
Returns the smallest (closest to negative infinity) Number that is not less than the argument and is equal to a mathematical integer.
City - Variable in class SampleDatabase.EmployeeAddressTable_Row
 
clearBatch() - Method in class ModSQL.PreparedStatement
Make the set of commands in the current batch empty.
clearParameters() - Method in class ModSQL.PreparedStatement
Clears the current parameter values immediately.
clearWarnings() - Method in class ModSQL.ResultSet
After this call getWarnings returns null until a new warning is reported for this ResultSet.
clearWarnings() - Method in class ModSQL.Connection
After this call, getWarnings returns null until a new warning is reported for this Connection.
clearWarnings() - Method in class ModSQL.PreparedStatement
After this call, getWarnings returns null until a new warning is reported for this Statement.
close() - Method in class ModSQL.ResultSet
In some cases, it is desirable to immediately release a ResultSet's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.
close() - Method in class ModSQL.Select
Close all tables.
close() - Method in class ModSQL.Connection
In some cases, it is desirable to immediately release a Connection's database and JDBC resources instead of waiting for them to be automatically released; the close method provides this immediate release.
close() - Method in class ModSQL.IndexTable_Sort
 
close() - Method in class ModSQL.IndexTable_Hash
 
close() - Method in interface ModSQL.DatabaseTableBase
In some cases, it is desirable to immediately release a DatabaseTable's database and other resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.
close() - Method in class ModSQL.Insert
Close query and free resources in use.
close() - Method in class ModSQL.PreparedStatement
In many cases, it is desirable to immediately release a Statements's database and JDBC resources instead of waiting for this to happen when it is automatically closed; the close method provides this immediate release.
close() - Method in class ModSQL.Drop
Close query and free resources in use.
close() - Method in class ModSQL.SelectTable
Close the query.
close() - Method in interface ModSQL.Query
Close the query and free all resources in use.
close() - Method in class ModSQL.Create
Close query and free resources in use.
close() - Method in class ModSQL.Update
Close query and free resources in use.
close() - Method in class ModSQL.Delete
Close query and free resources in use.
close() - Method in class SampleDatabase.TableTemplate
 
close() - Method in class TemporaryDatabase.Table
 
close() - Method in class AsciiDatabase.RCFile
Close the configuration file.
close() - Method in class AsciiDatabase.AsciiReader
Close the data file.
close() - Method in class AsciiDatabase.AsciiTable
Close the table.
column - Variable in class ModSQL.ColumnValue
Index of column within table.
Column - class TemporaryDatabase.Column.
Column data.
column_index - Variable in class ModSQL.Insert
Array of indices of columns to insert (set by optimize).
column_index - Variable in class ModSQL.Update
Array of indices of columns to update (set by optimize).
column_names - Variable in class ModSQL.Select
Names of columns.
column_names - Variable in class ModSQL.Create
Names of columns to include in new table.
column_type - Variable in class ModSQL.Insert
Array of column types (set by optimize).
column_type - Variable in class ModSQL.Update
Array of column types (set by optimize).
column_types - Variable in class ModSQL.LiteralTable
Type of each column in table.
column_types - Variable in class ModSQL.Create
SQL types of columns to create.
column_values - Variable in class ModSQL.Select
Column values for current row.
Column(String, int, int) - Constructor for class TemporaryDatabase.Column
 
columnindex - Variable in class ModSQL.IndexTable_Sort
 
columnindex - Variable in class ModSQL.IndexTable_Hash
 
ColumnOption - class AsciiDatabase.ColumnOption.
Options to be applied to column data after it has been loaded.
ColumnOption(String) - Constructor for class AsciiDatabase.ColumnOption
 
ColumnProperties - class AsciiDatabase.ColumnProperties.
Properties of an individual column of the table.
ColumnProperties() - Constructor for class AsciiDatabase.ColumnProperties
 
columns - Variable in class ModSQL.Select
Array of columns to select.
columns - Variable in class ModSQL.TableReader
Array of referenced columns.
columns - Variable in class ModSQL.Insert
Array of column names to insert.
columns - Variable in class TemporaryDatabase.TableData
 
columns - Variable in class AsciiDatabase.AsciiTable
Properties of the table's columns.
columntype - Variable in class ModSQL.IndexTable_Sort
 
columntype - Variable in class ModSQL.IndexTable_Hash
 
columnType(int[]) - Static method in class ModSQL.Create
Returns a String representation of an SQL type.
ColumnValue - class ModSQL.ColumnValue.
This object is used to retrieve the value of specific of a database table.
ColumnValue(TableReader, int, int) - Constructor for class ModSQL.ColumnValue
Constructor.
commit() - Method in class ModSQL.Connection
Commit makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.
commitUpdates() - Method in class ModSQL.IndexTable_Sort
 
commitUpdates() - Method in class ModSQL.IndexTable_Hash
 
commitUpdates() - Method in interface ModSQL.DatabaseTableBase
ModSQL will always call this method after performing a series of updateObject() calls on a particular row.
commitUpdates() - Method in class ModSQL.TableReader
Commit updated columns to database.
commitUpdates() - Method in class ModSQL.SelectTable
Commit column updates.
commitUpdates() - Method in class SampleDatabase.TableTemplate
 
commitUpdates() - Method in class TemporaryDatabase.Table
 
commitUpdates() - Method in class AsciiDatabase.AsciiTable
 
compare_type - Variable in class ModSQL.Operator_Compare
Per column comparison type.
compare_type - Variable in class ModSQL.Operator_In
Per column comparison type.
compare(Object, Object) - Method in class ModSQL.Select.OrderByComparator
Compare two arrays of the type Object[][].
compare(Object, Object, int) - Static method in class ModSQL.Operator_Compare
Compare two objects by converting to a common type.
compareTo(Object) - Method in class ModSQL.IndexTableEntry
Compare the column value to another column value or to the column value of another IndexTableEntry.
compiledExtension - Static variable in class AsciiDatabase.AsciiTable
Filename extension applied to compiled table definition files.
connect(String, Properties) - Method in class ModSQL.Driver
Try to make a database connection to the given URL.
connection - Variable in class ModSQL.PreparedStatement
Connection that created this statement.
Connection - class ModSQL.Connection.
A Connection represents a session with a specific database.
Connection() - Constructor for class ModSQL.Connection
Constructor.
constant_non_null - Variable in class ModSQL.AbstractFunction
Are all of the constant parameters non-null?
constant_result - Variable in class ModSQL.Operator_Exists
If is_constant, this variable holds the constant result.
constant_value - Variable in class ModSQL.Operator_Logical
Result of operator applied to all constant parameters.
constant_value - Variable in class ModSQL.Operator_Add
Sum of all constant parameters.
constant_value - Variable in class ModSQL.Operator_Multiply
Product of constant parameters.
convertToSQLType(Object, int) - Static method in class ModSQL.AbstractFunction
Convert an Object to a compatible Object corresponding to the provided SQL type.
count - Variable in class ModSQL.Aggregate_Math
Current count of non-null values.
count - Variable in class ModSQL.IndexTableRowset
Array of counts (number of rows beginning with rowid).
count - Variable in class ModSQL.Aggregate_Count
Current count.
count_all - Variable in class ModSQL.Aggregate_Count
True if we are counting rows, false to count non-null values.
count_array - Variable in class ModSQL.IndexTableRowset
Temporary array of counts.
Create - class ModSQL.Create.
Create will parse a CREATE SQL statement.
Create(StreamTokenizer, DatabaseManager) - Constructor for class ModSQL.Create
Contructor to parse query.
createIndex(DatabaseManager, String, int) - Static method in class ModSQL.IndexTable_Sort
Create new index.
createIndex(DatabaseManager, String, int) - Static method in class ModSQL.IndexTable_Hash
Create new index.
createIndex(DatabaseManager, String, String) - Static method in class ModSQL.IndexTable_Sort
Create new index.
createIndex(DatabaseManager, String, String) - Static method in class ModSQL.IndexTable_Hash
Create new index.
createIndex(DatabaseTable, int) - Static method in class ModSQL.IndexTable_Sort
Create new index.
createIndex(DatabaseTable, int) - Static method in class ModSQL.IndexTable_Hash
Create new index.
createIndex(String, String) - Method in interface ModSQL.DatabaseManager
Create an index of the specified column in the specified table (if capable).
createIndex(String, String) - Method in class ModSQL.MetaManager
Create an index of the specified column in the specified table (if capable).
createIndex(String, String) - Method in class SampleDatabase.Manager
 
createIndex(String, String) - Method in class TemporaryDatabase.Manager
 
createIndex(String, String) - Method in class AsciiDatabase.Manager
Create an index of the specifed column in the specified table.
createStatement() - Method in class ModSQL.Connection
SQL statements without parameters are normally executed using Statement objects.
createStatement(int, int) - Method in class ModSQL.Connection
Same as createStatement() above, but allows the default result set type and result set concurrency type to be overridden.
createTable(String, boolean) - Method in interface ModSQL.DatabaseManager
Create a new table.
createTable(String, boolean) - Method in class ModSQL.MetaManager
Create a new table using the first manager that will host it.
createTable(String, boolean) - Method in class SampleDatabase.Manager
 
createTable(String, boolean) - Method in class TemporaryDatabase.Manager
 
createTable(String, boolean) - Method in class AsciiDatabase.Manager
Create the named table.
current_count - Variable in class ModSQL.IndexTable_Sort
 
current_count - Variable in class ModSQL.IndexTable_Hash
 
current_data - Variable in class ModSQL.IndexTable_Hash
 
current_entry - Variable in class ModSQL.IndexTable_Sort
 
current_index - Variable in class ModSQL.IndexTable_Sort
 
current_index - Variable in class ModSQL.IndexTable_Hash
 
current_iterator - Variable in class ModSQL.IndexTable_Hash
 
current_row - Variable in class ModSQL.Select
Current row in cached rows.
current_row - Variable in class ModSQL.LiteralTable
Index of current row (-1 for before first).
current_rowset - Variable in class ModSQL.IndexTable_Hash
 
current_value - Variable in class ModSQL.LiteralTable
Value of current row (null for before first or after last).
currentrow - Variable in class TemporaryDatabase.Table
 

D

data - Variable in class ModSQL.IndexTableEntry
Column value.
data - Variable in class TemporaryDatabase.Table
 
DatabaseException - exception ModSQL.DatabaseException.
An exception for use by classes implementing DatabaseManager, DatabaseTable, and DatabaseIndex to represent database errors that may occur.
DatabaseException() - Constructor for class ModSQL.DatabaseException
Default constructor.
DatabaseException(String) - Constructor for class ModSQL.DatabaseException
Exception with a specific reason.
DatabaseException(String, Throwable) - Constructor for class ModSQL.DatabaseException
Exception that was caused by some other exception.
DatabaseException(Throwable) - Constructor for class ModSQL.DatabaseException
Exception that was caused by some other exception.
DatabaseIndex - interface ModSQL.DatabaseIndex.
Interface to be implemented by table indices.
DatabaseManager - interface ModSQL.DatabaseManager.
Interface to be implemented by database managers.
DatabaseMetaData - class ModSQL.DatabaseMetaData.
This class provides information about the database as a whole.
DatabaseMetaData() - Constructor for class ModSQL.DatabaseMetaData
Default constructor.
DatabaseTable - interface ModSQL.DatabaseTable.
Interface to be implemented by classes representing database tables.
DatabaseTableBase - interface ModSQL.DatabaseTableBase.
Base interface for DatabaseTable and DatabaseIndex.
dataDefinitionCausesTransactionCommit() - Method in class ModSQL.DatabaseMetaData
Does a data definition statement within a transaction force the transaction to commit?
dataDefinitionIgnoredInTransactions() - Method in class ModSQL.DatabaseMetaData
Is a data definition statement within a transaction ignored?
dataoffset - Variable in class AsciiDatabase.AsciiTable
Offset of start of data within data files.
datastream - Variable in class AsciiDatabase.AsciiTable
List of data file to read data from.
debugLevel - Static variable in class ModSQL.DriverConfig
Debug level (0 for no debug messages).
defasciiconf - Static variable in class AsciiDatabase.Manager
Default config file location for AsciiDatabase
DEFAULT_HASHTABLE_SIZE - Static variable in class ModSQL.DriverConfig
Default size for internal hash tables (if not set in config file).
Delete - class ModSQL.Delete.
Delete will parse and execute an SQL DELETE query.
Delete(StreamTokenizer, DatabaseManager) - Constructor for class ModSQL.Delete
Contructor to parse query.
deleteRow() - Method in class ModSQL.ResultSet
Delete the current row from the result set and the underlying database.
deleteRow() - Method in class ModSQL.IndexTable_Sort
 
deleteRow() - Method in class ModSQL.IndexTable_Hash
 
deleteRow() - Method in interface ModSQL.DatabaseTableBase
Delete the current row from the table and the underlying database.
deleteRow() - Method in class ModSQL.TableReader
Delete current row.
deleteRow() - Method in class ModSQL.SelectTable
Delete current row.
deleteRow() - Method in class SampleDatabase.TableTemplate
 
deleteRow() - Method in class TemporaryDatabase.Table
 
deleteRow() - Method in class AsciiDatabase.AsciiTable
Delete the current row.
deletesAreDetected(int) - Method in class ModSQL.DatabaseMetaData
Determine whether or not a visible row delete can be detected by calling ResultSet.rowDeleted().
delimiter - Variable in class AsciiDatabase.AsciiTable
Delimiter for delimited files.
delimitFields() - Method in class AsciiDatabase.AsciiTable
Delimit fields.
description - Variable in class ModSQL.IndirectFunction
Text description of function (usually a column name).
distinct - Variable in class ModSQL.AbstractAggregate
True if the aggregate should eliminate duplicate values before aggregating.
distinct - Variable in class ModSQL.Select
True if SELECT DISTINCT.
distinct_set - Variable in class ModSQL.AbstractAggregate
Hash table used to eliminate duplicate values.
distinct_set - Variable in class ModSQL.Select
HashSet used to detect and remove duplicate rows.
Divide(Number, double) - Static method in class AsciiDatabase.AsciiTable
Divide a Number by a double.
divide(Number, Number) - Static method in class ModSQL.NumberMath
Divide two Number objects to produce an appropriate Number object.
doesMaxRowSizeIncludeBlobs() - Method in class ModSQL.DatabaseMetaData
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
Driver - class ModSQL.Driver.
JDBC Driver object.
Driver() - Constructor for class ModSQL.Driver
Default constructor.
DriverConfig - class ModSQL.DriverConfig.
Configuration data for ModSQL.
DriverConfig() - Constructor for class ModSQL.DriverConfig
Constructor.
Drop - class ModSQL.Drop.
Drop will parse a DROP sql statement.
Drop(StreamTokenizer, DatabaseManager) - Constructor for class ModSQL.Drop
Contructor to parse query.
dropIndex(String, String) - Method in interface ModSQL.DatabaseManager
Drop an index.
dropIndex(String, String) - Method in class ModSQL.MetaManager
Drop an index.
dropIndex(String, String) - Method in class SampleDatabase.Manager
 
dropIndex(String, String) - Method in class TemporaryDatabase.Manager
 
dropIndex(String, String) - Method in class AsciiDatabase.Manager
Delete the specified index.
dropTable(String) - Method in interface ModSQL.DatabaseManager
Drop a table.
dropTable(String) - Method in class ModSQL.MetaManager
Drop a table.
dropTable(String) - Method in class SampleDatabase.Manager
 
dropTable(String) - Method in class TemporaryDatabase.Manager
 
dropTable(String) - Method in class AsciiDatabase.Manager
Delete the specified table.

E

EmployeeAddressTable_Row - class SampleDatabase.EmployeeAddressTable_Row.
See TableTemplate for information about this class.
EmployeeAddressTable_Row(String, String, String, String, String, String) - Constructor for class SampleDatabase.EmployeeAddressTable_Row
 
EmployeeAddressTable_Table - class SampleDatabase.EmployeeAddressTable_Table.
See TableTemplate for information about this class.
EmployeeAddressTable_Table() - Constructor for class SampleDatabase.EmployeeAddressTable_Table
 
EmployeeIDNo - Variable in class SampleDatabase.EmployeeStatisticsTable_Row
 
EmployeeStatisticsTable_Row - class SampleDatabase.EmployeeStatisticsTable_Row.
See TableTemplate for information about this class.
EmployeeStatisticsTable_Row(String, int, int, String) - Constructor for class SampleDatabase.EmployeeStatisticsTable_Row
 
EmployeeStatisticsTable_Table - class SampleDatabase.EmployeeStatisticsTable_Table.
See TableTemplate for information about this class.
EmployeeStatisticsTable_Table() - Constructor for class SampleDatabase.EmployeeStatisticsTable_Table
 
EndOfTable - class ModSQL.EndOfTable.
A throwable to indicate that the end of a table has been reached.
EndOfTable(TableReader) - Constructor for class ModSQL.EndOfTable
Constructor.
entries - Variable in class ModSQL.IndexTable_Sort
 
entries_to_read - Variable in class ModSQL.IndexTable_Sort
 
EQU - Static variable in class ModSQL.Operator_Compare
Comparison operator (equal).
EQU - Static variable in class ModSQL.Operator_In
Comparison operator (equal).
equal(Object, Object, int) - Static method in class ModSQL.Operator_Compare
Check if two objects are equal by converting to a common type.
equals(ColumnProperties) - Method in class AsciiDatabase.ColumnProperties
 
equals(Object) - Method in class ModSQL.Select.OrderByComparator
Test if the two comparators are from the same Select object.
equals(Object) - Method in class ModSQL.IndexTableEntry
Test if the column value is equal to another column value or the column value of another IndexTableEntry.
equals(Object) - Method in class AsciiDatabase.RowId
 
evaluate_order - Variable in class ModSQL.AbstractFunction
Order in which to evaluate parameters.
evaluate_order_array - Variable in class ModSQL.AbstractFunction
Parameter ordering before optimize.
evaluate(boolean) - Method in class ModSQL.Operator_Logical
Evaluate parameters and compute the function.
evaluate(boolean) - Method in class ModSQL.Operator_Add
Evaluate parameters and compute sum.
evaluate(boolean) - Method in class ModSQL.IndirectFunction
Evaluate the function and return the result.
evaluate(boolean) - Method in class ModSQL.Select
Evaluate parameters and compute the function.
evaluate(boolean) - Method in class ModSQL.Function_Math
Evaluate parameters and compute function.
evaluate(boolean) - Method in class ModSQL.Operator_Is
Evaluate parameters and compute the function.
evaluate(boolean) - Method in class ModSQL.Operator_Negate
Evaluate parameter and negate.
evaluate(boolean) - Method in class ModSQL.Operator_Not
Evaluate parameter and invert.
evaluate(boolean) - Method in class ModSQL.Operator_Concat
Evaluate parameters and compute the function.
evaluate(boolean) - Method in class ModSQL.LiteralRow
Evaluate row.
evaluate(boolean) - Method in class ModSQL.Function_NVL
Evaluate parameters and compute the function.
evaluate(boolean) - Method in class ModSQL.Literal
Returns the literal value.
evaluate(boolean) - Method in class ModSQL.Aggregate_Math
Evaluate parameters and update count and sums.
evaluate(boolean) - Method in class ModSQL.Aggregate_MinMax
Evaluate parameter and check for new minimum/maximum.
evaluate(boolean) - Method in class ModSQL.Function_String
Evaluate parameters and compute function.
evaluate(boolean) - Method in class ModSQL.ColumnValue
Return the value of the column in the current row.
evaluate(boolean) - Method in class ModSQL.Operator_Compare
Evaluate parameters and compare.
evaluate(boolean) - Method in class ModSQL.Operator_In
Evaluate parameters and compare.
evaluate(boolean) - Method in class ModSQL.Operator_Divide
Evaluate parameters and compute the function.
evaluate(boolean) - Method in class ModSQL.Operator_Exists
Evaluate table and compute the function.
evaluate(boolean) - Method in interface ModSQL.Function
Evaluate parameters and compute the function.
evaluate(boolean) - Method in class ModSQL.Operator_Like
Evaluate parameters and compare.
evaluate(boolean) - Method in class ModSQL.Aggregate_Count
Evaluate the parameter and update the count.
evaluate(boolean) - Method in class ModSQL.Operator_Multiply
Evaluate parameters and compute the function.
evaluate(int, Object) - Method in class ModSQL.AbstractFunction
Default implementation that simply calls evaluate(false).
evaluate(int, Object) - Method in class ModSQL.Operator_Logical
Evaluate parameters and compute the function.
evaluate(int, Object) - Method in class ModSQL.Operator_Add
Evaluate parameters and compute sum.
evaluate(int, Object) - Method in class ModSQL.IndirectFunction
Calls the equivalent evaluate() method for the underlying function.
evaluate(int, Object) - Method in class ModSQL.Select
Same as evaluate(), except that a specific result is desired.
evaluate(int, Object) - Method in class ModSQL.Operator_Is
Evaluate parameters and compute the function.
evaluate(int, Object) - Method in class ModSQL.Operator_Negate
Evaluate parameter and negate.
evaluate(int, Object) - Method in class ModSQL.Operator_Not
Evaluate parameter and invert.
evaluate(int, Object) - Method in class ModSQL.Operator_Concat
Evaluate parameters and compute the function.
evaluate(int, Object) - Method in class ModSQL.LiteralRow
Evaluate row.
evaluate(int, Object) - Method in class ModSQL.Literal
Returns the literal value.
evaluate(int, Object) - Method in class ModSQL.ColumnValue
Return the value of the column in the current row.
evaluate(int, Object) - Method in class ModSQL.Operator_Compare
Evaluate parameters and compare.
evaluate(int, Object) - Method in class ModSQL.Operator_In
Evaluate parameters and compare.
evaluate(int, Object) - Method in class ModSQL.Operator_Divide
Evaluate parameters and compute the function.
evaluate(int, Object) - Method in class ModSQL.Operator_Exists
Evaluate table and compute the function.
evaluate(int, Object) - Method in interface ModSQL.Function
Same as evaluate(), except that a specific result is desired.
evaluate(int, Object) - Method in class ModSQL.Operator_Like
Evaluate parameters and compare.
evaluate(int, Object) - Method in class ModSQL.Operator_Multiply
Evaluate parameters and compute the function.
evaluateConstantParameters() - Method in class ModSQL.AbstractFunction
Evaluate parameters that advertise themselves as constant.
evaluateOrder(int, int) - Method in class ModSQL.AbstractFunction
Specify the order in which the parameters should be evaluated.
evaluateOrder(int, int) - Method in class ModSQL.IndirectFunction
Specify the order in which the parameters should be evaluated.
evaluateOrder(int, int) - Method in class ModSQL.Select
Specify the order in which the parameters should be evaluated.
evaluateOrder(int, int) - Method in class ModSQL.Literal
Specify the order in which the parameters should be evaluated.
evaluateOrder(int, int) - Method in class ModSQL.ColumnValue
Specify the order in which the parameters should be evaluated.
evaluateOrder(int, int) - Method in interface ModSQL.Function
Specify the order in which the parameters should be evaluated.
evaluateParameters(boolean) - Method in class ModSQL.AbstractFunction
Same as above version, but with stop_at_null set to false.
evaluateParameters(boolean, boolean) - Method in class ModSQL.AbstractFunction
Evaluates all parameters and stores the results in the parameter_value array.
evaluateRow(boolean) - Method in class ModSQL.Select
Evaluate each column of the row and return the results as an array of length equal to the value returned by numColumns().
evaluateRow(boolean) - Method in interface ModSQL.RowConstructor
Evaluate each column of the row and return the results as an array of length equal to the value returned by numColumns().
evaluateRow(boolean) - Method in class ModSQL.LiteralRow
Evaluate each column of the row and return the results as an array of length equal to the value returned by getColumnCount().
execute() - Method in class ModSQL.Select
Optimizes query in preperation for calls to next().
execute() - Method in class ModSQL.Insert
Execute the query.
execute() - Method in class ModSQL.PreparedStatement
Executes any kind of SQL statement.
execute() - Method in class ModSQL.Drop
Execute the query.
execute() - Method in interface ModSQL.Query
Execute optimized query.
execute() - Method in class ModSQL.Create
Execute the query.
execute() - Method in class ModSQL.Update
Execute the query.
execute() - Method in class ModSQL.Delete
Execute the query.
execute(String) - Method in class ModSQL.PreparedStatement
Execute a SQL statement that may return multiple results.
executeAggregate() - Method in class ModSQL.Select
Execute simple aggregate query.
executeAndCacheResults() - Method in class ModSQL.Select
Execute query and store results in rows array.
executeBasic() - Method in class ModSQL.Select
Execute basic queries (no GROUP BY and no aggregates).
executeBatch() - Method in class ModSQL.PreparedStatement
Submit a batch of commands to the database for execution.
executeGroupBy() - Method in class ModSQL.Select
Execute queries involving grouping (ie.
executeQuery() - Method in class ModSQL.PreparedStatement
Executes the SQL query in this PreparedStatement object and returns the result set generated by the query.
executeQuery(String) - Method in class ModSQL.PreparedStatement
Execute a SQL statement that returns a single ResultSet.
executeUpdate() - Method in class ModSQL.PreparedStatement
Executes the SQL INSERT, UPDATE or DELETE statement in this PreparedStatement object.
executeUpdate(String) - Method in class ModSQL.PreparedStatement
Execute a SQL INSERT, UPDATE or DELETE statement.
Expression - class ModSQL.Expression.
Abstract class with static methods for parsing SQL expressions.
Expression() - Constructor for class ModSQL.Expression
 

F

fields - Variable in class SampleDatabase.TableTemplate
 
file - Variable in class ModSQL.IndexTable_Sort
 
file - Variable in class ModSQL.IndexTable_Hash
 
file - Variable in class AsciiDatabase.RCFile
 
file - Variable in class AsciiDatabase.AsciiReader
Open file.
file - Variable in class AsciiDatabase.RowId
 
filenum - Variable in class AsciiDatabase.AsciiTable
File where current pointer is located.
FilterForNumber(String) - Static method in class AsciiDatabase.AsciiTable
Filter string of a number.
finalize() - Method in class ModSQL.Select
Close all tables.
finalize() - Method in class ModSQL.IndexTable_Sort
Close index.
finalize() - Method in class ModSQL.IndexTable_Hash
Close index.
finalize() - Method in class ModSQL.SelectTable
Close table.
finalize() - Method in class TemporaryDatabase.Table
 
finalize() - Method in class AsciiDatabase.RCFile
Close the configuration file.
finalize() - Method in class AsciiDatabase.Manager
Closes the configuration file to free up a file descriptor.
finalize() - Method in class AsciiDatabase.AsciiReader
Close the data file.
finalize() - Method in class AsciiDatabase.AsciiTable
Close files.
findColumn(String) - Method in class ModSQL.ResultSet
Map a Resultset column name to a ResultSet column index.
findColumn(String) - Method in interface ModSQL.DatabaseTable
Map a DatabaseTable column name to a DatabaseTable column index.
findColumn(String) - Method in class ModSQL.SelectTable
Find a column with the specified name.
findColumn(String) - Method in class SampleDatabase.TableTemplate
 
findColumn(String) - Method in class TemporaryDatabase.Table
 
findColumn(String) - Method in class AsciiDatabase.AsciiTable
Find a column by name.
FindHeader(String) - Method in class AsciiDatabase.RCFile
Scan through the file (from the beginning) for a particular header.
findNext(int, Object) - Method in class ModSQL.IndexTable_Sort
Old version of findNext() above that requires a column index.
findNext(int, Object) - Method in class ModSQL.IndexTable_Hash
Old version of findNext() above that requires a column index.
findNext(int, Object) - Method in class SampleDatabase.TableTemplate
 
findNext(int, Object) - Method in class AsciiDatabase.AsciiTable
Find next row containing the specified data.
findNext(Object) - Method in class ModSQL.IndexTable_Sort
 
findNext(Object) - Method in class ModSQL.IndexTable_Hash
 
findNext(Object) - Method in interface ModSQL.DatabaseIndex
Finds the next row that has the specified data in the indexed column.
FindNextHeader() - Method in class AsciiDatabase.RCFile
Reads lines from the file (starting at the current position) until a header is found.
finish() - Method in class ModSQL.IndexTableEntry
Finish the rowset.
finish() - Method in class ModSQL.IndexTableRowset
Finish rowset by setting static arrays rowid and count.
finishTable() - Method in class ModSQL.TableReader
Closes least-significant table.
first() - Method in class ModSQL.ResultSet
Moves to the first row in the result set.
FirstName - Variable in class SampleDatabase.EmployeeAddressTable_Row
 
FLOOR - Static variable in class ModSQL.Function_Math
Function is FLOOR().
floor(Number) - Static method in class ModSQL.NumberMath
Returns the largest (closest to positive infinity) Number that is not greater than the argument and is equal to a mathematical integer.
force_aggregate - Variable in class ModSQL.IndirectFunction
Make the function appear as an aggregate regardless of whether it is or not (used for GROUP BY columns).
forName(String) - Static method in class ModSQL.Function_Math
Returns a new instance of this class if name is recognized.
forName(String) - Static method in class ModSQL.Function_NVL
If name is "nvl", this method returns an instance of this class.
forName(String) - Static method in class ModSQL.Aggregate_Math
Returns a new instance of this class if name is "sum", "avg", or "stdev".
forName(String) - Static method in class ModSQL.Aggregate_MinMax
Returns a new instance of this class if name is "min" or "max".
forName(String) - Static method in class ModSQL.Function_String
Returns a new instance of this class if name is recognized.
forName(String) - Static method in class ModSQL.Aggregate_Count
Returns a new instance of this class if name is "count".
forReader(TableReader) - Method in class ModSQL.TableReader.TableAccess
Returns true if this object is from the specified table reader.
Function - interface ModSQL.Function.
This interface is at the root of all single-valued SQL expressions (including row constructors).
Function_Math - class ModSQL.Function_Math.
This class implements standard SQL math functions: ABS, CEIL, FLOOR, GREATEST, LEAST, MOD, POWER, ROUND, SIGN, and SQRT.
Function_Math(int) - Constructor for class ModSQL.Function_Math
Constructor.
Function_NVL - class ModSQL.Function_NVL.
SQL function for NVL (null value substitution function).
Function_NVL() - Constructor for class ModSQL.Function_NVL
 
Function_String - class ModSQL.Function_String.
SQL function for string operations.
Function_String(int) - Constructor for class ModSQL.Function_String
Constructor.
functionName() - Method in class ModSQL.AbstractFunction
Returns the name of this function for use by the toString() method.
functionName() - Method in class ModSQL.Operator_Logical
Returns the name of this function for use by toString() method.
functionName() - Method in class ModSQL.Operator_Add
Returns "#ADD".
functionName() - Method in class ModSQL.Function_Math
Returns the name of this function for use by toString() method.
functionName() - Method in class ModSQL.Operator_Is
Returns "#IS".
functionName() - Method in class ModSQL.Operator_Negate
Returns "#NEGATE".
functionName() - Method in class ModSQL.Operator_Not
Returns "#NOT".
functionName() - Method in class ModSQL.Operator_Concat
Returns "#CONCAT".
functionName() - Method in class ModSQL.LiteralRow
Function name is blank (empty String) for row constructors.
functionName() - Method in class ModSQL.Function_NVL
Returns "#NVL".
functionName() - Method in class ModSQL.Aggregate_Math
Returns the name of this function for use by toString() method.
functionName() - Method in class ModSQL.Aggregate_MinMax
Returns "MIN" or "MAX" depending on how this instances was initialized.
functionName() - Method in class ModSQL.Function_String
Returns the name of this function for use by toString() method.
functionName() - Method in class ModSQL.Operator_Compare
Returns the name of this function for use by toString() method.
functionName() - Method in class ModSQL.Operator_In
Returns the name of this function for use by toString() method.
functionName() - Method in class ModSQL.Operator_Divide
Returns "#DIV".
functionName() - Method in class ModSQL.Operator_Exists
Returns "#EXISTS".
functionName() - Method in class ModSQL.Operator_Like
Returns "#LIKE".
functionName() - Method in class ModSQL.Aggregate_Count
Returns "COUNT".
functionName() - Method in class ModSQL.Operator_Multiply
Returns "#MULT".
FunctionProvider - interface ModSQL.FunctionProvider.
Classes implementing this interface provide Function objects matching a particular String description on demand.
functions - Static variable in class ModSQL.DriverConfig
Cached array of functions.

G

get(int) - Method in class TemporaryDatabase.TableData
Get a row of data.
getArray(int) - Method in class ModSQL.ResultSet
Get an array column.
getArray(String) - Method in class ModSQL.ResultSet
Get an array column.
getAsciiStream(int) - Method in class ModSQL.ResultSet
A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.
getAsciiStream(String) - Method in class ModSQL.ResultSet
A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream.
getAutoCommit() - Method in class ModSQL.Connection
Get the current auto-commit state.
getBestRowIdentifier(String, String, String, int, boolean) - Method in class ModSQL.DatabaseMetaData
Get a description of a table's optimal set of columns that uniquely identifies a row.
getBigDecimal(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.math.BigDecimal object.
getBigDecimal(int, int) - Method in class ModSQL.ResultSet
Deprecated.  
getBigDecimal(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.math.BigDecimal object.
getBigDecimal(String, int) - Method in class ModSQL.ResultSet
Deprecated.  
getBinaryStream(int) - Method in class ModSQL.ResultSet
A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.
getBinaryStream(String) - Method in class ModSQL.ResultSet
A column value can be retrieved as a stream of uninterpreted bytes and then read in chunks from the stream.
getBlob(int) - Method in class ModSQL.ResultSet
Get a BLOB column.
getBlob(String) - Method in class ModSQL.ResultSet
Get a BLOB column.
getBoolean(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java boolean.
getBoolean(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java boolean.
getBuiltinFunction(String) - Static method in class ModSQL.Expression
Get a new object representing a built-in SQL function.
getByte(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java byte.
getByte(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java byte.
getBytes(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java byte array.
getBytes(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java byte array.
getCatalog() - Method in class ModSQL.Connection
Return the Connection's current catalog name.
getCatalogName(int) - Method in class ModSQL.ResultSetMetaData
What's a column's table's catalog name?
getCatalogs() - Method in class ModSQL.DatabaseMetaData
Get the catalog names available in this database.
getCatalogSeparator() - Method in class ModSQL.DatabaseMetaData
What's the separator between catalog and table name?
getCatalogTerm() - Method in class ModSQL.DatabaseMetaData
What's the database vendor's preferred term for "catalog"?
getCause() - Method in class ModSQL.SQLExceptionWithCause
Returns the cause of this throwable or null if the cause is nonexistent or unknown.
getCharacterStream(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.io.Reader.
getCharacterStream(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.io.Reader.
getClob(int) - Method in class ModSQL.ResultSet
Get a CLOB column.
getClob(String) - Method in class ModSQL.ResultSet
Get a CLOB column.
getColumnClassName(int) - Method in class ModSQL.ResultSetMetaData
Return the fully qualified name of the Java class whose instances are manufactured if ResultSet.getObject() is called to retrieve a value from the column.
getColumnCount() - Method in class ModSQL.Select
Returns the number of columns in the table.
getColumnCount() - Method in class ModSQL.ResultSetMetaData
What's the number of columns in the ResultSet?
getColumnCount() - Method in interface ModSQL.DatabaseTable
What's the number of columns in the DatabaseTable?
getColumnCount() - Method in interface ModSQL.Table
Returns the number of columns in the table.
getColumnCount() - Method in interface ModSQL.RowConstructor
Returns the number of columns the row has.
getColumnCount() - Method in class ModSQL.LiteralRow
Returns the number of columns the row has.
getColumnCount() - Method in class ModSQL.TableReader
Returns total number of referenced columns.
getColumnCount() - Method in class ModSQL.SelectTable
Number of columns in table.
getColumnCount() - Method in class ModSQL.LiteralTable
Returns the number of columns in the table.
getColumnCount() - Method in class SampleDatabase.TableTemplate
 
getColumnCount() - Method in class TemporaryDatabase.Table
 
getColumnCount() - Method in class AsciiDatabase.AsciiTable
Get count of columns.
getColumnDisplaySize(int) - Method in class ModSQL.ResultSetMetaData
What's the column's normal max width in chars?
getColumnDisplaySize(int) - Method in interface ModSQL.DatabaseTable
What's the column's normal max width in chars? If the column type is not a string, or the maximum size is not known, this method may return -1.
getColumnDisplaySize(int) - Method in class ModSQL.SelectTable
Get maximum size of column.
getColumnDisplaySize(int) - Method in class SampleDatabase.TableTemplate
 
getColumnDisplaySize(int) - Method in class TemporaryDatabase.Table
 
getColumnDisplaySize(int) - Method in class AsciiDatabase.AsciiTable
Get ideal display width for column.
getColumnLabel(int) - Method in class ModSQL.ResultSetMetaData
What's the suggested column title for use in printouts and displays?
getColumnLabel(int) - Method in interface ModSQL.DatabaseTable
What's the suggested column title for use in printouts and displays? In many cases this method should return the same value as getColumnName() below.
getColumnLabel(int) - Method in class ModSQL.SelectTable
Get column label.
getColumnLabel(int) - Method in class SampleDatabase.TableTemplate
 
getColumnLabel(int) - Method in class TemporaryDatabase.Table
 
getColumnLabel(int) - Method in class AsciiDatabase.AsciiTable
Get an appropriate lable for the column.
getColumnName(int) - Method in class ModSQL.Select
Get the name of a column.
getColumnName(int) - Method in class ModSQL.ResultSetMetaData
What's a column's name?
getColumnName(int) - Method in interface ModSQL.DatabaseTable
What's a column's name?
getColumnName(int) - Method in interface ModSQL.Table
Get the name of a column.
getColumnName(int) - Method in class ModSQL.SelectTable
Get name of column.
getColumnName(int) - Method in class ModSQL.LiteralTable
Get the name of a column.
getColumnName(int) - Method in class SampleDatabase.TableTemplate
 
getColumnName(int) - Method in class TemporaryDatabase.Table
 
getColumnName(int) - Method in class AsciiDatabase.AsciiTable
Get name of column.
getColumnPrivileges(String, String, String, String) - Method in class ModSQL.DatabaseMetaData
Get a description of the access rights for a table's columns.
getColumns(String, String, String, String) - Method in class ModSQL.DatabaseMetaData
Get a description of table columns available in a catalog.
getColumnType(int) - Method in class ModSQL.ResultSetMetaData
What's a column's SQL type?
getColumnType(int) - Method in interface ModSQL.DatabaseTable
What's a column's SQL type?
getColumnType(int) - Method in class ModSQL.SelectTable
Get column type.
getColumnType(int) - Method in class SampleDatabase.TableTemplate
 
getColumnType(int) - Method in class TemporaryDatabase.Table
 
getColumnType(int) - Method in class AsciiDatabase.AsciiTable
Get SQL type of column.
getColumnTypeName(int) - Method in class ModSQL.ResultSetMetaData
What's a column's data source specific type name?
getColumnValues() - Method in class ModSQL.TableReader
Get values for all referenced columns.
getColumnValues(int) - Method in class ModSQL.TableReader
Get all column values starting at column 0 and ending at column ncolumns-1.
getCompatableType(int, int) - Static method in class ModSQL.AbstractFunction
Determine a java.sql.Types type that is compatable with both of the passed parameters.
getCompatibleType(Object, int) - Static method in class ModSQL.Insert
Convert the supplied object to an object compatible with the specified SQL type.
getConcurrency() - Method in class ModSQL.ResultSet
Return the concurrency of this result set.
getConnection() - Method in class ModSQL.DatabaseMetaData
Return the connection that produced this metadata object.
getConnection() - Method in class ModSQL.PreparedStatement
Return the Connection that produced the Statement.
getCrossReference(String, String, String, String, String, String) - Method in class ModSQL.DatabaseMetaData
Get a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.) This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
getCursorName() - Method in class ModSQL.ResultSet
Get the name of the SQL cursor used by this ResultSet.
getDatabaseProductName() - Method in class ModSQL.DatabaseMetaData
What's the name of this database product?
getDatabaseProductVersion() - Method in class ModSQL.DatabaseMetaData
What's the version of this database product?
getDatabaseProperties(String) - Static method in class ModSQL.DriverConfig
This method can be used by database modules to obtain properties from the ModSQL properties file.
getDatabaseTable(int) - Method in class ModSQL.TableReader
Get reference to a particular table.
getDate(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.sql.Date object.
getDate(int, Calendar) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.sql.Date object.
getDate(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.sql.Date object.
getDate(String, Calendar) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.sql.Date object.
getDefaultTransactionIsolation() - Method in class ModSQL.DatabaseMetaData
What's the database's default transaction isolation level? The values are defined in java.sql.Connection.
getDescription() - Method in class ModSQL.IndirectFunction
Get text description of function.
getDistinctCount() - Method in class ModSQL.IndexTable_Sort
 
getDistinctCount() - Method in class ModSQL.IndexTable_Hash
 
getDistinctCount() - Method in interface ModSQL.DatabaseIndex
Returns the number of distinct values stored in the indexed column in the underlying table.
getDistinctSetSize() - Method in class ModSQL.AbstractAggregate
Get the size of the set of distinct values.
getDouble(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java double.
getDouble(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java double.
getDriverMajorVersion() - Method in class ModSQL.DatabaseMetaData
What's this JDBC driver's major version number?
getDriverMinorVersion() - Method in class ModSQL.DatabaseMetaData
What's this JDBC driver's minor version number?
getDriverName() - Method in class ModSQL.DatabaseMetaData
What's the name of this JDBC driver?
getDriverVersion() - Method in class ModSQL.DatabaseMetaData
What's the version of this JDBC driver?
getExportedKeys(String, String, String) - Method in class ModSQL.DatabaseMetaData
Get a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table).
getExtraNameCharacters() - Method in class ModSQL.DatabaseMetaData
Get all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
getFetchDirection() - Method in class ModSQL.ResultSet
Return the fetch direction for this result set.
getFetchDirection() - Method in class ModSQL.PreparedStatement
Determine the fetch direction.
getFetchSize() - Method in class ModSQL.ResultSet
Return the fetch size for this result set.
getFetchSize() - Method in class ModSQL.PreparedStatement
Determine the default fetch size.
getFilePointer() - Method in class AsciiDatabase.AsciiReader
Return the current file pointer position.
getFloat(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java float.
getFloat(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java float.
getFunction() - Method in class ModSQL.IndirectFunction
Get function being wrapped.
getFunction(String) - Method in interface ModSQL.DatabaseManager
Get a database specific function for use in SQL.
getFunction(String) - Method in class ModSQL.MetaManager
Get a database specific function for use in SQL.
getFunction(String) - Method in class SampleDatabase.Manager
 
getFunction(String) - Method in class TemporaryDatabase.Manager
 
getFunction(String) - Method in class AsciiDatabase.Manager
 
getFunctionClasses() - Static method in class ModSQL.DriverConfig
Get array of function classes to check when parsing expressions.
getHashTableSize() - Static method in class ModSQL.DriverConfig
Get default size of hash tables used interally.
getIdentifierQuoteString() - Method in class ModSQL.DatabaseMetaData
What's the string used to quote SQL identifiers? This returns a space " " if identifier quoting isn't supported.
getImportedKeys(String, String, String) - Method in class ModSQL.DatabaseMetaData
Get a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table).
getIndexFilename(String, String) - Static method in class ModSQL.IndexTable
Return an appropriate filename for an index of the specified column of the specified table.
getIndexInfo(String, String, String, boolean, boolean) - Method in class ModSQL.DatabaseMetaData
Get a description of a table's indices and statistics.
getIndexPath() - Static method in class ModSQL.DriverConfig
Get path to index files.
getInt(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java int.
getInt(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java int.
getLong(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java long.
getLong(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java long.
getMajorVersion() - Method in interface ModSQL.DatabaseManager
Get the driver's major version number.
getMajorVersion() - Method in class ModSQL.Driver
Get the driver's major version number.
getMajorVersion() - Method in class ModSQL.MetaManager
Major version number.
getMajorVersion() - Method in class SampleDatabase.Manager
 
getMajorVersion() - Method in class TemporaryDatabase.Manager
 
getMajorVersion() - Method in class AsciiDatabase.Manager
Returns the major version number of this database.
getManagers() - Static method in class ModSQL.MetaManager
Get current list of database managers.
getMaxBinaryLiteralLength() - Method in class ModSQL.DatabaseMetaData
How many hex characters can you have in an inline binary literal?
getMaxCatalogNameLength() - Method in class ModSQL.DatabaseMetaData
What's the maximum length of a catalog name?
getMaxCharLiteralLength() - Method in class ModSQL.DatabaseMetaData
What's the max length for a character literal?
getMaxColumnNameLength() - Method in class ModSQL.DatabaseMetaData
What's the limit on column name length?
getMaxColumnsInGroupBy() - Method in class ModSQL.DatabaseMetaData
What's the maximum number of columns in a "GROUP BY" clause?
getMaxColumnsInIndex() - Method in class ModSQL.DatabaseMetaData
What's the maximum number of columns allowed in an index?
getMaxColumnsInOrderBy() - Method in class ModSQL.DatabaseMetaData
What's the maximum number of columns in an "ORDER BY" clause?
getMaxColumnsInSelect() - Method in class ModSQL.DatabaseMetaData
What's the maximum number of columns in a "SELECT" list?
getMaxColumnsInTable() - Method in class ModSQL.DatabaseMetaData
What's the maximum number of columns in a table?
getMaxConnections() - Method in class ModSQL.DatabaseMetaData
How many active connections can we have at a time to this database?
getMaxCursorNameLength() - Method in class ModSQL.DatabaseMetaData
What's the maximum cursor name length?
getMaxFieldSize() - Method in class ModSQL.PreparedStatement
The maxFieldSize limit (in bytes) is the maximum amount of data returned for any column value; it only applies to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR columns.
getMaxIndexLength() - Method in class ModSQL.DatabaseMetaData
What's the maximum length of an index (in bytes)?
getMaxProcedureNameLength() - Method in class ModSQL.DatabaseMetaData
What's the maximum length of a procedure name?
getMaxResultSize() - Method in class ModSQL.Operator_Logical
Returns -1 as this operator will never return a String object.
getMaxResultSize() - Method in class ModSQL.Operator_Add
Returns -1 as this operator will never return a String object.
getMaxResultSize() - Method in class ModSQL.IndirectFunction
Return the maximum number of characters that this function expects to return in a String object.
getMaxResultSize() - Method in class ModSQL.Select
This version of getMaxResultSize() can only be used if the query returns only one column.
getMaxResultSize() - Method in class ModSQL.Function_Math
Returns -1 as this function will never return a String constant.
getMaxResultSize() - Method in class ModSQL.Operator_Is
Returns -1 as this operator will never return a String object.
getMaxResultSize() - Method in class ModSQL.Operator_Negate
Returns -1 as this operator will never return a String object.
getMaxResultSize() - Method in class ModSQL.Operator_Not
Returns -1 as this operator will never return a String object.
getMaxResultSize() - Method in class ModSQL.Operator_Concat
Return the maximum number of characters that this function expects to return in a String object.
getMaxResultSize() - Method in class ModSQL.LiteralRow
Return the maximum number of characters that this function expects to return in a String object.
getMaxResultSize() - Method in class ModSQL.Function_NVL
Make size of any String that may be returned, or -1 if a maximum size is not known.
getMaxResultSize() - Method in class ModSQL.Literal
If the literal is a String, this method returns the length of the String.
getMaxResultSize() - Method in class ModSQL.Aggregate_Math
Returns -1 as these functions never return String objects.
getMaxResultSize() - Method in class ModSQL.Aggregate_MinMax
Return value is the same as for the parameter, or -1 if there is no parameter.
getMaxResultSize() - Method in class ModSQL.Function_String
Returns the maximum size of any String computed by this function.
getMaxResultSize() - Method in class ModSQL.ColumnValue
Return the maximum number of characters that this function expects to return in a String object.
getMaxResultSize() - Method in class ModSQL.Operator_Compare
Returns -1 as this operator will never return String objects.
getMaxResultSize() - Method in class ModSQL.Operator_In
Returns -1 as this operator will never return a String object.
getMaxResultSize() - Method in class ModSQL.Operator_Divide
Returns -1 as this operator will never return a String object.
getMaxResultSize() - Method in class ModSQL.Operator_Exists
Returns -1 as this operator will never return a String object.
getMaxResultSize() - Method in interface ModSQL.Function
Return the maximum number of characters that this function expects to return in a String object.
getMaxResultSize() - Method in class ModSQL.Operator_Like
Returns -1 as this operator will never return a String object.
getMaxResultSize() - Method in class ModSQL.Aggregate_Count
Returns -1.
getMaxResultSize() - Method in class ModSQL.Operator_Multiply
Returns -1 as this operator will never return a String object.
getMaxResultSize(int) - Method in class ModSQL.Select
Return the maximum number of characters String values in the specified column will have.
getMaxResultSize(int) - Method in interface ModSQL.Table
Return the maximum number of characters String values in the specified column will have.
getMaxResultSize(int) - Method in interface ModSQL.RowConstructor
Return the maximum number of characters String values in the specified column will have.
getMaxResultSize(int) - Method in class ModSQL.LiteralRow
Return the maximum number of characters String values in the specified column will have.
getMaxResultSize(int) - Method in class ModSQL.LiteralTable
Return the maximum number of characters String values in the specified column will have.
getMaxRows() - Method in class ModSQL.PreparedStatement
The maxRows limit is the maximum number of rows that a ResultSet can contain.
getMaxRowSize() - Method in class ModSQL.DatabaseMetaData
What's the maximum length of a single row?
getMaxSchemaNameLength() - Method in class ModSQL.DatabaseMetaData
What's the maximum length allowed for a schema name?
getMaxStatementLength() - Method in class ModSQL.DatabaseMetaData
What's the maximum length of a SQL statement?
getMaxStatements() - Method in class ModSQL.DatabaseMetaData
How many active statements can we have open at one time to this database?
getMaxTableNameLength() - Method in class ModSQL.DatabaseMetaData
What's the maximum length of a table name?
getMaxTablesInSelect() - Method in class ModSQL.DatabaseMetaData
What's the maximum number of tables in a SELECT?
getMaxUserNameLength() - Method in class ModSQL.DatabaseMetaData
What's the maximum length of a user name?
getMetaData() - Method in class ModSQL.ResultSet
The number, types and properties of a ResultSet's columns are provided by the getMetaData method.
getMetaData() - Method in class ModSQL.Connection
A Connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, etc.
getMetaData() - Method in class ModSQL.PreparedStatement
Gets the number, types and properties of a ResultSet object's columns.
getMinorVersion() - Method in interface ModSQL.DatabaseManager
Get the driver's minor version number.
getMinorVersion() - Method in class ModSQL.Driver
Get the driver's minor version number.
getMinorVersion() - Method in class ModSQL.MetaManager
Minor version number.
getMinorVersion() - Method in class SampleDatabase.Manager
 
getMinorVersion() - Method in class TemporaryDatabase.Manager
 
getMinorVersion() - Method in class AsciiDatabase.Manager
Returns the minor version number of this database.
getMoreResults() - Method in class ModSQL.PreparedStatement
getMoreResults moves to a Statement's next result.
getNullCount() - Method in class ModSQL.IndexTable_Sort
 
getNullCount() - Method in class ModSQL.IndexTable_Hash
 
getNullCount() - Method in interface ModSQL.DatabaseIndex
Returns the number of null values stored in the indexed column in the underlying table.
getNumericFunctions() - Method in class ModSQL.DatabaseMetaData
Get a comma separated list of math functions.
getObject(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java object.
getObject(int) - Method in class ModSQL.Select
Get the value of a column in the current row as a Java object.
getObject(int) - Method in interface ModSQL.Table
Get the value of a column in the current row as a Java object.
getObject(int) - Method in class ModSQL.IndexTable_Sort
 
getObject(int) - Method in class ModSQL.IndexTable_Hash
 
getObject(int) - Method in interface ModSQL.DatabaseTableBase
Get the value of a column in the current row as a Java object.
getObject(int) - Method in class ModSQL.SelectTable
Get the value of a column in the current row as a Java object.
getObject(int) - Method in class ModSQL.LiteralTable
Get the value of a column in the current row as a Java object.
getObject(int) - Method in class SampleDatabase.TableTemplate
 
getObject(int) - Method in class TemporaryDatabase.Table
 
getObject(int) - Method in class AsciiDatabase.AsciiTable
Read column data.
getObject(int, Map) - Method in class ModSQL.ResultSet
Returns the value of column @i as a Java object.
getObject(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java object.
getObject(String, Map) - Method in class ModSQL.ResultSet
Returns the value of column @i as a Java object.
getObjectSQLType(Object) - Static method in class ModSQL.AbstractFunction
Determine the SQL type of a java Object.
getParameter(int) - Method in class ModSQL.AbstractFunction
Get a particular parameter.
getParameter(int) - Method in class ModSQL.IndirectFunction
Get a particular parameter.
getParameter(int) - Method in class ModSQL.Select
Get a particular parameter.
getParameter(int) - Method in class ModSQL.Literal
Get a particular parameter.
getParameter(int) - Method in class ModSQL.ColumnValue
Get a particular parameter.
getParameter(int) - Method in interface ModSQL.Function
Get a particular parameter.
getParameterCount() - Method in class ModSQL.AbstractFunction
Get the number of parameters currently supplied to this function.
getParameterCount() - Method in class ModSQL.IndirectFunction
Get the number of parameters.
getParameterCount() - Method in class ModSQL.Select
Get the number pf parameters currently supplied to this function.
getParameterCount() - Method in class ModSQL.Literal
Get the number of parameters.
getParameterCount() - Method in class ModSQL.ColumnValue
Number of parameters.
getParameterCount() - Method in interface ModSQL.Function
Get the number of parameters currently supplied to this function.
getParent() - Method in class ModSQL.TableReader
Get parent TableReader, or null if none.
getPrecision(int) - Method in class ModSQL.ResultSetMetaData
What's a column's number of decimal digits?
getPrimaryKeys(String, String, String) - Method in class ModSQL.DatabaseMetaData
Get a description of a table's primary key columns.
getProcedureColumns(String, String, String, String) - Method in class ModSQL.DatabaseMetaData
Get a description of a catalog's stored procedure parameters and result columns.
getProcedures(String, String, String) - Method in class ModSQL.DatabaseMetaData
Get a description of stored procedures available in a catalog.
getProcedureTerm() - Method in class ModSQL.DatabaseMetaData
What's the database vendor's preferred term for "procedure"?
getPropertyInfo(String, Properties) - Method in class ModSQL.Driver
The getPropertyInfo method is intended to allow a generic GUI tool to discover what properties it should prompt a human for in order to get enough information to connect to a database.
getQueryTimeout() - Method in class ModSQL.PreparedStatement
The queryTimeout limit is the number of seconds the driver will wait for a Statement to execute.
getReader() - Method in class ModSQL.EndOfTable
Get reference to TableReader responsible for table.
getRef(int) - Method in class ModSQL.ResultSet
Get a REF(<structured-type>) column.
getRef(String) - Method in class ModSQL.ResultSet
Get a REF(<structured-type>) column.
getResultSet() - Method in class ModSQL.PreparedStatement
getResultSet returns the current result as a ResultSet.
getResultSetConcurrency() - Method in class ModSQL.PreparedStatement
Determine the result set concurrency.
getResultSetType() - Method in class ModSQL.PreparedStatement
Determine the result set type.
getRow() - Method in class ModSQL.ResultSet
Determine the current row number.
getRow() - Method in class ModSQL.Select
Get the current row as an array of Objects.
getRow() - Method in interface ModSQL.Table
Get the current row as an array of Objects.
getRow() - Method in class ModSQL.LiteralTable
Get the current row as an array of Objects.
getRowCount() - Method in class ModSQL.Select
Return number of rows if known.
getRowCount() - Method in interface ModSQL.Table
Get count of number of rows, if known.
getRowCount() - Method in class ModSQL.IndexTable_Sort
 
getRowCount() - Method in class ModSQL.IndexTable_Hash
 
getRowCount() - Method in interface ModSQL.DatabaseTableBase
This method is expected to return the total number of rows in the database.
getRowCount() - Method in class ModSQL.SelectTable
Number of rows.
getRowCount() - Method in class ModSQL.LiteralTable
Return number of rows.
getRowCount() - Method in class SampleDatabase.TableTemplate
 
getRowCount() - Method in class TemporaryDatabase.Table
 
getRowCount() - Method in class AsciiDatabase.AsciiTable
 
getRowId() - Method in class ModSQL.IndexTable_Sort
 
getRowId() - Method in class ModSQL.IndexTable_Hash
 
getRowId() - Method in interface ModSQL.DatabaseTableBase
Get database specific rowid value.
getRowId() - Method in class ModSQL.SelectTable
Returns the rowid for the current row.
getRowId() - Method in class SampleDatabase.TableTemplate
 
getRowId() - Method in class TemporaryDatabase.Table
 
getRowId() - Method in class AsciiDatabase.AsciiTable
Get the id of the current row.
getScale(int) - Method in class ModSQL.ResultSetMetaData
What's a column's number of digits to right of the decimal point?
getSchemaName(int) - Method in class ModSQL.ResultSetMetaData
What's a column's table's schema?
getSchemas() - Method in class ModSQL.DatabaseMetaData
Get the schema names available in this database.
getSchemaTerm() - Method in class ModSQL.DatabaseMetaData
What's the database vendor's preferred term for "schema"?
getSearchStringEscape() - Method in class ModSQL.DatabaseMetaData
This is the string that can be used to escape '_' or '%' in the string pattern style catalog search parameters.
getShort(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java short.
getShort(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java short.
getSQLKeywords() - Method in class ModSQL.DatabaseMetaData
Get a comma separated list of all a database's SQL keywords that are NOT also SQL92 keywords.
getSQLType() - Method in class ModSQL.Operator_Logical
Returns Types.BIT.
getSQLType() - Method in class ModSQL.Operator_Add
Return the SQL type of the value that this function expects to return.
getSQLType() - Method in class ModSQL.IndirectFunction
Return the SQL type of the value that this function expects to return.
getSQLType() - Method in class ModSQL.Select
This version of getSQLType() can only be used if the query returns only one column.
getSQLType() - Method in class ModSQL.Function_Math
Returns the SQL type of this function.
getSQLType() - Method in class ModSQL.Operator_Is
Returns Types.BIT.
getSQLType() - Method in class ModSQL.Operator_Negate
Returns the type of the parameter.
getSQLType() - Method in class ModSQL.Operator_Not
Returns Types.BIT.
getSQLType() - Method in class ModSQL.Operator_Concat
Return the SQL type of the value that this function expects to return.
getSQLType() - Method in class ModSQL.LiteralRow
Return the SQL type of the value that this function expects to return.
getSQLType() - Method in class ModSQL.Function_NVL
Returns the SQL type of this function.
getSQLType() - Method in class ModSQL.Literal
Return the SQL type of the literal value.
getSQLType() - Method in class ModSQL.Aggregate_Math
Return the SQL type of the value that this function expects to return.
getSQLType() - Method in class ModSQL.Aggregate_MinMax
This method returns the SQL type of the parameter, or NULL if there is no parameter.
getSQLType() - Method in class ModSQL.Function_String
Returns the SQL type of this function.
getSQLType() - Method in class ModSQL.ColumnValue
Return the SQL type of the value that this function expects to return.
getSQLType() - Method in class ModSQL.Operator_Compare
Returns Types.BIT.
getSQLType() - Method in class ModSQL.Operator_In
Returns Types.BIT.
getSQLType() - Method in class ModSQL.Operator_Divide
Return the SQL type of the value that this function expects to return.
getSQLType() - Method in class ModSQL.Operator_Exists
Returns Types.BIT.
getSQLType() - Method in interface ModSQL.Function
Return the SQL type of the value that this function expects to return.
getSQLType() - Method in class ModSQL.Operator_Like
Returns Types.BIT.
getSQLType() - Method in class ModSQL.Aggregate_Count
COUNT always returns BIGINT integers.
getSQLType() - Method in class ModSQL.Operator_Multiply
Return the SQL type of the value that this function expects to return.
getSQLType(int) - Method in class ModSQL.Select
Return the SQL type of the specified column.
getSQLType(int) - Method in interface ModSQL.Table
Return the SQL type of the specified column.
getSQLType(int) - Method in interface ModSQL.RowConstructor
Return the SQL type of the value in the specified column.
getSQLType(int) - Method in class ModSQL.LiteralRow
Return the SQL type of the value in the specified column.
getSQLType(int) - Method in class ModSQL.LiteralTable
Return the SQL type of the specified column.
getStatement() - Method in class ModSQL.ResultSet
Return the Statement that produced the ResultSet.
getString(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java String.
getString(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a Java String.
getStringFunctions() - Method in class ModSQL.DatabaseMetaData
Get a comma separated list of string functions.
getSystemFunctions() - Method in class ModSQL.DatabaseMetaData
Get a comma separated list of system functions.
getTableAlias(int) - Method in class ModSQL.TableReader
Get table alias (or null if none).
getTableName() - Method in interface ModSQL.DatabaseTable
What's the table's name?
getTableName() - Method in class ModSQL.SelectTable
Name of table.
getTableName() - Method in class SampleDatabase.TableTemplate
 
getTableName() - Method in class TemporaryDatabase.Table
 
getTableName() - Method in class AsciiDatabase.AsciiTable
Get table name.
getTableName(int) - Method in class ModSQL.ResultSetMetaData
What's a column's table name?
getTablePrivileges(String, String, String) - Method in class ModSQL.DatabaseMetaData
Get a description of the access rights for each table available in a catalog.
getTables(String, String, String, String[]) - Method in class ModSQL.DatabaseMetaData
Get a description of tables available in a catalog.
getTableSignature() - Method in interface ModSQL.DatabaseTable
Calculates a unique signature for this table.
getTableSignature() - Method in class ModSQL.SelectTable
Table signature.
getTableSignature() - Method in class SampleDatabase.TableTemplate
 
getTableSignature() - Method in class TemporaryDatabase.Table
 
getTableSignature() - Method in class AsciiDatabase.AsciiTable
Get signature for table.
getTableSize() - Method in interface ModSQL.DatabaseTable
Returns the size of the table in bytes.
getTableSize() - Method in class ModSQL.SelectTable
Size of table in bytes.
getTableSize() - Method in class SampleDatabase.TableTemplate
 
getTableSize() - Method in class TemporaryDatabase.Table
 
getTableSize() - Method in class AsciiDatabase.AsciiTable
Get size of table.
getTableTypes() - Method in class ModSQL.DatabaseMetaData
Get the table types available in this database.
getTime(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.sql.Time object.
getTime(int, Calendar) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.sql.Time object.
getTime(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.sql.Time object.
getTime(String, Calendar) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.sql.Time object.
getTimeDateFunctions() - Method in class ModSQL.DatabaseMetaData
Get a comma separated list of time and date functions.
getTimestamp(int) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.sql.Timestamp object.
getTimestamp(int, Calendar) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.sql.Timestamp object.
getTimestamp(String) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.sql.Timestamp object.
getTimestamp(String, Calendar) - Method in class ModSQL.ResultSet
Get the value of a column in the current row as a java.sql.Timestamp object.
getTransactionIsolation() - Method in class ModSQL.Connection
Get this Connection's current transaction isolation mode.
getType() - Method in class ModSQL.ResultSet
Return the type of this result set.
getTypeInfo() - Method in class ModSQL.DatabaseMetaData
Get a description of all the standard SQL types supported by this database.
getTypeMap() - Method in class ModSQL.Connection
Not implemented.
getUDTs(String, String, String, int[]) - Method in class ModSQL.DatabaseMetaData
Get a description of the user-defined types defined in a particular schema.
getUnicodeStream(int) - Method in class ModSQL.ResultSet
Deprecated.  
getUnicodeStream(String) - Method in class ModSQL.ResultSet
Deprecated.  
getUpdateCount() - Method in class ModSQL.PreparedStatement
getUpdateCount returns the current result as an update count; if the result is a ResultSet or there are no more results, -1 is returned.
getURL() - Method in class ModSQL.DatabaseMetaData
What's the url for this database?
getUserName() - Method in class ModSQL.DatabaseMetaData
What's our user name as known to the database?
getVersionColumns(String, String, String) - Method in class ModSQL.DatabaseMetaData
Get a description of a table's columns that are automatically updated when any value in a row is updated.
getWarnings() - Method in class ModSQL.ResultSet
The first warning reported by calls on this ResultSet is returned.
getWarnings() - Method in class ModSQL.Connection
The first warning reported by calls on this Connection is returned.
getWarnings() - Method in class ModSQL.PreparedStatement
The first warning reported by calls on this Statement is returned.
GREATEST - Static variable in class ModSQL.Function_Math
Function is GREATEST().
group_by - Variable in class ModSQL.Select
Functions to GROUP BY.
group_by_names - Variable in class ModSQL.Select
Names of columns to GROUP BY.
GT - Static variable in class ModSQL.Operator_Compare
Comparison operator (greater than).
GT - Static variable in class ModSQL.Operator_In
Comparison operator (greater than).
GTE - Static variable in class ModSQL.Operator_Compare
Comparison operator (greater or equal).
GTE - Static variable in class ModSQL.Operator_In
Comparison operator (greater or equal).

H

hashCode() - Method in class AsciiDatabase.ColumnProperties
 
hashCode() - Method in class AsciiDatabase.ColumnOption
 
hashCode() - Method in class AsciiDatabase.SourceProperties
 
hashCode() - Method in class AsciiDatabase.RowOption_skip
 
hashCode() - Method in class AsciiDatabase.RowOption_select
 
hashset - Variable in class ModSQL.Operator_In
Hash table to speedup tests for equality.
hashset_hasnull - Variable in class ModSQL.Operator_In
Does the hash table contain a null value.
hasTable(String) - Method in interface ModSQL.DatabaseManager
Checks whether this database has the specified table.
hasTable(String) - Method in class ModSQL.MetaManager
Check all managers for the specified table.
hasTable(String) - Method in class SampleDatabase.Manager
 
hasTable(String) - Method in class TemporaryDatabase.Manager
 
hasTable(String) - Method in class AsciiDatabase.Manager
Checks if this database contains the named table.
having - Variable in class ModSQL.Select
HAVING clause used to select groups of interest.

I

index_available - Variable in class ModSQL.TableReader.TableAccess
Tables that may be accessed via an index.
index_checked - Variable in class ModSQL.ColumnValue
Set to true if an index was searched for.
indexed - Variable in class ModSQL.ColumnValue
Set to true if this column is indexed.
indexed_column - Variable in class ModSQL.TableReader
If table_read entry is an index, this array holds the index of the indexed column (or -1 if table_read entry is not an index).
indexed_column - Variable in class ModSQL.Drop
Index to drop indexes this column.
indexed_column - Variable in class ModSQL.Create
Name of column to index.
indexed_table - Variable in class ModSQL.Drop
Index to drop indexes this table.
indexed_table - Variable in class ModSQL.Create
Name of table to index.
indexname - Variable in class ModSQL.Create
Name of index to create.
IndexTable - class ModSQL.IndexTable.
Abstract base class for built-in table indexing classes.
IndexTable_Hash - class ModSQL.IndexTable_Hash.
Implementation of DatabaseTable for tables that are indexed by the ModSQL driver using a hash table.
IndexTable_Hash(DatabaseTable, String) - Constructor for class ModSQL.IndexTable_Hash
Constructor.
IndexTable_Sort - class ModSQL.IndexTable_Sort.
Implementation of DatabaseTable for tables that are indexed by the ModSQL driver.
IndexTable_Sort(DatabaseTable, String) - Constructor for class ModSQL.IndexTable_Sort
Constructor.
IndexTable() - Constructor for class ModSQL.IndexTable
 
IndexTableEntry - class ModSQL.IndexTableEntry.
Column data object and table rowset combined.
IndexTableEntry(Object) - Constructor for class ModSQL.IndexTableEntry
Constructor.
IndexTableEntry(Object, IndexTableRowset) - Constructor for class ModSQL.IndexTableEntry
Constructor.
IndexTableEntry(Object, Object, long) - Constructor for class ModSQL.IndexTableEntry
Constructor.
IndexTableRowset - class ModSQL.IndexTableRowset.
Each object describes a set of rows in a table.
IndexTableRowset(Object, long) - Constructor for class ModSQL.IndexTableRowset
Constructor requiring an initial rowid and count.
indextype - Variable in class ModSQL.Create
Type of index to create.
IndirectFunction - class ModSQL.IndirectFunction.
Wrapper for some other function.
IndirectFunction(String) - Constructor for class ModSQL.IndirectFunction
Constructor.
INITCAP - Static variable in class ModSQL.Function_String
Function is INITCAP().
inList(Function) - Method in class ModSQL.Select.GroupByList
Check if a specific function is in the GROUP BY list.
Insert - class ModSQL.Insert.
Insert parses and executes an SQL INSERT query.
Insert(StreamTokenizer, DatabaseManager) - Constructor for class ModSQL.Insert
Contructor to parse query.
insertRow() - Method in class ModSQL.ResultSet
Insert the contents of the insert row into the result set and the database.
insertsAreDetected(int) - Method in class ModSQL.DatabaseMetaData
Determine whether or not a visible row insert can be detected by calling ResultSet.rowInserted().
invalidate() - Method in class ModSQL.ColumnValue
Invalidate cached value.
is_constant - Variable in class ModSQL.Operator_Exists
True if operator returns a constant value (table is constant).
is_not - Variable in class ModSQL.Operator_Is
True of IS NOT.
isAfterLast() - Method in class ModSQL.ResultSet
Determine if the cursor is after the last row in the result set.
isAfterLast() - Method in class ModSQL.IndexTable_Sort
 
isAfterLast() - Method in class ModSQL.IndexTable_Hash
 
isAfterLast() - Method in interface ModSQL.DatabaseTableBase
Determine if the table cursor is positioned after the last row in the table.
isAfterLast() - Method in class ModSQL.SelectTable
Are we after the last row?
isAfterLast() - Method in class SampleDatabase.TableTemplate
 
isAfterLast() - Method in class TemporaryDatabase.Table
 
isAfterLast() - Method in class AsciiDatabase.AsciiTable
Is after last row?
isAggregate() - Method in class ModSQL.AbstractFunction
The implementation of this method is intended to be used by non-aggregate functions.
isAggregate() - Method in class ModSQL.IndirectFunction
Determine if this function will return a value that is an aggregate of many database rows.
isAggregate() - Method in class ModSQL.AbstractAggregate
Aggregate functions will always return true when isAggregate() is called, unless one of the parameters is an aggregate.
isAggregate() - Method in class ModSQL.Select
Select queries are never aggregate.
isAggregate() - Method in class ModSQL.Literal
Determine if this function will return a value that is an aggregate of many database rows.
isAggregate() - Method in class ModSQL.ColumnValue
Determine if this function will return a value that is an aggregate of many database rows.
isAggregate() - Method in class ModSQL.Operator_In
Determine if this function will return a value that is an aggregate of many database rows.
isAggregate() - Method in interface ModSQL.Function
Determine if this function will return a value that is an aggregate of many database rows.
isAutoIncrement(int) - Method in class ModSQL.ResultSetMetaData
Is the column automatically numbered, thus read-only?
isBeforeFirst() - Method in class ModSQL.ResultSet
Determine if the cursor is before the first row in the result set.
isBeforeFirst() - Method in class ModSQL.IndexTable_Sort
 
isBeforeFirst() - Method in class ModSQL.IndexTable_Hash
 
isBeforeFirst() - Method in interface ModSQL.DatabaseTableBase
Determine if the table cursor is positioned before the first row in the table.
isBeforeFirst() - Method in class ModSQL.SelectTable
Are we before the first row?
isBeforeFirst() - Method in class SampleDatabase.TableTemplate
 
isBeforeFirst() - Method in class TemporaryDatabase.Table
 
isBeforeFirst() - Method in class AsciiDatabase.AsciiTable
Is before first row?
isCaseSensitive(int) - Method in class ModSQL.ResultSetMetaData
Does a column's case matter?
isCatalogAtStart() - Method in class ModSQL.DatabaseMetaData
Does a catalog appear at the start of a qualified table name? (Otherwise it appears at the end)
isClosed() - Method in class ModSQL.Connection
Tests to see if a Connection is closed.
isConstant() - Method in class ModSQL.AbstractFunction
Determine if this function returns a constant value.
isConstant() - Method in class ModSQL.IndirectFunction
Determine if this function returns a constant value.
isConstant() - Method in class ModSQL.AbstractAggregate
Determine if this function returns a constant value.
isConstant() - Method in class ModSQL.Select
A query is non-constant if it is a subquery that references columns from its parent.
isConstant() - Method in interface ModSQL.Table
Determine if this table is constant.
isConstant() - Method in class ModSQL.Literal
Determine if this function returns a constant value.
isConstant() - Method in class ModSQL.ColumnValue
Determine if this function returns a constant value.
isConstant() - Method in class ModSQL.Operator_In
Determine if this function returns a constant value.
isConstant() - Method in class ModSQL.LiteralTable
Determine if this table is constant.
isConstant() - Method in class ModSQL.Operator_Exists
Returns true if the table is constant.
isConstant() - Method in interface ModSQL.Function
Determine if this function returns a constant value.
isCurrency(int) - Method in class ModSQL.ResultSetMetaData
Is the column a cash value?
isDefinitelyWritable(int) - Method in class ModSQL.ResultSetMetaData
Will a write on the column definitely succeed?
isFirst() - Method in class ModSQL.ResultSet
Determine if the cursor is on the first row of the result set.
isIndexAvailable(int) - Method in interface ModSQL.DatabaseTable
Determines if an index is available for the specified column.
isIndexAvailable(int) - Method in class ModSQL.SelectTable
Is an index available? Indices are not supported for tables generated from a query so this method just returns null.
isIndexAvailable(int) - Method in class SampleDatabase.TableTemplate
 
isIndexAvailable(int) - Method in class TemporaryDatabase.Table
 
isIndexAvailable(int) - Method in class AsciiDatabase.AsciiTable
Is a particular column indexed? No.
isIndexAvailable(int, int) - Method in class ModSQL.TableReader
Check if the specified column of the specified table is indexed.
isIndexAvailable(String) - Static method in class ModSQL.IndexTable
Check if the specified index file is available.
isKeyword(String) - Static method in class ModSQL.Expression
Static support method.
isLast() - Method in class ModSQL.ResultSet
Determine if the cursor is on the last row of the result set.
isNullable(int) - Method in class ModSQL.ResultSetMetaData
Can you put a NULL in this column?
isReadOnly() - Method in class ModSQL.Connection
Tests to see if the connection is in read-only mode.
isReadOnly() - Method in interface ModSQL.DatabaseTable
Is table read-only (ie.
isReadOnly() - Method in class ModSQL.DatabaseMetaData
Is the database in read-only mode?
isReadOnly() - Method in class ModSQL.SelectTable
Is table readonly?
isReadOnly() - Method in class SampleDatabase.TableTemplate
 
isReadOnly() - Method in class TemporaryDatabase.Table
 
isReadOnly() - Method in class AsciiDatabase.AsciiTable
Is the table read only? Yes.
isReadOnly(int) - Method in class ModSQL.ResultSetMetaData
Is a column definitely not writable?
isSearchable(int) - Method in class ModSQL.ResultSetMetaData
Can the column be used in a where clause?
isSigned(int) - Method in class ModSQL.ResultSetMetaData
Is the column a signed number?
istream - Variable in class ModSQL.IndexTable_Sort
 
istream - Variable in class ModSQL.IndexTable_Hash
 
isWritable(int) - Method in class ModSQL.ResultSetMetaData
Is it possible for a write on the column to succeed?
Item - Variable in class SampleDatabase.Antiques_Row
 
ItemDesired - Variable in class SampleDatabase.Orders_Row
 

J

jdbcCompliant() - Method in class ModSQL.Driver
Report whether the Driver is a genuine JDBC COMPLIANT (tm) driver.

L

last_read - Variable in class ModSQL.TableReader
Index of last table to be read from.
last_value - Variable in class ModSQL.IndirectFunction
Last value returned by function (used for forced aggregates).
last() - Method in class ModSQL.ResultSet
Moves to the last row in the result set.
LastName - Variable in class SampleDatabase.EmployeeAddressTable_Row
 
lastNull - Variable in class ModSQL.ResultSet
True if last value retrieved was null.
lastproperty - Variable in class AsciiDatabase.RCFile
 
LastProperty() - Method in class AsciiDatabase.RCFile
Returns the property name (name before equal sign) of the last value read with ReadNextCharValue().
LEAST - Static variable in class ModSQL.Function_Math
Function is LEAST().
LEFT - Static variable in class ModSQL.Function_String
Function is LEFT().
LENGTH - Static variable in class ModSQL.Function_String
Function is LENGTH().
length() - Method in class AsciiDatabase.AsciiReader
Return the length of the file.
line - Variable in class AsciiDatabase.RCFile
 
Literal - class ModSQL.Literal.
Wrapper for literal values.
Literal() - Constructor for class ModSQL.Literal
Constructor for null value.
Literal(boolean) - Constructor for class ModSQL.Literal
Constructor for boolean.
Literal(double) - Constructor for class ModSQL.Literal
Constructor for double.
Literal(int) - Constructor for class ModSQL.Literal
Constructor for integer.
Literal(long) - Constructor for class ModSQL.Literal
Constructor for long.
Literal(Object) - Constructor for class ModSQL.Literal
Constructor for java object.
LiteralRow - class ModSQL.LiteralRow.
This class represents a literal row constructor.
LiteralRow() - Constructor for class ModSQL.LiteralRow
Default constructor (no columns).
LiteralRow(Function) - Constructor for class ModSQL.LiteralRow
Constructor to set first column.
LiteralTable - class ModSQL.LiteralTable.
A literal table is a list of rows consisting of RowConstructor or Function objects.
LiteralTable() - Constructor for class ModSQL.LiteralTable
Constructor.
lookupFunction(String) - Method in class ModSQL.Select
Lookup description in column_names array and return matching columns entry if match is found.
lookupFunction(String) - Method in class ModSQL.TableReader
Lookup description in list of tables to find a matching column.
lookupFunction(String) - Method in interface ModSQL.FunctionProvider
This method will attempt to find an appropriate function described by the provided description.
LOWER - Static variable in class ModSQL.Function_String
Function is LOWER().
LPAD - Static variable in class ModSQL.Function_String
Function is LPAD().
LT - Static variable in class ModSQL.Operator_Compare
Comparison operator (less than).
LT - Static variable in class ModSQL.Operator_In
Comparison operator (less than).
LTE - Static variable in class ModSQL.Operator_Compare
Comparison operator (less or equal).
LTE - Static variable in class ModSQL.Operator_In
Comparison operator (less or equal).

M

majorVersion - Static variable in class ModSQL.DriverConfig
Major version number.
majorVersion - Static variable in class SampleDatabase.Manager
 
majorVersion - Static variable in class TemporaryDatabase.Manager
 
majorVersion - Static variable in class AsciiDatabase.Manager
 
makeArray(String) - Static method in class ModSQL.DriverConfig
This convenience method can be used to break a color-separated list of strings into an array of String objects.
manager - Variable in class ModSQL.Select
Table manager used to open tables.
manager - Variable in class ModSQL.Insert
Table manager used to open tables.
Manager - class SampleDatabase.Manager.
A sample DatabaseManager implementation for ModSQL.
Manager - class TemporaryDatabase.Manager.
Database for storage of temporary (in memory) tables.
Manager - class AsciiDatabase.Manager.
A flexable method of turning flat ascii files into databases.
Manager() - Constructor for class SampleDatabase.Manager
 
Manager() - Constructor for class TemporaryDatabase.Manager
 
Manager() - Constructor for class AsciiDatabase.Manager
Create new Manager.
Manager(String) - Constructor for class AsciiDatabase.Manager
Create new Manager with specifed configuration file.
managers - Static variable in class ModSQL.MetaManager
Array of database managers.
map - Variable in class ModSQL.IndexTable_Hash
 
match_all - Variable in class ModSQL.Operator_In
True if all rows must match.
MATCH_BEGINS - Static variable in interface ModSQL.Function
Match operator (begins with).
MATCH_EQU - Static variable in interface ModSQL.Function
Match operator (equal).
MATCH_GT - Static variable in interface ModSQL.Function
Match operator (greater than).
MATCH_GTE - Static variable in interface ModSQL.Function
Match operator (greater or equal).
MATCH_LT - Static variable in interface ModSQL.Function
Match operator (less than).
MATCH_LTE - Static variable in interface ModSQL.Function
Match operator (less or equal).
MATCH_NE - Static variable in interface ModSQL.Function
Match operator (not equal).
max - Variable in class ModSQL.Aggregate_MinMax
Function type: true for MAX(), false for MIN().
maxdelimiter - Variable in class AsciiDatabase.AsciiTable
Max number of delimited fields.
maxlen - Variable in class TemporaryDatabase.Column
 
maxStringLength(int) - Method in class TemporaryDatabase.TableData
 
mergeWith(IndexTableRowset) - Method in class ModSQL.IndexTableRowset
Merge another rowset with this one.
MetaManager - class ModSQL.MetaManager.
DatabaseManager that can be used to combine multiple DatabaseManagers into one metadatabase.
MetaManager() - Constructor for class ModSQL.MetaManager
Constructor.
minmax - Variable in class ModSQL.Aggregate_MinMax
Current minimum/maximum value.
minorVersion - Static variable in class ModSQL.DriverConfig
Minor version number.
minorVersion - Static variable in class SampleDatabase.Manager
 
minorVersion - Static variable in class TemporaryDatabase.Manager
 
minorVersion - Static variable in class AsciiDatabase.Manager
 
MOD - Static variable in class ModSQL.Function_Math
Function is MOD().
mod(Number, Number) - Static method in class ModSQL.NumberMath
Compute the least non-negative residue of n mod d.
ModSQL - package ModSQL
 
moveToCurrentRow() - Method in class ModSQL.ResultSet
Move the cursor to the remembered cursor position, usually the current row.
moveToInsertRow() - Method in class ModSQL.ResultSet
Move to the insert row.
Multiply(Number, double) - Static method in class AsciiDatabase.AsciiTable
Multiply a double to a Number.
multiply(Number, Number) - Static method in class ModSQL.NumberMath
Multiply two Number objects to produce an appropriate Number object.

N

name - Variable in class ModSQL.SelectTable
Name of table.
name - Variable in class SampleDatabase.TableTemplate
 
name - Variable in class TemporaryDatabase.Column
 
name - Variable in class TemporaryDatabase.TableData
 
name - Variable in class AsciiDatabase.ColumnProperties
 
name - Variable in class AsciiDatabase.AsciiTable
Name of this table.
nativeSQL(String) - Method in class ModSQL.Connection
A driver may convert the JDBC sql grammar into its system's native SQL grammar prior to sending it; nativeSQL returns the native form of the statement that the driver would have sent.
ncolumns - Variable in class ModSQL.Operator_Compare
Number of columns in row-constructor.
ncolumns - Variable in class ModSQL.Operator_In
Number of columns in row-constructor.
ncolumns - Variable in class ModSQL.LiteralTable
Number of columns in table.
ncolumns - Variable in class AsciiDatabase.AsciiTable
Number of columns.
NE - Static variable in class ModSQL.Operator_Compare
Comparison operator (not equal).
NE - Static variable in class ModSQL.Operator_In
Comparison operator (not equal).
negate(Number) - Static method in class ModSQL.NumberMath
Negate a Number object.
next() - Method in class ModSQL.ResultSet
A ResultSet is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.
next() - Method in class ModSQL.Select
The table is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.
next() - Method in interface ModSQL.Table
The table is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.
next() - Method in class ModSQL.IndexTable_Sort
 
next() - Method in class ModSQL.IndexTable_Hash
 
next() - Method in interface ModSQL.DatabaseTableBase
A DatabaseTable is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.
next() - Method in class ModSQL.TableReader
Advance to next row.
next() - Method in class ModSQL.SelectTable
Advance to next row in table.
next() - Method in class ModSQL.LiteralTable
The table is initially positioned before its first row; the first call to next makes the first row the current row; the second call makes the second row the current row, etc.
next() - Method in class SampleDatabase.TableTemplate
 
next() - Method in class TemporaryDatabase.Table
 
next() - Method in class AsciiDatabase.AsciiTable
Advance to next row.
nfiles - Variable in class AsciiDatabase.AsciiTable
Total number of data files.
nrows - Variable in class TemporaryDatabase.TableData
 
nrows - Variable in class TemporaryDatabase.Table
 
nsourcerows - Variable in class AsciiDatabase.AsciiTable
Number of rows per data block.
null_row - Variable in class ModSQL.Select
Array of null references to return as a null row.
nullPlusNonNullIsNull() - Method in class ModSQL.DatabaseMetaData
Are concatenations between NULL and non-NULL values NULL? A JDBC-Compliant driver always returns true.
nullsAreSortedAtEnd() - Method in class ModSQL.DatabaseMetaData
Are NULL values sorted at the end regardless of sort order?
nullsAreSortedAtStart() - Method in class ModSQL.DatabaseMetaData
Are NULL values sorted at the start regardless of sort order?
nullsAreSortedHigh() - Method in class ModSQL.DatabaseMetaData
Are NULL values sorted high?
nullsAreSortedLow() - Method in class ModSQL.DatabaseMetaData
Are NULL values sorted low?
NumberMath - class ModSQL.NumberMath.
A class very much like java.lang.Math, but for doing math on Number objects.
NumberMath() - Constructor for class ModSQL.NumberMath
 
nval - Variable in class AsciiDatabase.ColumnOption
 
nvalvalid - Variable in class AsciiDatabase.ColumnOption
 

O

offset - Variable in class AsciiDatabase.SourceProperties
 
offset - Variable in class AsciiDatabase.RowOption_skip
 
offset - Variable in class AsciiDatabase.RowOption_select
 
offset - Variable in class AsciiDatabase.RowId
 
op - Variable in class ModSQL.Function_Math
Which function are we? One of the above constants.
op - Variable in class ModSQL.Aggregate_Math
Which function are we? One of the constants above.
op - Variable in class ModSQL.Function_String
Which function are we? One of the above constants.
op - Variable in class ModSQL.Operator_Compare
Which operator? One of the above constants.
op - Variable in class ModSQL.Operator_In
Which operator? One of the above constants.
openIndex(DatabaseTable, String) - Static method in class ModSQL.IndexTable
Attempt to open index on the specified column of an open table.
openIndex(int) - Method in interface ModSQL.DatabaseTable
Returns an index on the specified column.
openIndex(int) - Method in class ModSQL.SelectTable
Open an index on the table.
openIndex(int) - Method in class SampleDatabase.TableTemplate
 
openIndex(int) - Method in class TemporaryDatabase.Table
 
openIndex(int) - Method in class AsciiDatabase.AsciiTable
Open index of specified column.
openTable(String) - Method in interface ModSQL.DatabaseManager
Opens the database table with the specified name for read only access.
openTable(String) - Method in class ModSQL.MetaManager
Open table (read-only) using the first manager that provides the table.
openTable(String) - Method in class SampleDatabase.Manager
 
openTable(String) - Method in class TemporaryDatabase.Manager
 
openTable(String) - Method in class AsciiDatabase.Manager
Opens the named table for read only access.
openTable(String, boolean) - Method in interface ModSQL.DatabaseManager
Opens the database table with the specified name with read only or read write access.
openTable(String, boolean) - Method in class ModSQL.MetaManager
Open table using the first manager that provides the table.
openTable(String, boolean) - Method in class SampleDatabase.Manager
 
openTable(String, boolean) - Method in class TemporaryDatabase.Manager
 
openTable(String, boolean) - Method in class AsciiDatabase.Manager
Opens the named table.
Operator - class ModSQL.Operator.
Abstract implementation of Function to simplify the implementation of operators.
Operator_Add - class ModSQL.Operator_Add.
SQL operator "+".
Operator_Add() - Constructor for class ModSQL.Operator_Add
 
Operator_Compare - class ModSQL.Operator_Compare.
SQL comparison operators.
Operator_Compare(int) - Constructor for class ModSQL.Operator_Compare
Constructor.
Operator_Concat - class ModSQL.Operator_Concat.
SQL operator "||".
Operator_Concat() - Constructor for class ModSQL.Operator_Concat
 
Operator_Divide - class ModSQL.Operator_Divide.
SQL operator "/".
Operator_Divide() - Constructor for class ModSQL.Operator_Divide
 
Operator_Exists - class ModSQL.Operator_Exists.
Implementation of EXISTS operator.
Operator_Exists() - Constructor for class ModSQL.Operator_Exists
 
Operator_In - class ModSQL.Operator_In.
SQL comparison operators with a table on the RHS.
Operator_In(int, boolean) - Constructor for class ModSQL.Operator_In
Constructor.
Operator_Is - class ModSQL.Operator_Is.
SQL operator IS.
Operator_Is() - Constructor for class ModSQL.Operator_Is
 
Operator_Like - class ModSQL.Operator_Like.
SQL operator LIKE.
Operator_Like() - Constructor for class ModSQL.Operator_Like
 
Operator_Logical - class ModSQL.Operator_Logical.
SQL operators AND and OR.
Operator_Logical(boolean) - Constructor for class ModSQL.Operator_Logical
Constructor.
Operator_Multiply - class ModSQL.Operator_Multiply.
SQL operator "*".
Operator_Multiply() - Constructor for class ModSQL.Operator_Multiply
 
Operator_Negate - class ModSQL.Operator_Negate.
SQL operator "-".
Operator_Negate() - Constructor for class ModSQL.Operator_Negate
Default constructor.
Operator_Negate(Function) - Constructor for class ModSQL.Operator_Negate
Constructor with parameter.
Operator_Not - class ModSQL.Operator_Not.
SQL operator NOT.
Operator_Not() - Constructor for class ModSQL.Operator_Not
Default constructor.
Operator_Not(Function) - Constructor for class ModSQL.Operator_Not
Constructor with parameter.
Operator() - Constructor for class ModSQL.Operator
 
optimize() - Method in class ModSQL.AbstractFunction
This method sets up static arrays for the parameters and their values, calls optimize() for each parameter, and initializes the evalute_order array to appropriate values (using information provided using evaluateOrder(), if any).
optimize() - Method in class ModSQL.Operator_Logical
Prepare the function for use.
optimize() - Method in class ModSQL.Operator_Add
Prepare the function for use.
optimize() - Method in class ModSQL.IndirectFunction
If the function has been set, it is optimized.
optimize() - Method in class ModSQL.Select
Optimize query and prepare for execution.
optimize() - Method in class ModSQL.Function_Math
Prepare the function for use.
optimize() - Method in interface ModSQL.Table
Prepare the table for use.
optimize() - Method in class ModSQL.Operator_Is
Prepare the function for use.
optimize() - Method in class ModSQL.Operator_Negate
Prepare the function for use.
optimize() - Method in class ModSQL.Operator_Not
Prepare the function for use.
optimize() - Method in class ModSQL.Operator_Concat
Prepare the function for use.
optimize() - Method in class ModSQL.LiteralRow
Prepare the row for use.
optimize() - Method in class ModSQL.Function_NVL
Prepare the function for use.
optimize() - Method in class ModSQL.Literal
Does nothing.
optimize() - Method in class ModSQL.Aggregate_Math
Prepare the function for use.
optimize() - Method in class ModSQL.Aggregate_MinMax
Prepare the function for use.
optimize() - Method in class ModSQL.Function_String
Prepare the function for use.
optimize() - Method in class ModSQL.Insert
Optimize query.
optimize() - Method in class ModSQL.ColumnValue
This implementation only sets the type variable.
optimize() - Method in class ModSQL.Operator_Compare
Prepare the function for use.
optimize() - Method in class ModSQL.Drop
Optimize query.
optimize() - Method in class ModSQL.Operator_In
Prepare the function for use.
optimize() - Method in class ModSQL.Operator_Divide
Prepare the function for use.
optimize() - Method in interface ModSQL.Query
Optimize the query before executing it.
optimize() - Method in class ModSQL.LiteralTable
Prepare the table for use.
optimize() - Method in class ModSQL.Operator_Exists
Prepare the function for use.
optimize() - Method in interface ModSQL.Function
Prepare the function for use.
optimize() - Method in class ModSQL.Create
Optimize query.
optimize() - Method in class ModSQL.Operator_Like
Prepare the function for use.
optimize() - Method in class ModSQL.Update
Optimize query.
optimize() - Method in class ModSQL.Delete
Optimize query.
optimize() - Method in class ModSQL.Aggregate_Count
Prepare the function for use.
optimize() - Method in class ModSQL.Operator_Multiply
Prepare the function for use.
optimized - Variable in class ModSQL.Select
Has optimize been called?
optimizeParameterOrder(Function) - Method in class ModSQL.TableReader
Reorder parameters in function to optimize query efficiency.
optimizeParameterOrder(Function, BitSet) - Method in class ModSQL.TableReader
Reorder parameters in function to optimize query efficiency.
options - Variable in class AsciiDatabase.SourceProperties
 
options - Variable in class AsciiDatabase.AsciiTable
Each row within a block can have multiple options applied to it before column data is extracted from it.
order_by - Variable in class ModSQL.Select
List of functions to ORDER BY.
order_by_dir - Variable in class ModSQL.Select
ORDER BY order: true for ascending, false for decending.
order_by_dup - Variable in class ModSQL.Select
Flag indicating that order_by entry is dup of columns entry.
order_by_indices - Variable in class ModSQL.Select
Indices into columns array.
Orders_Row - class SampleDatabase.Orders_Row.
See TableTemplate for information about this class.
Orders_Row(String, String) - Constructor for class SampleDatabase.Orders_Row
 
Orders_Table - class SampleDatabase.Orders_Table.
See TableTemplate for information about this class.
Orders_Table() - Constructor for class SampleDatabase.Orders_Table
 
othersDeletesAreVisible(int) - Method in class ModSQL.DatabaseMetaData
 
othersInsertsAreVisible(int) - Method in class ModSQL.DatabaseMetaData
 
othersUpdatesAreVisible(int) - Method in class ModSQL.DatabaseMetaData
Determine whether changes made by others are visible.
out_of_order - Variable in class ModSQL.AbstractFunction
Are the parameters out-of-order? Used by toString().
ownDeletesAreVisible(int) - Method in class ModSQL.DatabaseMetaData
 
OwnerFirstName - Variable in class SampleDatabase.AntiqueOwners_Row
 
OwnerID - Variable in class SampleDatabase.AntiqueOwners_Row
 
OwnerID - Variable in class SampleDatabase.Orders_Row
 
OwnerLastName - Variable in class SampleDatabase.AntiqueOwners_Row
 
ownInsertsAreVisible(int) - Method in class ModSQL.DatabaseMetaData
 
ownUpdatesAreVisible(int) - Method in class ModSQL.DatabaseMetaData
Determine whether a result set's own changes visible.

P

parameter_constant - Variable in class ModSQL.AbstractFunction
Array to keep track of which parameters are constant.
parameter_value - Variable in class ModSQL.AbstractFunction
Array for storing parameter values (constant or otherwise).
parameters - Variable in class ModSQL.AbstractFunction
Array of parameters after optimize.
parameters_array - Variable in class ModSQL.AbstractFunction
Array of parameters before optimize.
parent - Variable in class ModSQL.TableReader
Reference to parent TableReader (used in subqueries).
parent_columns - Variable in class ModSQL.TableReader
Columns from parent reader referenced in this query.
parentReferenced() - Method in class ModSQL.TableReader
Are parent reader columns referenced here?
ParseColumnDef(ColumnProperties, SourceProperties, String, int) - Method in class AsciiDatabase.AsciiTable
Parse an entire column definition.
ParseColumnOptions(String) - Method in class AsciiDatabase.AsciiTable
Parse column options.
parseColumnType(StreamTokenizer) - Static method in class ModSQL.Create
Parses an SQL type and returns a two element array describing the type.
ParseCreate(StreamTokenizer) - Method in class ModSQL.Create
Parse create query of the form:
CREATE INDEX [indexname] ON tablename [USING indextype] (column);
CREATE TABLE tablename (column list);
ParseCreateIndex(StreamTokenizer) - Method in class ModSQL.Create
Parse create index query of the form:
CREATE INDEX [indexname] ON tablename [USING indextype] (column);
ParseCreateTable(StreamTokenizer) - Method in class ModSQL.Create
Parse create table query of the form:
CREATE TABLE tablename (column list);
ParseDelete(StreamTokenizer) - Method in class ModSQL.Delete
Parse delete query of the form:
DELETE FROM tablename [ WHERE condition ]
ParseDrop(StreamTokenizer) - Method in class ModSQL.Drop
Parse drop query of the form:
DROP INDEX tablename.column;
DROP TABLE tablename;
ParseDropIndex(StreamTokenizer) - Method in class ModSQL.Drop
Parse drop index query of the form:
DROP INDEX tablename.column;
ParseDropTable(StreamTokenizer) - Method in class ModSQL.Drop
Parse drop table query of the form:
DROP TABLE tablename;
parseExpression(StreamTokenizer, DatabaseManager) - Static method in class ModSQL.Expression
Parse an arbitrary SQL expression and return the root Function of the graph of Function's that results.
parseExpression(StreamTokenizer, DatabaseManager, int) - Static method in class ModSQL.Expression
Generalized version of above method.
ParseInsert(StreamTokenizer) - Method in class ModSQL.Insert
Parse update query of the form:
INSERT INTO tablename (columns,...) VALUES (values,...);
INSERT INTO tablename (columns,...) SELECT ...;
parseQuery(String) - Method in class ModSQL.PreparedStatement
Parse a SQL query.
ParseRowOption(String) - Method in class AsciiDatabase.AsciiTable
Parse a row option.
parseSelect(StreamTokenizer) - Method in class ModSQL.Select
Parse entire SELECT query.
parseTableExpression(StreamTokenizer, DatabaseManager) - Static method in class ModSQL.Expression
Parse an arbitrary table expression.
ParseType(String) - Method in class AsciiDatabase.AsciiTable
Parse column type string.
ParseUpdate(StreamTokenizer) - Method in class ModSQL.Update
Parse update query of the form:
UPDATE tablename SET columns [ WHERE condition ]
parseValue(StreamTokenizer, DatabaseManager) - Static method in class ModSQL.Expression
Parse an arbitrary SQL value and return the root Function of the graph of Function's that results.
patternCompare(String, String) - Static method in class ModSQL.Operator_Like
Recursive LIKE pattern matching.
pkg - Static variable in class SampleDatabase.Manager
 
pkg - Static variable in class TemporaryDatabase.Manager
 
Position - Variable in class SampleDatabase.EmployeeStatisticsTable_Row
 
postfixParameters() - Method in class ModSQL.AbstractFunction
Optional String to insert after parameter list in toString().
postfixParameters() - Method in class ModSQL.Operator_In
This method returns ",RHS", provided a table has been specified for the RHS.
postfixParameters() - Method in class ModSQL.Operator_Exists
Returns table as string if set.
POWER - Static variable in class ModSQL.Function_Math
Function is POWER().
power(Number, Number, int) - Static method in class ModSQL.Function_Math
Compute n to the power of e and return a number of the desired type.
prefixParameters() - Method in class ModSQL.AbstractFunction
Optional String to insert before parameter list in toString().
prefixParameters() - Method in class ModSQL.AbstractAggregate
Returns "DISTINCT" if distinct was requested, or "*" if the parameter list is empty and optimize() has already been called.
prepareCall(String) - Method in class ModSQL.Connection
A SQL stored procedure call statement is handled by creating a CallableStatement for it.
prepareCall(String, int, int) - Method in class ModSQL.Connection
Same as prepareCall() above, but allows the default result set type and result set concurrency type to be overridden.
PreparedStatement - class ModSQL.PreparedStatement.
An object that represents a precompiled SQL statement.
PreparedStatement(DatabaseManager, Connection) - Constructor for class ModSQL.PreparedStatement
Setup an empty statement.
PreparedStatement(DatabaseManager, Connection, String) - Constructor for class ModSQL.PreparedStatement
Create a prepared statement and parse the query provided.
prepareStatement(String) - Method in class ModSQL.Connection
A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object.
prepareStatement(String, int, int) - Method in class ModSQL.Connection
Same as prepareStatement() above, but allows the default result set type and result set concurrency type to be overridden.
previous() - Method in class ModSQL.ResultSet
Moves to the previous row in the result set.
Price - Variable in class SampleDatabase.Antiques_Row
 
PRIORITY_ADD - Static variable in class ModSQL.Expression
Arbitrarily scaled priority number (for addition).
PRIORITY_AND - Static variable in class ModSQL.Expression
Arbitrarily scaled priority number (for AND).
PRIORITY_COMPARE - Static variable in class ModSQL.Expression
Arbitrarily scaled priority number (for comparisions).
PRIORITY_MULTIPLY - Static variable in class ModSQL.Expression
Arbitrarily scaled priority number (for multiplication).
PRIORITY_NOT - Static variable in class ModSQL.Expression
Arbitrarily scaled priority number (for NOT).
PRIORITY_OR - Static variable in class ModSQL.Expression
Arbitrarily scaled priority number (for OR).
props - Static variable in class ModSQL.DriverConfig
Properties read from configuration file.
pushBack() - Method in class AsciiDatabase.AsciiReader
Push back the last byte read so it can be read again.

Q

query - Variable in class ModSQL.ResultSet
Query that generated this result set.
query - Variable in class ModSQL.ResultSetMetaData
Query that generated the ResultSet.
query - Variable in class ModSQL.PreparedStatement
Current prepared query.
query - Variable in class ModSQL.SelectTable
Query that generated the table.
Query - interface ModSQL.Query.
Interface for the various SQL query classes.
query() - Method in class ModSQL.Select.OrderByComparator
Used in equals() above.

R

rcfile - Variable in class AsciiDatabase.Manager
 
RCFile - class AsciiDatabase.RCFile.
Class for reading configuration files in the following format:
RCFile(File) - Constructor for class AsciiDatabase.RCFile
Opens the configuration file.
read_sequence - Variable in class ModSQL.TableReader
Sequence number for read tables (-1 for not read yet).
read() - Method in class AsciiDatabase.AsciiReader
Read a byte from the file.
read(byte[]) - Method in class AsciiDatabase.AsciiReader
Read data from the file.
read(byte[], int, int) - Method in class AsciiDatabase.AsciiReader
Read data from the file.
readAllColumns() - Method in class ModSQL.TableReader
Make sure all tables have been read from.
readAllParentColumns() - Method in class ModSQL.TableReader
Make sure all tables referenced from a parent reader have been read by attempting to fetch values for all referenced columns.
readAllTables() - Method in class ModSQL.TableReader
Make sure all tables have been read from.
ReadCharValue(String) - Method in class AsciiDatabase.RCFile
Searches for a specific value (property=value pair) at the beginning of the file (before the first header is found).
ReadCharValue(String, String) - Method in class AsciiDatabase.RCFile
Searches for a specific value (property=value pair) under a particular header.
readColumns(int) - Method in class ModSQL.TableReader
Make sure tables have been read by attempting to fetch values for the first ncolumn referenced columns.
readColumnValue(int, int) - Method in class ModSQL.TableReader
Read the value of the specified column in the specified table.
readColumnValue(int, int, Object) - Method in class ModSQL.TableReader
Read the value of the specified column in the specified table.
ReadCompiledFile(File) - Method in class AsciiDatabase.AsciiTable
Read the compiled (binary) version of the table definition file.
reader - Variable in class ModSQL.EndOfTable
TableReader responsible to table.
reader - Variable in class ModSQL.Select
Reader to get database rows from.
reader - Variable in class ModSQL.ColumnValue
TableReader managing the table we get data from.
reader - Variable in class ModSQL.Update
Reader used to fetch rows (set by optimize).
reader - Variable in class ModSQL.Delete
Reader used to fetch rows (set by optimize).
reader - Variable in class AsciiDatabase.RCFile
 
readline() - Method in class AsciiDatabase.RCFile
Read a single line of the file.
readLine() - Method in class AsciiDatabase.AsciiReader
Read a single line of an ascii file.
ReadNextCharValue() - Method in class AsciiDatabase.RCFile
Searches the file for the next value (property=value pair).
ReadNextCharValue(String) - Method in class AsciiDatabase.RCFile
Searches the file (starting at the current position) for a specific value (property=value pair).
readonly - Variable in class TemporaryDatabase.Table
 
readParentColumns(int) - Method in class ModSQL.TableReader
Make sure tables referenced from a parent reader have been read by attempting to fetch values for the first ncolumns referenced columns from the parent.
ReadRawTableDefinition(File) - Method in class AsciiDatabase.AsciiTable
Read a raw (uncompressed) table definition file.
readTable(int, int) - Method in class ModSQL.TableReader
Start reading the specified table.
ReadTableDefinition(String) - Method in class AsciiDatabase.AsciiTable
Read the table definition file.
readToEOL(byte[]) - Method in class AsciiDatabase.AsciiReader
Read until the end of line is reached.
readToEOL(byte[], int, int) - Method in class AsciiDatabase.AsciiReader
Read until the end of line is reached.
record - Variable in class AsciiDatabase.AsciiTable
Buffer for holding blocks of data.
recordsize - Variable in class AsciiDatabase.AsciiTable
Size of fixed length records or -1 for variable length records.
recordvalid - Variable in class AsciiDatabase.AsciiTable
Length of valid data within record.
ref_count - Variable in class TemporaryDatabase.TableData
 
refreshRow() - Method in class ModSQL.ResultSet
Refresh the value of the current row with its current value in the database.
registerManager(DatabaseManager) - Static method in class ModSQL.MetaManager
Register a database manager with the meta-manager.
registerWith(Object) - Method in class ModSQL.AbstractFunction
This implementation simply calls registerWith() for all parameters.
registerWith(Object) - Method in class ModSQL.IndirectFunction
This method responds to two objects: 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.
registerWith(Object) - Method in class ModSQL.AbstractAggregate
This implementation blocks the registerWith() call if the supplied object is of type GroupByList to prevent ColumnValue's that appear in the GROUP BY list from mistakenly being labled as aggregate.
registerWith(Object) - Method in class ModSQL.Select
Most objects passed to this method will be passed on to all contained function objects.
registerWith(Object) - Method in interface ModSQL.Table
Some functions (most notably IndirectValue) needs to register themselves before optimize() can be called.
registerWith(Object) - Method in class ModSQL.Literal
Does nothing as a Literal has no parameters.
registerWith(Object) - Method in class ModSQL.ColumnValue
This method is used by the TableReader object when ordering parameters.
registerWith(Object) - Method in class ModSQL.Operator_In
Since table is not a normal parameter, we need to ensure objects to register with get passed to it.
registerWith(Object) - Method in class ModSQL.LiteralTable
This method will pass the object on to all Function objects contained within.
registerWith(Object) - Method in class ModSQL.Operator_Exists
Since the table is not a regular parameter, this method is need to ensure the table can register itself with objects as needed.
registerWith(Object) - Method in interface ModSQL.Function
Some functions (most notably IndirectValue) need to register themselves before optimize() can be called.
relative(int) - Method in class ModSQL.ResultSet
Moves a relative number of rows, either positive or negative.
release() - Method in class TemporaryDatabase.TableData
Release access to table data.
remove(int) - Method in class TemporaryDatabase.TableData
Delete a row of data.
removeDoubleNegation(Function) - Static method in class ModSQL.Operator
Remove all instances of double negation operators if x is an Operator_Negate object.
removeDoubleNot(Function) - Static method in class ModSQL.Operator
Remove all instances of double NOT operators if x is an Operator_Not object.
repeatLine - Variable in class AsciiDatabase.RCFile
 
reset() - Method in class ModSQL.AbstractFunction
This implementation simply calls reset() for all parameters and is intended to be used by non-aggregate functions.
reset() - Method in class ModSQL.IndirectFunction
Calls reset() for the underlying function and set the last value returned by evaluate() to null.
reset() - Method in class ModSQL.AbstractAggregate
This implemenation calls reset() for all parameters and clears the distinct_set hash table.
reset() - Method in class ModSQL.Select
In the case of aggregate functions, this method resets the state of the function to the state it was in before the first call to evaluate().
reset() - Method in class ModSQL.TableReader
Invalidate all column data and reset tables to before the first row.
reset() - Method in class ModSQL.Literal
Does nothing.
reset() - Method in class ModSQL.Aggregate_Math
Resets the current count and sums to zero.
reset() - Method in class ModSQL.Aggregate_MinMax
Reset the minimum/maximum object to NULL.
reset() - Method in class ModSQL.ColumnValue
Reset aggregate function.
reset() - Method in interface ModSQL.Function
In the case of aggregate functions, this method resets the state of the function to the state it was in before the first call to evaluate().
reset() - Method in class ModSQL.Aggregate_Count
Resets the current count to zero.
ResetFile() - Method in class AsciiDatabase.RCFile
Reset to the beginning of the file.
ResetStatement() - Method in class ModSQL.PreparedStatement
Close and delete any SQL statement currently prepared.
ResetTable(int) - Method in class AsciiDatabase.AsciiTable
Reset the table to before the beginning of the specified data file.
ResultSet - class ModSQL.ResultSet.
A ResultSet provides access to a table of data.
ResultSet(Select, PreparedStatement) - Constructor for class ModSQL.ResultSet
Constructor.
ResultSetMetaData - class ModSQL.ResultSetMetaData.
A ResultSetMetaData object can be used to find out about the types and properties of the columns in a ResultSet.
ResultSetMetaData(Select) - Constructor for class ModSQL.ResultSetMetaData
Constructor.
return_type - Variable in class ModSQL.Operator_Add
SQL return type of operator.
return_type - Variable in class ModSQL.Function_Math
SQL return type for this function.
return_type - Variable in class ModSQL.Function_NVL
Return type of function.
return_type - Variable in class ModSQL.Aggregate_Math
SQL return type for this function.
return_type - Variable in class ModSQL.Operator_Divide
SQL type of returned value.
return_type - Variable in class ModSQL.Operator_Multiply
Return type of operator.
RIGHT - Static variable in class ModSQL.Function_String
Function is RIGHT().
roffset - Variable in class AsciiDatabase.SourceProperties
real offset
roll(int, int) - Static method in class AsciiDatabase.SourceProperties
 
rollback() - Method in class ModSQL.Connection
Rollback drops all changes made since the previous commit/rollback and releases any database locks currently held by the Connection.
ROUND - Static variable in class ModSQL.Function_Math
Function is ROUND().
round(Number) - Static method in class ModSQL.Function_Math
Round number to nearest integer.
round(Number, Number) - Static method in class ModSQL.Function_Math
Round number of specified number of decimal places.
row - Variable in class ModSQL.Operator_Is
Row in case of row-constructor on LHS.
row - Variable in class ModSQL.Operator_In
Row-constructor on LHS if needed.
row_available - Variable in class ModSQL.TableReader
If last_read>=0, then this boolean indicates that rows have been read and are available for all open tables.
row_value - Variable in class ModSQL.Operator_Compare
Value of the parameters.
RowConstructor - interface ModSQL.RowConstructor.
A row constructor (in SQL speak) is a single row of one or more columns.
rowDeleted() - Method in class ModSQL.ResultSet
Determine if this row has been deleted.
rowid - Variable in class ModSQL.IndexTableRowset
Array of rowids.
rowid - Variable in class SampleDatabase.TableTemplate
 
rowid - Variable in class TemporaryDatabase.Table
 
RowId - class AsciiDatabase.RowId.
 
rowid_array - Variable in class ModSQL.IndexTableRowset
Temporary array of rowids.
RowId(int, long, int) - Constructor for class AsciiDatabase.RowId
 
rowInserted() - Method in class ModSQL.ResultSet
Determine if the current row has been inserted.
rownum - Variable in class ModSQL.SelectTable
Current row number.
rowoffset - Variable in class AsciiDatabase.AsciiTable
Offset of current record within current file.
rowOK(byte[]) - Method in class AsciiDatabase.RowOption
Verify that a row can be extracted from a block of data.
rowOK(byte[]) - Method in class AsciiDatabase.RowOption_skip
 
rowOK(byte[]) - Method in class AsciiDatabase.RowOption_select
 
rowOK(String) - Method in class AsciiDatabase.RowOption
Verify that a row can be extracted from a block of data.
rowOK(String) - Method in class AsciiDatabase.RowOption_skip
 
rowOK(String) - Method in class AsciiDatabase.RowOption_select
 
RowOption - class AsciiDatabase.RowOption.
A row option is applied to one row within a data block.
RowOption_select - class AsciiDatabase.RowOption_select.
Option to accept the row if a specific ascii string is found at a specific location within the block.
RowOption_select(String) - Constructor for class AsciiDatabase.RowOption_select
 
RowOption_skip - class AsciiDatabase.RowOption_skip.
Option to skip the row if a specific ascii string is found at a specific location within the block.
RowOption_skip(String) - Constructor for class AsciiDatabase.RowOption_skip
 
RowOption() - Constructor for class AsciiDatabase.RowOption
 
rows - Variable in class ModSQL.Select
Cached rows.
rows - Variable in class ModSQL.IndexTableEntry
Rows that have the specified column value.
rows - Variable in class ModSQL.Operator_Compare
One row per parameter (only if we have row-constructors).
rows - Variable in class ModSQL.LiteralTable
Array of rows after optimize().
rows - Variable in class SampleDatabase.TableTemplate
 
rows - Variable in class TemporaryDatabase.TableData
 
rows_array - Variable in class ModSQL.LiteralTable
Array of rows before optimize() has been called.
rows_to_read - Variable in class ModSQL.IndexTable_Hash
 
rowUpdated() - Method in class ModSQL.ResultSet
Determine if the current row has been updated.
RPAD - Static variable in class ModSQL.Function_String
Function is RPAD().
rsize - Variable in class AsciiDatabase.SourceProperties
real size

S

Salary - Variable in class SampleDatabase.EmployeeStatisticsTable_Row
 
sameData(IndexTableEntry) - Method in class ModSQL.IndexTableEntry
Check if the other IndexTableEntry has the same column value.
SampleDatabase - package SampleDatabase
 
seek(long) - Method in class AsciiDatabase.AsciiReader
Seek to an arbitrary offset within the file.
Select - class ModSQL.Select.
Class to parse and execute an SQL SELECT statement.
Select.GroupByList - class ModSQL.Select.GroupByList.
Simple list of ColumnValue's in a SELECT query's GROUP BY list.
Select.GroupByList(Select) - Constructor for class ModSQL.Select.GroupByList
 
Select.OrderByComparator - class ModSQL.Select.OrderByComparator.
Comparator for sorting rows when evaluating ORDER BY.
Select.OrderByComparator(Select) - Constructor for class ModSQL.Select.OrderByComparator
 
Select(StreamTokenizer, DatabaseManager) - Constructor for class ModSQL.Select
Contructor to parse query.
SelectTable - class ModSQL.SelectTable.
Wrapper for a Select object to make it look like a DatabaseTable.
SelectTable(Table, String) - Constructor for class ModSQL.SelectTable
Query should already be optimized before using this constructor.
SellerID - Variable in class SampleDatabase.Antiques_Row
 
set_column - Variable in class ModSQL.Update
Array of column names to update.
set_value - Variable in class ModSQL.Update
New values for columns.
setArray(int, Array) - Method in class ModSQL.PreparedStatement
Sets the designated parameter to the given Array object.
setAsciiStream(int, InputStream, int) - Method in class ModSQL.PreparedStatement
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setAutoCommit(boolean) - Method in class ModSQL.Connection
If a connection is in auto-commit mode, then all its SQL statements will be executed and committed as individual transactions.
setBigDecimal(int, BigDecimal) - Method in class ModSQL.PreparedStatement
Sets the designated parameter to a java.math.BigDecimal value.
setBinaryStream(int, InputStream, int) - Method in class ModSQL.PreparedStatement
Sets the designated parameter to the given input stream, which will have the specified number of bytes.
setBlob(int, Blob) - Method in class ModSQL.PreparedStatement
Sets the designated parameter to the given Blob object.
setBoolean(int, boolean) - Method in class ModSQL.PreparedStatement
Sets the designated parameter to a Java boolean value.
setByte(int, byte) - Method in class ModSQL.PreparedStatement
Sets the designated parameter to a Java byte value.
setBytes(int, byte[]) - Method in class ModSQL.PreparedStatement
Sets the designated parameter to a Java array of bytes.
setCatalog(String) - Method in class ModSQL.Connection
A sub-space of this Connection's database may be selected by setting a catalog name.
setCharacterStream(int, Reader, int) - Method in class ModSQL.PreparedStatement
Sets the designated parameter to the given Reader object, which is the given number of characters long.
setClob(int, Clob) - Method in class ModSQL.PreparedStatement
Sets the designated parameter to the given Clob object.
setColumnValues(Object[]) - Method in class ModSQL.TableReader
Load columns values into respective columns.
setCursorName(String) - Method in class ModSQL.PreparedStatement
setCursorname defines the SQL cursor name that will be used by subsequent Statement execute methods.
setDate(int, Date) - Method in class ModSQL.PreparedStatement
Sets the designated parameter to a 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
 

T

table - Variable in class ModSQL.IndexTable_Sort
 
table - Variable in class ModSQL.IndexTable_Hash
 
table - Variable in class ModSQL.Insert
Database table to insert rows into (set by optimize).
table - Variable in class ModSQL.ColumnValue
Index of table in TableReader.
table - Variable in class ModSQL.Operator_In
Table on right-hand-side (RHS).
table - Variable in class ModSQL.Operator_Exists
Table to scan.
table - Variable in class ModSQL.Update
Database table to update (set by optimize).
table - Variable in class ModSQL.Delete
Database table to update (set by optimize).
Table - interface ModSQL.Table.
A table is zero or more rows.
Table - class TemporaryDatabase.Table.
Temporary (in memory) database tables.
table_aliases - Variable in class ModSQL.Select
Alternate names for tables (aliases).
table_list - Variable in class ModSQL.Select
List of tables from which rows are read.
table_needed - Variable in class ModSQL.TableReader.TableAccess
Tables needed by Function.
table_read - Variable in class ModSQL.TableReader
Actual table or index being read.
Table(TableData, boolean) - Constructor for class TemporaryDatabase.Table
 
TableData - class TemporaryDatabase.TableData.
Temporary (in memory) database table.
TableData(String) - Constructor for class TemporaryDatabase.TableData
 
tablemanager - Variable in class ModSQL.Connection
DatabaseManager to use for looking up tables.
tablemanager - Variable in class ModSQL.PreparedStatement
DatabaseManager to use when looking up table names.
tablemanager - Variable in class ModSQL.Drop
Table manager used to open tables.
tablemanager - Variable in class ModSQL.Create
Table manager used to open tables and create new tables.
tablemanager - Variable in class ModSQL.Update
Table manager used to open tables.
tablemanager - Variable in class ModSQL.Delete
Table manager used to open tables.
tablename - Variable in class ModSQL.Insert
Name of table.
tablename - Variable in class ModSQL.Drop
Name of table to drop.
tablename - Variable in class ModSQL.Create
Name of table to create.
tablename - Variable in class ModSQL.Update
Name of table.
tablename - Variable in class ModSQL.Delete
Name of table.
TableReader - class ModSQL.TableReader.
Keeps track of open tables, referenced columns, and current row being read from joined table.
TableReader.TableAccess - class ModSQL.TableReader.TableAccess.
Class to register access to particular tables and whether the tables can be accessed via an indexed column.
TableReader.TableAccess(TableReader) - Constructor for class ModSQL.TableReader.TableAccess
Constructor.
TableReader(DatabaseTable[], String[], TableReader) - Constructor for class ModSQL.TableReader
Constructor.
tables - Variable in class ModSQL.TableReader
Array of open tables.
tables - Static variable in class SampleDatabase.Manager
 
tables - Variable in class TemporaryDatabase.Manager
 
tablesignature - Variable in class AsciiDatabase.AsciiTable
This table's signature.
TableTemplate - class SampleDatabase.TableTemplate.
This is an abstract class that should be extended to create individual tables.
TableTemplate() - Constructor for class SampleDatabase.TableTemplate
 
TemporaryDatabase - package TemporaryDatabase
 
test(Object, Object) - Method in class ModSQL.Operator_Compare
 
test(Object, Object, int, int) - Static method in class ModSQL.Operator_Compare
Compare two objects according to op.
test(Object, Object, Object) - Method in class ModSQL.Operator_Compare
 
test(Object, Object, Object, int) - Static method in class ModSQL.Operator_Compare
 
testRow(Object[], Object[]) - Method in class ModSQL.Operator_In
Compare two rows according to op and using compare_type array.
testRow(Object[], Object[], int, int[]) - Static method in class ModSQL.Operator_Compare
Compare two rows according to op and using compare_type array.
testRowInequality(Object[], Object[], int, int[]) - Static method in class ModSQL.Operator_Compare
Compare two rows according to op (inequalities only) and using compare_type array.
text - Variable in class AsciiDatabase.RowOption_skip
 
text - Variable in class AsciiDatabase.RowOption_select
 
toBigDecimal(Number) - Static method in class ModSQL.NumberMath
Convert a Number object to a BigDecimal object.
toBigInteger(Number) - Static method in class ModSQL.NumberMath
Convert a Number object to a BigInteger object.
toString() - Method in class ModSQL.AbstractFunction
Outputs "functionName(parameter,...)".
toString() - Method in class ModSQL.IndirectFunction
Returns string version of function or description if function is not set yet.
toString() - Method in class ModSQL.Select
Returns human-readable string version of query (with surrounding brackets).
toString() - Method in class ModSQL.LiteralRow
Returns "column1" or "(column1,column2,...)".
toString() - Method in class ModSQL.Literal
Return human readable version of literal.
toString() - Method in class ModSQL.Insert
Returns human-readable string version of query (with surrounding brackets).
toString() - Method in class ModSQL.ColumnValue
Returns "table_alias.column_name".
toString() - Method in class ModSQL.PreparedStatement
Query as parsed.
toString() - Method in class ModSQL.Drop
Returns human-readable string version of query (with surrounding brackets).
toString() - Method in class ModSQL.SelectTable
Human readable description of table.
toString() - Method in class ModSQL.LiteralTable
String description of table in the form "(row1,row2,...)".
toString() - Method in class ModSQL.Create
Returns human-readable string version of query (with surrounding brackets).
toString() - Method in class ModSQL.Update
Returns human-readable string version of query (with surrounding brackets).
toString() - Method in class ModSQL.Delete
Returns human-readable string version of query (with surrounding brackets).
toString() - Method in class AsciiDatabase.RowId
 
toString(boolean) - Method in class ModSQL.Select
Returns human-readable string version of query.
toString(boolean) - Method in interface ModSQL.Table
Return human readable description of table.
toString(boolean) - Method in class ModSQL.Insert
Returns human-readable string version of query.
toString(boolean) - Method in class ModSQL.Drop
Returns human-readable string version of query.
toString(boolean) - Method in interface ModSQL.Query
Return human readable version of optimized query.
toString(boolean) - Method in class ModSQL.LiteralTable
Human readable description of table.
toString(boolean) - Method in class ModSQL.Create
Returns human-readable string version of query.
toString(boolean) - Method in class ModSQL.Update
Returns human-readable string version of query.
toString(boolean) - Method in class ModSQL.Delete
Returns human-readable string version of query.
TRUE_VALUE - Static variable in class ModSQL.Select
Constant true value as Boolean object.
type - Variable in class ModSQL.Literal
SQL type of value.
type - Variable in class ModSQL.ColumnValue
Column type (one of java.sql.Types values).
type - Variable in class TemporaryDatabase.Column
 
type - Variable in class AsciiDatabase.ColumnProperties
 
type - Variable in class AsciiDatabase.ColumnOption
 
type - Variable in class AsciiDatabase.SourceProperties
 
TYPE - Static variable in class ModSQL.IndexTable_Sort
 
TYPE - Static variable in class ModSQL.IndexTable_Hash
 

U

unreadline() - Method in class AsciiDatabase.RCFile
Push back the last line read so it can be read again.
Update - class ModSQL.Update.
Update will parse and execute an SQL UPDATE query.
Update(StreamTokenizer, DatabaseManager) - Constructor for class ModSQL.Update
Contructor to parse query.
updateAsciiStream(int, InputStream, int) - Method in class ModSQL.ResultSet
Update a column with an ascii stream value.
updateAsciiStream(String, InputStream, int) - Method in class ModSQL.ResultSet
Update a column with an ascii stream value.
updateBigDecimal(int, BigDecimal) - Method in class ModSQL.ResultSet
Update a column with a BigDecimal value.
updateBigDecimal(String, BigDecimal) - Method in class ModSQL.ResultSet
Update a column with a BigDecimal value.
updateBinaryStream(int, InputStream, int) - Method in class ModSQL.ResultSet
Update a column with a binary stream value.
updateBinaryStream(String, InputStream, int) - Method in class ModSQL.ResultSet
Update a column with a binary stream value.
updateBoolean(int, boolean) - Method in class ModSQL.ResultSet
Update a column with a boolean value.
updateBoolean(String, boolean) - Method in class ModSQL.ResultSet
Update a column with a boolean value.
updateByte(int, byte) - Method in class ModSQL.ResultSet
Update a column with a byte value.
updateByte(String, byte) - Method in class ModSQL.ResultSet
Update a column with a byte value.
updateBytes(int, byte[]) - Method in class ModSQL.ResultSet
Update a column with a byte array value.
updateBytes(String, byte[]) - Method in class ModSQL.ResultSet
Update a column with a byte array value.
updateCharacterStream(int, Reader, int) - Method in class ModSQL.ResultSet
Update a column with a character stream value.
updateCharacterStream(String, Reader, int) - Method in class ModSQL.ResultSet
Update a column with a character stream value.
updateColumnValue(int, int, Object) - Method in class ModSQL.TableReader
Update a column in the table.
updatecount - Variable in class ModSQL.PreparedStatement
Update count that resulted from executing the query.
updateDate(int, Date) - Method in class ModSQL.ResultSet
Update a column with a Date value.
updateDate(String, Date) - Method in class ModSQL.ResultSet
Update a column with a Date value.
updateDouble(int, double) - Method in class ModSQL.ResultSet
Update a column with a Double value.
updateDouble(String, double) - Method in class ModSQL.ResultSet
Update a column with a double value.
updateFloat(int, float) - Method in class ModSQL.ResultSet
Update a column with a float value.
updateFloat(String, float) - Method in class ModSQL.ResultSet
Update a column with a float value.
updateInt(int, int) - Method in class ModSQL.ResultSet
Update a column with an integer value.
updateInt(String, int) - Method in class ModSQL.ResultSet
Update a column with an integer value.
updateLong(int, long) - Method in class ModSQL.ResultSet
Update a column with a long value.
updateLong(String, long) - Method in class ModSQL.ResultSet
Update a column with a long value.
updateNull(int) - Method in class ModSQL.ResultSet
Give a nullable column a null value.
updateNull(String) - Method in class ModSQL.ResultSet
Update a column with a null value.
updateObject(int, Object) - Method in class ModSQL.ResultSet
Update a column with an Object value.
updateObject(int, Object) - Method in class ModSQL.IndexTable_Sort
 
updateObject(int, Object) - Method in class ModSQL.IndexTable_Hash
 
updateObject(int, Object) - Method in interface ModSQL.DatabaseTableBase
Update a column with an Object value.
updateObject(int, Object) - Method in class ModSQL.SelectTable
Update value of column.
updateObject(int, Object) - Method in class SampleDatabase.TableTemplate
 
updateObject(int, Object) - Method in class TemporaryDatabase.Table
 
updateObject(int, Object) - Method in class AsciiDatabase.AsciiTable
Change column data.
updateObject(int, Object, int) - Method in class ModSQL.ResultSet
Update a column with an Object value.
updateObject(String, Object) - Method in class ModSQL.ResultSet
Update a column with an Object value.
updateObject(String, Object, int) - Method in class ModSQL.ResultSet
Update a column with an Object value.
updateRow() - Method in class ModSQL.ResultSet
Update the underlying database with the new contents of the current row.
updatesAreDetected(int) - Method in class ModSQL.DatabaseMetaData
Determine whether or not a visible row update can be detected by calling ResultSet.rowUpdated().
updateShort(int, short) - Method in class ModSQL.ResultSet
Update a column with a short value.
updateShort(String, short) - Method in class ModSQL.ResultSet
Update a column with a short value.
updateString(int, String) - Method in class ModSQL.ResultSet
Update a column with a String value.
updateString(String, String) - Method in class ModSQL.ResultSet
Update a column with a String value.
updateTime(int, Time) - Method in class ModSQL.ResultSet
Update a column with a Time value.
updateTime(String, Time) - Method in class ModSQL.ResultSet
Update a column with a Time value.
updateTimestamp(int, Timestamp) - Method in class ModSQL.ResultSet
Update a column with a Timestamp value.
updateTimestamp(String, Timestamp) - Method in class ModSQL.ResultSet
Update a column with a Timestamp value.
UPPER - Static variable in class ModSQL.Function_String
Function is UPPER().
usesLocalFilePerTable() - Method in class ModSQL.DatabaseMetaData
Does the database use a file for each table?
usesLocalFiles() - Method in class ModSQL.DatabaseMetaData
Does the database store tables in a local file?

V

validlength - Variable in class AsciiDatabase.AsciiReader
Length of valid data in buffer.
validoffset - Variable in class AsciiDatabase.AsciiReader
Offset of next valid data in buffer.
value - Variable in class ModSQL.IndirectFunction
Function being wrapped.
value - Variable in class ModSQL.Literal
Literal value.
value - Variable in class ModSQL.ColumnValue
Value of column (valid if value_valid==true).
value_valid - Variable in class ModSQL.ColumnValue
Set to true if the value is valid.
version - Static variable in class ModSQL.DriverConfig
Text representation of version.
VERSION - Static variable in class ModSQL.IndexTable_Sort
 
VERSION - Static variable in class ModSQL.IndexTable_Hash
 

W

wasNull() - Method in class ModSQL.ResultSet
A column may have the value of SQL NULL; wasNull reports whether the last column read had this special value.
where - Variable in class ModSQL.Select
WHERE clause used to select rows of interest.
where - Variable in class ModSQL.Update
Where clause used to choose rows.
where - Variable in class ModSQL.Delete
Where clause used to choose rows.
WriteCompiledFile(File) - Method in class AsciiDatabase.AsciiTable
Attemp to write the compiled (binary) version of the table definition file.

Y

Y2K(Number, double) - Static method in class AsciiDatabase.AsciiTable
Convert 2-digit year to 4-digit year.

Z

zstream - Variable in class AsciiDatabase.AsciiReader
Stream used for compressed file.
zstreambuffer - Static variable in class AsciiDatabase.AsciiReader
Default buffer size for compressed files.

< A B C D E F G H I J L M N O P Q R S T U V W Y Z