FlatFile (JMSL Numerical Library (jmsl) 2021.0.0 API)

java.lang.Object
- com.imsl.io.AbstractFlatFile
- - com.imsl.io.FlatFile

All Implemented Interfaces:

AutoCloseable, ResultSet, Wrapper

Direct Known Subclasses:

FlatFileEx1, FlatFileEx2
```
public class FlatFile
extends AbstractFlatFile
```
Reads a text file as a ResultSet.
FlatFile extends AbstractFlatFile to handle text flat files.

As the file is read, it is split into lines using the BufferedReader.readLine(boolean) method. Each line is then split into tokens using a Tokenizer. Finally, each token string is converted into an Object using a Parser.

Parser is an interface defined within this class for converting a String into an Object. Parser objects for standard types are defined as static members of this class. By default, for each column its class is used to select one of these predefined parsers to parse that column.

See Also:

Example: Comma Separated Data, Example: Space Separated Data

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

static interface FlatFile.Parser
Defines a method that parses a String into an Object.
- Nested classes/interfaces inherited from class com.imsl.io.AbstractFlatFile
  AbstractFlatFile.FlatFileSQLException, AbstractFlatFile.FlatFileSQLFeatureNotSupportedException

Nested Classes
Modifier and Type	Class and Description
`static interface`	`FlatFile.Parser` Defines a method that parses a `String` into an `Object`.

Field Summary

Fields
Modifier and Type	Field and Description
`static FlatFile.Parser`	`PARSE_BYTE` Implements a `Parser` that converts a `String` to a `Byte`.
`static FlatFile.Parser`	`PARSE_DOUBLE` Implements a `Parser` that converts a `String` to a `Double`.
`static FlatFile.Parser`	`PARSE_FLOAT` Implements a `Parser` that converts a `String` to a `Float`.
`static FlatFile.Parser`	`PARSE_INTEGER` Implements a `Parser` that converts a `String` to an `Integer`.
`static FlatFile.Parser`	`PARSE_LONG` Implements a `Parser` that converts a `String` to a `Long`.
`static FlatFile.Parser`	`PARSE_SHORT` Implements a `Parser` that converts a `String` to a `Short`.

Fields inherited from interface java.sql.ResultSet
CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Constructor Summary

