: Index

Overview | Package | Class | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES

< 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

Overview | Package | Class | Tree | Deprecated | Index | Help
PREV NEXT | FRAMES NO FRAMES