Constructors
Constructor and Description
`FlatFile(BufferedReader reader)` Creates a `FlatFile` with the CSV tokenizer.
`FlatFile(BufferedReader reader, Tokenizer tokenizer)` Creates a FlatFile from a BufferedReader.
`FlatFile(String filename)` Creates a FlatFile from a CSV file.
`FlatFile(String filename, Tokenizer tokenizer)` Creates a `FlatFile` from a file.

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`protected byte[]`	`doGetBytes(int columnIndex)` Gets the value of the designated column in the current row as a `byte` array.
`protected boolean`	`doNext()` Moves the cursor down one row from its current position.
`int`	`getColumnCount()` Returns the number of columns in this `ResultSet` object.
`int`	`getHoldability()` Retrieves the holdability of this `ResultSet` object.
`Reader`	`getNCharacterStream(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
`Reader`	`getNCharacterStream(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
`NClob`	`getNClob(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `NClob` object in the Java programming language.
`NClob`	`getNClob(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `NClob` object in the Java programming language.
`String`	`getNString(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`String`	`getNString(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`Object`	`getObject(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`RowId`	`getRowId(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.RowId` object in the Java programming language.
`RowId`	`getRowId(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.RowId` object in the Java programming language.
`SQLXML`	`getSQLXML(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` as a `java.sql.SQLXML` object in the Java programming language.
`SQLXML`	`getSQLXML(String columnLabel)` Retrieves the value of the designated column in the current row of this `ResultSet` as a `java.sql.SQLXML` object in the Java programming language.
`boolean`	`isClosed()` Retrieves whether this `ResultSet` object has been closed.
`boolean`	`isWrapperFor(Class<?> iface)` Returns `true` if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.
`protected String`	`readLine()` Reads and returns a line from the input.
`protected void`	`setColumnClass(int columnIndex, Class columnClass)` Sets a column class.
`protected void`	`setColumnParser(int columnIndex, FlatFile.Parser columnParser)` Sets the Parser for the specified column.
`protected void`	`setDateColumnParser(int columnIndex, String pattern, Locale locale)` Creates for a pattern string and sets the Parser for the specified column.
`<T> T`	`unwrap(Class<T> iface)` Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
`void`	`updateAsciiStream(int columnIndex, InputStream x)` Updates the designated column with an ASCII stream value.
`void`	`updateAsciiStream(int columnIndex, InputStream x, int length)` Updates the designated column with an ASCII stream value, which is the specified number of bytes.
`void`	`updateAsciiStream(int columnIndex, InputStream x, long length)` Updates the designated column with an ASCII stream value, which is the specified number of bytes.
`void`	`updateAsciiStream(String columnLabel, InputStream x)` Updates the designated column with an ASCII stream value.
`void`	`updateAsciiStream(String columnLabel, InputStream x, int length)` Updates the designated column with an ASCII stream value, which is the specified number of bytes.
`void`	`updateAsciiStream(String columnLabel, InputStream x, long length)` Updates the designated column with an ASCII stream value, which is the specified number of bytes.
`void`	`updateBinaryStream(int columnIndex, InputStream x)` Updates the designated column with a binary stream value.
`void`	`updateBinaryStream(int columnIndex, InputStream x, int length)` Updates the designated column with a binary stream value, which is the specified number of bytes.
`void`	`updateBinaryStream(int columnIndex, InputStream x, long length)` Updates the designated column with a binary stream value, which is the specified number of bytes.
`void`	`updateBinaryStream(String columnLabel, InputStream x)` Updates the designated column with a binary stream value.
`void`	`updateBinaryStream(String columnLabel, InputStream x, int length)` Updates the designated column with a binary stream value.
`void`	`updateBinaryStream(String columnLabel, InputStream x, long length)` Updates the designated column with a binary stream value.
`void`	`updateBlob(int columnIndex, Blob x)` Updates the designated column with a `java.sql.Blob` value.
`void`	`updateBlob(int columnIndex, InputStream inputStream)` Updates the designated column using the given input stream.
`void`	`updateBlob(int columnIndex, InputStream inputStream, long length)` Updates the designated column using the given input stream, which is the specified number of bytes.
`void`	`updateBlob(String columnLabel, Blob x)` Updates the designated column with a `java.sql.Blob` value.
`void`	`updateBlob(String columnLabel, InputStream inputStream)` Updates the designated column using the given input stream.
`void`	`updateBlob(String columnLabel, InputStream inputStream, long length)` Updates the designated column using the given input stream, which is the specified number of bytes.
`void`	`updateCharacterStream(int columnIndex, Reader x)` Updates the designated column with a character stream value.
`void`	`updateCharacterStream(int columnIndex, Reader x, int length)` Updates the designated column with a character stream value, which is the specified number of bytes.
`void`	`updateCharacterStream(int columnIndex, Reader x, long length)` Updates the designated column with a character stream value, which is the specified number of bytes.
`void`	`updateCharacterStream(String columnLabel, Reader reader)` Updates the designated column with a character stream value.
`void`	`updateCharacterStream(String columnLabel, Reader reader, int length)` Updates the designated column with a character stream value, which is the specified number of bytes.
`void`	`updateCharacterStream(String columnLabel, Reader reader, long length)` Updates the designated column with a character stream value, which is the specified number of bytes.
`void`	`updateClob(int columnIndex, Clob x)` Updates the designated column with a `java.sql.Clob` value.
`void`	`updateClob(int columnIndex, Reader reader)` Updates the designated column using the given `Reader` object.
`void`	`updateClob(int columnIndex, Reader reader, long length)` Updates the designated column using the given `Reader` object, which is the given number of characters long.
`void`	`updateClob(String columnLabel, Clob x)` Updates the designated column with a `java.sql.Clob` value.
`void`	`updateClob(String columnLabel, Reader reader)` Updates the designated column using the given `Reader` object.
`void`	`updateClob(String columnLabel, Reader reader, long length)` Updates the designated column using the given `Reader` object, which is the given number of characters long.
`void`	`updateNCharacterStream(int columnIndex, Reader x)` Updates the designated column with a character stream value.
`void`	`updateNCharacterStream(int columnIndex, Reader x, long length)` Updates the designated column with a character stream value, which is the specified number of bytes.
`void`	`updateNCharacterStream(String columnLabel, Reader reader)` Updates the designated column with a character stream value.
`void`	`updateNCharacterStream(String columnLabel, Reader reader, long length)` Updates the designated column with a character stream value, which is the specified number of bytes.
`void`	`updateNClob(int columnIndex, NClob nClob)` Updates the designated column with a `java.sql.NClob` value.
`void`	`updateNClob(int columnIndex, Reader reader)` Updates the designated column using the given `Reader`.
`void`	`updateNClob(int columnIndex, Reader reader, long length)` Updates the designated column using the given `Reader` object, which is the given number of characters long.
`void`	`updateNClob(String columnLabel, NClob nClob)` Updates the designated column with a `java.sql.NClob` value.
`void`	`updateNClob(String columnLabel, Reader reader)` Updates the designated column using the given `Reader` object.
`void`	`updateNClob(String columnLabel, Reader reader, long length)` Updates the designated column using the given `Reader` object, which is the given number of characters long.
`void`	`updateNString(int columnIndex, String nString)` Updates the designated column with a `String` value.
`void`	`updateNString(String columnLabel, String nString)` Updates the designated column with a String value.
`void`	`updateRowId(int columnIndex, RowId x)` Updates the designated column with a `RowId` value.
`void`	`updateRowId(String columnLabel, RowId x)` Updates the designated column with a `RowId` value.
`void`	`updateSQLXML(int columnIndex, SQLXML xmlObject)` Updates the designated column with a `java.sql.SQLXML` value.
`void`	`updateSQLXML(String columnLabel, SQLXML xmlObject)` Updates the designated column with a `java.sql.SQLXML` value.

Methods inherited from class com.imsl.io.AbstractFlatFile
absolute, afterLast, beforeFirst, beginGet, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, findColumnName, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getColumnClass, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getInt, getInt, getLong, getLong, getMetaData, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getShort, getShort, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setColumnName, setFetchDirection, setFetchSize, setWarning, updateArray, updateArray, updateBigDecimal, updateBigDecimal, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateShort, updateShort, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.ResultSet
updateObject, updateObject, updateObject, updateObject

- Field Detail
  - PARSE_BYTE
```
public static final FlatFile.Parser PARSE_BYTE
```
    Implements a Parser that converts a String to a Byte.
    
    See Also:
    
    Byte.valueOf(String)
  - PARSE_SHORT
```
public static final FlatFile.Parser PARSE_SHORT
```
    Implements a Parser that converts a String to a Short.
    
    See Also:
    
    Short.valueOf(String)
  - PARSE_INTEGER
```
public static final FlatFile.Parser PARSE_INTEGER
```
    Implements a Parser that converts a String to an Integer.
    
    See Also:
    
    Integer.valueOf(String)
  - PARSE_LONG
```
public static final FlatFile.Parser PARSE_LONG
```
    Implements a Parser that converts a String to a Long.
    
    See Also:
    
    Long.valueOf(String)
  - PARSE_FLOAT
```
public static final FlatFile.Parser PARSE_FLOAT
```
    Implements a Parser that converts a String to a Float.
    
    See Also:
    
    Float.valueOf(String)
  - PARSE_DOUBLE
```
public static final FlatFile.Parser PARSE_DOUBLE
```
    Implements a Parser that converts a String to a Double.
    
    See Also:
    
    Double.valueOf(String)
- Constructor Detail
  - FlatFile
```
public FlatFile(BufferedReader reader,
                Tokenizer tokenizer)
```
    Creates a FlatFile from a BufferedReader.
    
    Parameters:
    
    reader - a BufferedReader that is the stream to be read
    
    tokenizer - a Tokenizer that splits a text line into tokens, one per column
  - FlatFile
```
public FlatFile(BufferedReader reader)
         throws IOException
```
    Creates a FlatFile with the CSV tokenizer.
    The CSV tokenizer is for reading comma separated value files.
    
    Parameters:
    
    reader - a BufferedReader that is the stream to be read
    
    Throws:
    
    IOException
  - FlatFile
```
public FlatFile(String filename)
         throws IOException
```
    Creates a FlatFile from a CSV file.
    A CSV file is a comma separated value file.
    
    Parameters:
    
    filename - a String that specifies the name of the file to be read
    
    Throws:
    
    IOException
  - FlatFile
```
public FlatFile(String filename,
                Tokenizer tokenizer)
         throws IOException
```
    Creates a FlatFile from a file.
    
    Parameters:
    
    filename - a String that specifies the name of the file to be read
    
    tokenizer - a Tokenizer that splits a text line into tokens, one per column
    
    Throws:
    
    IOException
- Method Detail
  - isWrapperFor
```
public boolean isWrapperFor(Class<?> iface)
                     throws SQLException
```
    Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does. Returns false otherwise. If this implements the interface then return true, else if this is a wrapper then return the result of recursively calling isWrapperFor on the wrapped object. If this does not implement the interface and is not a wrapper, return false. This method should be implemented as a low-cost operation compared to unwrap so that callers can use this method to avoid expensive unwrap calls that may fail. If this method returns true then calling unwrap with the same argument should succeed.
    
    Parameters:
    
    iface - a Class defining an interface
    
    Returns:
    
    a boolean, false
    
    Throws:
    
    SQLException - if an error occurs while determining whether this is a wrapper for an object with the given interface
  - unwrap
```
public <T> T unwrap(Class<T> iface)
             throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy. If the receiver implements the interface then the result is the receiver or a proxy for the receiver. If the receiver is a wrapper and the wrapped object implements the interface then the result is the wrapped object or a proxy for the wrapped object. Otherwise returns the result of calling unwrap recursively on the wrapped object or a proxy for that result. If the receiver is not a wrapper and does not implement the interface, then an SQLException is thrown.
    
    Type Parameters:
    
    T - the argument type to be unwrapped
    
    Parameters:
    
    iface - a Class defining an interface that the result must implement
    
    Returns:
    
    an object that implements the interface. The object may be a proxy for the actual implementing object.
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateRowId
```
public void updateRowId(int columnIndex,
                        RowId x)
                 throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a RowId value.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a RowId that specifies the column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateRowId
```
public void updateRowId(String columnLabel,
                        RowId x)
                 throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a RowId value.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    x - a RowId that specifies the column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - getRowId
```
public RowId getRowId(int columnIndex)
               throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    Returns:
    
    a RowId that is the column value. If the value is a SQL NULL the value returned is null.
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - getRowId
```
public RowId getRowId(String columnLabel)
               throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.RowId object in the Java programming language.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    Returns:
    
    a RowId that is the column value. If the value is a SQL NULL the value returned is null.
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - getHoldability
```
public int getHoldability()
                   throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Retrieves the holdability of this ResultSet object.
    
    Returns:
    
    an int that is either ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - isClosed
```
public boolean isClosed()
                 throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Retrieves whether this ResultSet object has been closed. A ResultSet is closed if the method close has been called on it, or if it is automatically closed.
    
    Returns:
    
    a boolean, true if this ResultSet object is closed, false if it is still open
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateSQLXML
```
public void updateSQLXML(int columnIndex,
                         SQLXML xmlObject)
                  throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a java.sql.SQLXML value.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    xmlObject - a SQLXML object that specifies the value for the column to be updated
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - getSQLXML
```
public SQLXML getSQLXML(int columnIndex)
                 throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    Returns:
    
    an SQLXML object that maps an SQL XML value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - getSQLXML
```
public SQLXML getSQLXML(String columnLabel)
                 throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Retrieves the value of the designated column in the current row of this ResultSet as a java.sql.SQLXML object in the Java programming language.
    
    Parameters:
    
    columnLabel - an String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    Returns:
    
    an SQLXML object that maps an SQL XML value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - getNClob
```
public NClob getNClob(int columnIndex)
               throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    Returns:
    
    an NClob object representing the SQL NCLOB value in the specified column
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - getNString
```
public String getNString(int columnIndex)
                  throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. It is intended for use when accessing NCHAR, NVARCHAR and LONGNVARCHAR columns.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    Returns:
    
    a String that specifies the column value. If the value is SQL NULL, the value returned is null.
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - getNString
```
public String getNString(String columnLabel)
                  throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language. It is intended for use when accessing NCHAR, NVARCHAR and LONGNVARCHAR columns.
    
    Parameters:
    
    columnLabel - an String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    Returns:
    
    a String that specifies the column value. If the value is SQL NULL, the value returned is null.
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - getNClob
```
public NClob getNClob(String columnLabel)
               throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a NClob object in the Java programming language.
    
    Parameters:
    
    columnLabel - an String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    Returns:
    
    an NClob object representing the SQL NCLOB value in the specified column
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateSQLXML
```
public void updateSQLXML(String columnLabel,
                         SQLXML xmlObject)
                  throws SQLFeatureNotSupportedException
```
    Updates the designated column with a java.sql.SQLXML value.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    xmlObject - a SQLXML object the specifies the column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    SQLFeatureNotSupportedException
  - getNCharacterStream
```
public Reader getNCharacterStream(int columnIndex)
                           throws SQLFeatureNotSupportedException
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. It is intended for use when accessing NCHAR, NVARCHAR and LONGNVARCHAR columns.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    Returns:
    
    a java.io.Reader object that contains the column value. If the value is SQL NULL, the value returned is null in the Java programming language.
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    SQLFeatureNotSupportedException
  - updateNString
```
public void updateNString(int columnIndex,
                          String nString)
                   throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a String value. It is intended for use when updating, NCHAR, NVARCHAR and LONGNVARCHAR columns.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    nString - a String that specifies the value for the column to be updated
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateNString
```
public void updateNString(String columnLabel,
                          String nString)
                   throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a String value. It is intended for use when updating NCHAR, NVARCHAR and LONGNVARCHAR columns.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    nString - a String that specifies the value for the column to be updated
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - getNCharacterStream
```
public Reader getNCharacterStream(String columnLabel)
                           throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object. It is intended for use when accessing NCHAR, NVARCHAR and LONGNVARCHAR columns.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    Returns:
    
    a java.io.Reader object that contains the column value. If the value is SQL NULL, the value returned is null in the Java programming language.
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateAsciiStream
```
public void updateAsciiStream(int columnIndex,
                              InputStream x)
                       throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with an ASCII stream value. The data will be read from the stream as needed until end-of-stream is reached.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a InputStream that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateAsciiStream
```
public void updateAsciiStream(int columnIndex,
                              InputStream x,
                              int length)
                       throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with an ASCII stream value, which is the specified number of bytes.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateAsciiStream in interface ResultSet
    
    Overrides:
    
    updateAsciiStream in class AbstractFlatFile
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a InputStream that specifies the new column value
    
    length - an int that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateAsciiStream
```
public void updateAsciiStream(int columnIndex,
                              InputStream x,
                              long length)
                       throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with an ASCII stream value, which is the specified number of bytes.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a InputStream that specifies the new column value
    
    length - an long that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateAsciiStream
```
public void updateAsciiStream(String columnLabel,
                              InputStream x)
                       throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with an ASCII stream value. The data will be read from the stream as needed until end-of-stream is reached.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    x - a InputStream that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateAsciiStream
```
public void updateAsciiStream(String columnLabel,
                              InputStream x,
                              int length)
                       throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with an ASCII stream value, which is the specified number of bytes.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateAsciiStream in interface ResultSet
    
    Overrides:
    
    updateAsciiStream in class AbstractFlatFile
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    x - a InputStream that specifies the new column value
    
    length - an int that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateAsciiStream
```
public void updateAsciiStream(String columnLabel,
                              InputStream x,
                              long length)
                       throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with an ASCII stream value, which is the specified number of bytes.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    x - a InputStream that specifies the new column value
    
    length - an long that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateBinaryStream
```
public void updateBinaryStream(int columnIndex,
                               InputStream x)
                        throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a binary stream value. The data will be read from the stream as needed until end-of-stream is reached.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a InputStream that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateBinaryStream
```
public void updateBinaryStream(int columnIndex,
                               InputStream x,
                               int length)
                        throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a binary stream value, which is the specified number of bytes.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateBinaryStream in interface ResultSet
    
    Overrides:
    
    updateBinaryStream in class AbstractFlatFile
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a InputStream that specifies the new column value
    
    length - an int that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateBinaryStream
```
public void updateBinaryStream(int columnIndex,
                               InputStream x,
                               long length)
                        throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a binary stream value, which is the specified number of bytes.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a InputStream that specifies the new column value
    
    length - an long that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateBinaryStream
```
public void updateBinaryStream(String columnLabel,
                               InputStream x)
                        throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a binary stream value. The data will be read from the stream as needed until end-of-stream is reached.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    x - a InputStream that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateBinaryStream
```
public void updateBinaryStream(String columnLabel,
                               InputStream x,
                               int length)
                        throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a binary stream value. The data will be read from the stream as needed until end-of-stream is reached.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateBinaryStream in interface ResultSet
    
    Overrides:
    
    updateBinaryStream in class AbstractFlatFile
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    x - a InputStream that specifies the new column value
    
    length - an int that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateBinaryStream
```
public void updateBinaryStream(String columnLabel,
                               InputStream x,
                               long length)
                        throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a binary stream value. The data will be read from the stream as needed until end-of-stream is reached.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    x - a InputStream that specifies the new column value
    
    length - an long that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateBlob
```
public void updateBlob(int columnIndex,
                       Blob x)
                throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a java.sql.Blob value.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateBlob in interface ResultSet
    
    Overrides:
    
    updateBlob in class AbstractFlatFile
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a Blob that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateBlob
```
public void updateBlob(int columnIndex,
                       InputStream inputStream)
                throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column using the given input stream. The data will be read from the stream as needed until end-of-stream is reached.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    inputStream - an InputStream that contains the data to set the parameter value to
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateBlob
```
public void updateBlob(int columnIndex,
                       InputStream inputStream,
                       long length)
                throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column using the given input stream, which is the specified number of bytes.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    inputStream - an InputStream that contains the data to set the parameter value to
    
    length - an long that specifies the number of bytes in the parameter data
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateBlob
```
public void updateBlob(String columnLabel,
                       Blob x)
                throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a java.sql.Blob value.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateBlob in interface ResultSet
    
    Overrides:
    
    updateBlob in class AbstractFlatFile
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    x - a Blob that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateBlob
```
public void updateBlob(String columnLabel,
                       InputStream inputStream)
                throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column using the given input stream. The data will be read from the stream as needed until end-of-stream is reached.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    inputStream - an InputStream that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateBlob
```
public void updateBlob(String columnLabel,
                       InputStream inputStream,
                       long length)
                throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column using the given input stream, which is the specified number of bytes.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    inputStream - an InputStream that specifies the new column value
    
    length - an long that specifies the number of bytes in the parameter data
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateCharacterStream
```
public void updateCharacterStream(int columnIndex,
                                  Reader x)
                           throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a character stream value. The data is read from the stream as needed until end-of-stream is reached.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a Reader that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateCharacterStream
```
public void updateCharacterStream(int columnIndex,
                                  Reader x,
                                  int length)
                           throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a character stream value, which is the specified number of bytes.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateCharacterStream in interface ResultSet
    
    Overrides:
    
    updateCharacterStream in class AbstractFlatFile
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a Reader that specifies the new column value
    
    length - an int that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateCharacterStream
```
public void updateCharacterStream(int columnIndex,
                                  Reader x,
                                  long length)
                           throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a character stream value, which is the specified number of bytes.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a Reader that specifies the new column value
    
    length - an long that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateCharacterStream
```
public void updateCharacterStream(String columnLabel,
                                  Reader reader)
                           throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a character stream value. The data is read from the stream as needed until end-of-stream is reached.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    reader - a Reader that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateCharacterStream
```
public void updateCharacterStream(String columnLabel,
                                  Reader reader,
                                  int length)
                           throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a character stream value, which is the specified number of bytes.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateCharacterStream in interface ResultSet
    
    Overrides:
    
    updateCharacterStream in class AbstractFlatFile
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    reader - a Reader that specifies the new column value
    
    length - an int that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateCharacterStream
```
public void updateCharacterStream(String columnLabel,
                                  Reader reader,
                                  long length)
                           throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a character stream value, which is the specified number of bytes.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    reader - a Reader that specifies the new column value
    
    length - an long that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateClob
```
public void updateClob(int columnIndex,
                       Clob x)
                throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a java.sql.Clob value.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateClob in interface ResultSet
    
    Overrides:
    
    updateClob in class AbstractFlatFile
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a Clob that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateClob
```
public void updateClob(int columnIndex,
                       Reader reader)
                throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column using the given Reader object. The data is read from the stream as needed until end-of-stream is reached. The JDBC driver does any necessary conversion from UNICODE to the database char format.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    reader - a Reader that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateClob
```
public void updateClob(int columnIndex,
                       Reader reader,
                       long length)
                throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column using the given Reader object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The JDBC driver does any necessary conversion from UNICODE to the database char format.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    reader - a Reader that specifies the new column value
    
    length - a long that specifies the number of characters in the parameter data
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateClob
```
public void updateClob(String columnLabel,
                       Clob x)
                throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a java.sql.Clob value.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Specified by:
    
    updateClob in interface ResultSet
    
    Overrides:
    
    updateClob in class AbstractFlatFile
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    x - a Clob that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateClob
```
public void updateClob(String columnLabel,
                       Reader reader)
                throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column using the given Reader object. The data is read from the stream as needed until end-of-stream is reached. The JDBC driver does any necessary conversion from UNICODE to the database char format.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    reader - a Reader that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateClob
```
public void updateClob(String columnLabel,
                       Reader reader,
                       long length)
                throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column using the given Reader object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The JDBC driver does any necessary conversion from UNICODE to the database char format.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    reader - a Reader that specifies the new column value
    
    length - a long that specifies the number of characters in the parameter data
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateNCharacterStream
```
public void updateNCharacterStream(int columnIndex,
                                   Reader x)
                            throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a character stream value. The data is read from the stream as needed until end-of-stream is reached. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updating NCHAR, NVARCHAR and LONGNVARCHAR columns.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a Reader that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateNCharacterStream
```
public void updateNCharacterStream(int columnIndex,
                                   Reader x,
                                   long length)
                            throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a character stream value, which is the specified number of bytes. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updating NCHAR, NVARCHAR and LONGNVARCHAR columns.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    x - a Reader that specifies the new column value
    
    length - a long that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateNCharacterStream
```
public void updateNCharacterStream(String columnLabel,
                                   Reader reader)
                            throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a character stream value. The data is read from the stream as needed until end-of-stream is reached. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updating NCHAR, NVARCHAR and LONGNVARCHAR columns.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    reader - a Reader that specifies the new column value
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateNCharacterStream
```
public void updateNCharacterStream(String columnLabel,
                                   Reader reader,
                                   long length)
                            throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a character stream value, which is the specified number of bytes. The driver does the necessary conversion from Java character format to the national character set in the database. It is intended for use when updating NCHAR, NVARCHAR and LONGNVARCHAR columns.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    reader - a Reader that specifies the new column value
    
    length - a long that specifies the length of the stream
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateNClob
```
public void updateNClob(int columnIndex,
                        NClob nClob)
                 throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a java.sql.NClob value.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    nClob - an NClob that specifies the value for the column to be updated
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateNClob
```
public void updateNClob(int columnIndex,
                        Reader reader)
                 throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column using the given Reader. The data is read from the stream as needed until end-of-stream is reached. The JDBC driver does any necessary conversion from UNICODE to the database char format.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    reader - a Reader that contains the data to set the parameter value to
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateNClob
```
public void updateNClob(int columnIndex,
                        Reader reader,
                        long length)
                 throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column using the given Reader object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The JDBC driver does any necessary conversion from UNICODE to the database char format.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    reader - a Reader that contains the data to set the parameter value to
    
    length - a long that specifies the number of characters in the parameter data
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateNClob
```
public void updateNClob(String columnLabel,
                        NClob nClob)
                 throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column with a java.sql.NClob value.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    nClob - a NClob that specifies the value for the column to be updated
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateNClob
```
public void updateNClob(String columnLabel,
                        Reader reader)
                 throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column using the given Reader object. The data is read from the stream as needed until end-of-stream is reached. The JDBC driver does any necessary conversion from UNICODE to the database char format.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    reader - a Reader that contains the data to set the parameter value to
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - updateNClob
```
public void updateNClob(String columnLabel,
                        Reader reader,
                        long length)
                 throws AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
```
    Updates the designated column using the given Reader object, which is the given number of characters long. When a very large UNICODE value is input to a LONGVARCHAR parameter, it may be more practical to send it via a java.io.Reader object. The JDBC driver does any necessary conversion from UNICODE to the database char format.
    The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database. Instead the updateRow or insertRow methods are called to update the database.
    
    Parameters:
    
    columnLabel - a String that indicates the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
    
    reader - a Reader that contains the data to set the parameter value to
    
    length - a long that specifies the number of characters in the parameter data
    
    Throws:
    
    FlatFileSQLFeatureNotSupportedException - this feature has not been implemented
    
    AbstractFlatFile.FlatFileSQLFeatureNotSupportedException
  - getObject
```
public Object getObject(int columnIndex)
                 throws SQLException
```
    Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.
    This method returns the value of the given column as a Java object. The type of the Java object is the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification.
    This method may also be used to read datatabase-specific abstract data types. In the JDBC 2.0 API, the behavior of method getObject is extended to materialize data of SQL user-defined types. When a column contains a structured or distinct value, the behavior of this method is as if it were a call to: getObject(columnIndex, this.getStatement().getConnection().getTypeMap()).
    
    Specified by:
    
    getObject in interface ResultSet
    
    Specified by:
    
    getObject in class AbstractFlatFile
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    Returns:
    
    a java.lang.Object holding the column value
    
    Throws:
    
    SQLException - if a database access error occurs
  - readLine
```
protected String readLine()
                   throws IOException
```
    Reads and returns a line from the input.
    
    Returns:
    
    a String that contains a line from the input
    
    Throws:
    
    IOException - thrown if an IO exception occurs
  - setColumnClass
```
protected void setColumnClass(int columnIndex,
                              Class columnClass)
```
    Sets a column class.
    
    Overrides:
    
    setColumnClass in class AbstractFlatFile
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    columnClass - a Class object used to specify the class of the data in the column
  - setColumnParser
```
protected void setColumnParser(int columnIndex,
                               FlatFile.Parser columnParser)
```
    Sets the Parser for the specified column.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    columnParser - a Parser that is the parser to be used to parse entries in the specified column
  - setDateColumnParser
```
protected void setDateColumnParser(int columnIndex,
                                   String pattern,
                                   Locale locale)
```
    Creates for a pattern string and sets the Parser for the specified column.
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    pattern - a String that specifies a pattern used to construct a java.text.SimpleDateFormat object used to parse the column
    
    locale - a Locale that specifies the locale for the date format parser
  - doNext
```
protected boolean doNext()
                  throws SQLException
```
    Moves the cursor down one row from its current position. A ResultSet cursor is initially positioned before the first row, the first call to the method next makes the first row the current row, the second call makes the second row the current row, and so on.
    
    Specified by:
    
    doNext in class AbstractFlatFile
    
    Returns:
    
    a boolean, true if the new current row is valid, false if there are no more rows
    
    Throws:
    
    SQLException - if a database access error occurs
  - doGetBytes
```
protected byte[] doGetBytes(int columnIndex)
                     throws SQLException
```
    Gets the value of the designated column in the current row as a byte array.
    
    Specified by:
    
    doGetBytes in class AbstractFlatFile
    
    Parameters:
    
    columnIndex - an int that specifies the column. The first column is 1, the second 2, and so on.
    
    Returns:
    
    a byte array that contains the column value. If the value is SQL NULL, the value returned is null.
    
    Throws:
    
    SQLException - if a database access error occurs
  - getColumnCount
```
public int getColumnCount()
                   throws SQLException
```
    Returns the number of columns in this ResultSet object.
    
    Specified by:
    
    getColumnCount in class AbstractFlatFile
    
    Returns:
    
    an int that specifies the number of columns
    
    Throws:
    
    SQLException - if a database access error occurs

Class FlatFile

Nested Class Summary

Nested classes/interfaces inherited from class com.imsl.io.AbstractFlatFile

Field Summary

Fields inherited from interface java.sql.ResultSet

Constructor Summary

Method Summary

Methods inherited from class com.imsl.io.AbstractFlatFile

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.ResultSet

Field Detail

PARSE_BYTE

PARSE_SHORT

PARSE_INTEGER

PARSE_LONG

PARSE_FLOAT

PARSE_DOUBLE

Constructor Detail

FlatFile

FlatFile

FlatFile

FlatFile

Method Detail

isWrapperFor

unwrap

updateRowId

updateRowId

getRowId

getRowId

getHoldability

isClosed

updateSQLXML

getSQLXML

getSQLXML

getNClob

getNString

getNString

getNClob

updateSQLXML

getNCharacterStream

updateNString

updateNString

getNCharacterStream

updateAsciiStream

updateAsciiStream

updateAsciiStream

updateAsciiStream

updateAsciiStream

updateAsciiStream

updateBinaryStream

updateBinaryStream

updateBinaryStream

updateBinaryStream

updateBinaryStream

updateBinaryStream

updateBlob

updateBlob

updateBlob

updateBlob

updateBlob

updateBlob

updateCharacterStream

updateCharacterStream

updateCharacterStream

updateCharacterStream

updateCharacterStream

updateCharacterStream

updateClob

updateClob

updateClob

updateClob

updateClob

updateClob

updateNCharacterStream

updateNCharacterStream

updateNCharacterStream

updateNCharacterStream

updateNClob

updateNClob

updateNClob