org.apache.derby.iapi.types
Interface DataValueFactory

All Known Implementing Classes:
DataValueFactoryImpl

public interface DataValueFactory

This interface is how we get constant data values of different types.


Method Summary
 BitDataValue getBitDataValue(byte[] value)
          Get a SQL bit with the given value.
 BitDataValue getBitDataValue(byte[] value, BitDataValue previous)
           
 BitDataValue getBlobDataValue(byte[] value)
          Get a SQL Blob with the given value.
 BitDataValue getBlobDataValue(byte[] value, BitDataValue previous)
           
 StringDataValue getCharDataValue(java.lang.String value)
          Get a SQL char with the given value.
 StringDataValue getCharDataValue(java.lang.String value, StringDataValue previous)
           
 StringDataValue getClobDataValue(java.lang.String value)
          Get a SQL Clob with the given value.
 StringDataValue getClobDataValue(java.lang.String value, StringDataValue previous)
           
 BooleanDataValue getDataValue(boolean value)
          Get a SQL boolean with the given value.
 BooleanDataValue getDataValue(java.lang.Boolean value)
          Get a SQL boolean with the given value.
 BooleanDataValue getDataValue(boolean value, BooleanDataValue previous)
           
 BooleanDataValue getDataValue(java.lang.Boolean value, BooleanDataValue previous)
           
 BooleanDataValue getDataValue(BooleanDataValue value)
          Get a SQL boolean with the given value.
 NumberDataValue getDataValue(byte value)
          Get a SQL TINYINT with the given value.
 NumberDataValue getDataValue(java.lang.Byte value)
          Get a SQL TINYINT with the given value.
 NumberDataValue getDataValue(byte value, NumberDataValue previous)
           
 NumberDataValue getDataValue(java.lang.Byte value, NumberDataValue previous)
           
 NumberDataValue getDataValue(char value)
          Get a SQL int with a char value.
 NumberDataValue getDataValue(char value, NumberDataValue previous)
           
 DateTimeDataValue getDataValue(java.sql.Date value)
          Get a SQL date with the given value.
 DateTimeDataValue getDataValue(java.sql.Date value, DateTimeDataValue previous)
           
 NumberDataValue getDataValue(double value)
          Get a SQL double precision with the given value.
 NumberDataValue getDataValue(java.lang.Double value)
          Get a SQL double precision with the given value.
 NumberDataValue getDataValue(double value, NumberDataValue previous)
           
 NumberDataValue getDataValue(java.lang.Double value, NumberDataValue previous)
           
 NumberDataValue getDataValue(float value)
          Get a SQL real with the given value.
 NumberDataValue getDataValue(java.lang.Float value)
          Get a SQL real with the given value.
 NumberDataValue getDataValue(float value, NumberDataValue previous)
           
 NumberDataValue getDataValue(java.lang.Float value, NumberDataValue previous)
           
 NumberDataValue getDataValue(int value)
          Get a SQL int with the given value.
 NumberDataValue getDataValue(java.lang.Integer value)
          Get a SQL int with the given value.
 NumberDataValue getDataValue(java.lang.Integer value, NumberDataValue previous)
           
 NumberDataValue getDataValue(int value, NumberDataValue previous)
           
 NumberDataValue getDataValue(long value)
          Get a SQL bigint with the given value.
 NumberDataValue getDataValue(java.lang.Long value)
          Get a SQL bigint with the given value.
 NumberDataValue getDataValue(long value, NumberDataValue previous)
           
 NumberDataValue getDataValue(java.lang.Long value, NumberDataValue previous)
           
 UserDataValue getDataValue(java.lang.Object value)
          Get a User-defined data value with the given value and type name.
 UserDataValue getDataValue(java.lang.Object value, UserDataValue previous)
           
 RefDataValue getDataValue(RowLocation value)
          Get a RefDataValue with the given value.
 RefDataValue getDataValue(RowLocation value, RefDataValue previous)
           
 NumberDataValue getDataValue(short value)
          Get a SQL SMALLINT with the given value.
 NumberDataValue getDataValue(java.lang.Short value)
          Get a SQL smallint with the given value.
 NumberDataValue getDataValue(short value, NumberDataValue previous)
           
 NumberDataValue getDataValue(java.lang.Short value, NumberDataValue previous)
           
 DateTimeDataValue getDataValue(java.sql.Time value)
          Get a SQL time with the given value.
 DateTimeDataValue getDataValue(java.sql.Time value, DateTimeDataValue previous)
           
 DateTimeDataValue getDataValue(java.sql.Timestamp value)
          Get a SQL timestamp with the given value.
 DateTimeDataValue getDataValue(java.sql.Timestamp value, DateTimeDataValue previous)
           
 DateTimeDataValue getDate(DataValueDescriptor operand)
          Implements the SQL date function
 DateTimeDataValue getDateValue(java.lang.String dateStr, boolean isJdbcEscape)
           
 NumberDataValue getDecimalDataValue(java.lang.Long value, NumberDataValue previous)
          Get a SQL DECIMAL with the given value.
 NumberDataValue getDecimalDataValue(java.lang.Number value)
          Get a SQL DECIMAL with the given value.
 NumberDataValue getDecimalDataValue(java.lang.Number value, NumberDataValue previous)
           
 NumberDataValue getDecimalDataValue(java.lang.String value)
          Get a SQL DECIMAL with the given value.
 NumberDataValue getDecimalDataValue(java.lang.String value, NumberDataValue previous)
           
 BitDataValue getLongVarbitDataValue(byte[] value)
          Get a SQL Long Bit Varying with the given value.
 BitDataValue getLongVarbitDataValue(byte[] value, BitDataValue previous)
           
 StringDataValue getLongvarcharDataValue(java.lang.String value)
          Get a SQL long varchar with the given value.
 StringDataValue getLongvarcharDataValue(java.lang.String value, StringDataValue previous)
           
 StringDataValue getNationalCharDataValue(java.lang.String value)
          Get a SQL national char with the given value.
 StringDataValue getNationalCharDataValue(java.lang.String value, StringDataValue previous)
           
 StringDataValue getNationalLongvarcharDataValue(java.lang.String value)
          Get a SQL national long varchar with the given value.
 StringDataValue getNationalLongvarcharDataValue(java.lang.String value, StringDataValue previous)
           
 StringDataValue getNationalVarcharDataValue(java.lang.String value)
          Get a SQL national varchar with the given value.
 StringDataValue getNationalVarcharDataValue(java.lang.String value, StringDataValue previous)
           
 StringDataValue getNClobDataValue(java.lang.String value)
          Get a SQL national blob with the given value.
 StringDataValue getNClobDataValue(java.lang.String value, StringDataValue previous)
           
 BitDataValue getNullBit(BitDataValue dataValue)
          Get a SQL Bit with a SQL null value.
 BitDataValue getNullBlob(BitDataValue dataValue)
          Get a SQL Blob with a SQL null value.
 BooleanDataValue getNullBoolean(BooleanDataValue dataValue)
          Get a SQL boolean with a SQL null value.
 NumberDataValue getNullByte(NumberDataValue dataValue)
          Get a SQL tinyint with a SQL null value.
 StringDataValue getNullChar(StringDataValue dataValue)
          Get a SQL char with a SQL null value.
 StringDataValue getNullClob(StringDataValue dataValue)
          Get a SQL long varchar with a SQL null value.
 DateTimeDataValue getNullDate(DateTimeDataValue dataValue)
          Get a SQL date with a SQL null value.
 NumberDataValue getNullDecimal(NumberDataValue dataValue)
          Get a SQL Decimal/Numeric with a SQL null value.
 NumberDataValue getNullDouble(NumberDataValue dataValue)
          Get a SQL double with a SQL null value.
 NumberDataValue getNullFloat(NumberDataValue dataValue)
          Get a SQL float with a SQL null value.
 NumberDataValue getNullInteger(NumberDataValue dataValue)
          Get a SQL int with a SQL null value.
 NumberDataValue getNullLong(NumberDataValue dataValue)
          Get a SQL bigint with a SQL null value.
 BitDataValue getNullLongVarbit(BitDataValue dataValue)
          Get a SQL Long Bit Varying with a SQL null value.
 StringDataValue getNullLongvarchar(StringDataValue dataValue)
          Get a SQL long varchar with a SQL null value.
 StringDataValue getNullNationalChar(StringDataValue dataValue)
          Get a SQL national char with a SQL null value.
 StringDataValue getNullNationalLongvarchar(StringDataValue dataValue)
          Get a SQL national long varchar with a SQL null value.
 StringDataValue getNullNationalVarchar(StringDataValue dataValue)
          Get a SQL national varchar with a SQL null value.
 StringDataValue getNullNClob(StringDataValue dataValue)
          Get a SQL NCLOB with a SQL null value.
 UserDataValue getNullObject(UserDataValue dataValue)
          Get a User-defined data value with a SQL null value.
 RefDataValue getNullRef(RefDataValue dataValue)
          Get a RefDataValue with a SQL null value.
 NumberDataValue getNullShort(NumberDataValue dataValue)
          Get a SQL smallint with a SQL null value.
 DateTimeDataValue getNullTime(DateTimeDataValue dataValue)
          Get a SQL time with a SQL null value.
 DateTimeDataValue getNullTimestamp(DateTimeDataValue dataValue)
          Get a SQL timestamp with a SQL null value.
 BitDataValue getNullVarbit(BitDataValue dataValue)
          Get a SQL Bit Varying with a SQL null value.
 StringDataValue getNullVarchar(StringDataValue dataValue)
          Get a SQL varchar with a SQL null value.
 XMLDataValue getNullXML(XMLDataValue dataValue)
          Get an XML with a SQL null value.
 DateTimeDataValue getTimestamp(DataValueDescriptor operand)
          Implement the timestamp SQL function: construct a SQL timestamp from a string, or timestamp.
 DateTimeDataValue getTimestamp(DataValueDescriptor date, DataValueDescriptor time)
          Construct a SQL timestamp from a date and time.
 DateTimeDataValue getTimestampValue(java.lang.String timestampStr, boolean isJdbcEscape)
           
 DateTimeDataValue getTimeValue(java.lang.String timeStr, boolean isJdbcEscape)
           
 BitDataValue getVarbitDataValue(byte[] value)
          Get a SQL bit with the given value.
 BitDataValue getVarbitDataValue(byte[] value, BitDataValue previous)
           
 StringDataValue getVarcharDataValue(java.lang.String value)
          Get a SQL varchar with the given value.
 StringDataValue getVarcharDataValue(java.lang.String value, StringDataValue previous)
           
 XMLDataValue getXMLDataValue()
          Get a null XML value.
 XMLDataValue getXMLDataValue(XMLDataValue previous)
           
 

Method Detail

getDataValue

public NumberDataValue getDataValue(java.lang.Integer value)
Get a SQL int with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getDataValue

public NumberDataValue getDataValue(java.lang.Integer value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDataValue

public NumberDataValue getDataValue(char value)
Get a SQL int with a char value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getDataValue

public NumberDataValue getDataValue(char value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDataValue

public NumberDataValue getDataValue(java.lang.Short value)
Get a SQL smallint with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getDataValue

public NumberDataValue getDataValue(java.lang.Short value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDataValue

public NumberDataValue getDataValue(java.lang.Byte value)
Get a SQL TINYINT with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getDataValue

public NumberDataValue getDataValue(java.lang.Byte value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDataValue

public NumberDataValue getDataValue(java.lang.Long value)
Get a SQL bigint with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getDataValue

public NumberDataValue getDataValue(java.lang.Long value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDataValue

public NumberDataValue getDataValue(java.lang.Float value)
                             throws StandardException
Get a SQL real with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.

Throws:
StandardException

getDataValue

public NumberDataValue getDataValue(java.lang.Float value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDataValue

public NumberDataValue getDataValue(java.lang.Double value)
                             throws StandardException
Get a SQL double precision with the given value. A null argument means a SQL null value. The second form uses the previous value (if non-null) to hold the return value.

Throws:
StandardException - Thrown on error

getDataValue

public NumberDataValue getDataValue(java.lang.Double value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDataValue

public BooleanDataValue getDataValue(java.lang.Boolean value)
Get a SQL boolean with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getDataValue

public BooleanDataValue getDataValue(java.lang.Boolean value,
                                     BooleanDataValue previous)
                              throws StandardException
Throws:
StandardException

getLongVarbitDataValue

public BitDataValue getLongVarbitDataValue(byte[] value)
                                    throws StandardException
Get a SQL Long Bit Varying with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.

Throws:
StandardException - Thrown on error

getLongVarbitDataValue

public BitDataValue getLongVarbitDataValue(byte[] value,
                                           BitDataValue previous)
                                    throws StandardException
Throws:
StandardException

getBlobDataValue

public BitDataValue getBlobDataValue(byte[] value)
                              throws StandardException
Get a SQL Blob with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.

Throws:
StandardException - Thrown on error

getBlobDataValue

public BitDataValue getBlobDataValue(byte[] value,
                                     BitDataValue previous)
                              throws StandardException
Throws:
StandardException

getDataValue

public BooleanDataValue getDataValue(BooleanDataValue value)
                              throws StandardException
Get a SQL boolean with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.

Throws:
StandardException - Thrown on error

getVarcharDataValue

public StringDataValue getVarcharDataValue(java.lang.String value)
Get a SQL varchar with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getVarcharDataValue

public StringDataValue getVarcharDataValue(java.lang.String value,
                                           StringDataValue previous)
                                    throws StandardException
Throws:
StandardException

getLongvarcharDataValue

public StringDataValue getLongvarcharDataValue(java.lang.String value)
Get a SQL long varchar with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getLongvarcharDataValue

public StringDataValue getLongvarcharDataValue(java.lang.String value,
                                               StringDataValue previous)
                                        throws StandardException
Throws:
StandardException

getClobDataValue

public StringDataValue getClobDataValue(java.lang.String value)
Get a SQL Clob with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getClobDataValue

public StringDataValue getClobDataValue(java.lang.String value,
                                        StringDataValue previous)
                                 throws StandardException
Throws:
StandardException

getNationalVarcharDataValue

public StringDataValue getNationalVarcharDataValue(java.lang.String value)
Get a SQL national varchar with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getNationalVarcharDataValue

public StringDataValue getNationalVarcharDataValue(java.lang.String value,
                                                   StringDataValue previous)
                                            throws StandardException
Throws:
StandardException

getNationalLongvarcharDataValue

public StringDataValue getNationalLongvarcharDataValue(java.lang.String value)
Get a SQL national long varchar with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getNationalLongvarcharDataValue

public StringDataValue getNationalLongvarcharDataValue(java.lang.String value,
                                                       StringDataValue previous)
                                                throws StandardException
Throws:
StandardException

getNClobDataValue

public StringDataValue getNClobDataValue(java.lang.String value)
Get a SQL national blob with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getNClobDataValue

public StringDataValue getNClobDataValue(java.lang.String value,
                                         StringDataValue previous)
                                  throws StandardException
Throws:
StandardException

getDataValue

public UserDataValue getDataValue(java.lang.Object value)
Get a User-defined data value with the given value and type name. A null argument means get a SQL null value. The second form uses the previous value (if non-null) hold the return value.


getDataValue

public UserDataValue getDataValue(java.lang.Object value,
                                  UserDataValue previous)

getDataValue

public RefDataValue getDataValue(RowLocation value)
Get a RefDataValue with the given value. A null argument means get a SQL null value. The second form uses the previous value (if non-null) to hold the return value.


getDataValue

public RefDataValue getDataValue(RowLocation value,
                                 RefDataValue previous)

getDataValue

public NumberDataValue getDataValue(int value)
Get a SQL int with the given value. The second form re-uses the previous value, if non-null, as the data holder to return.


getDataValue

public NumberDataValue getDataValue(int value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDataValue

public NumberDataValue getDataValue(long value)
Get a SQL bigint with the given value. The second form re-uses the previous value, if non-null, as the data holder to return.


getDataValue

public NumberDataValue getDataValue(long value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDataValue

public NumberDataValue getDataValue(float value)
                             throws StandardException
Get a SQL real with the given value. The second form re-uses the previous value, if non-null, as the data holder to return.

Throws:
StandardException - Thrown on error

getDataValue

public NumberDataValue getDataValue(float value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDataValue

public NumberDataValue getDataValue(double value)
                             throws StandardException
Get a SQL double precision with the given value. The second form re-uses the previous value, if non-null, as the data holder to return.

Throws:
StandardException - Thrown on error

getDataValue

public NumberDataValue getDataValue(double value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDataValue

public NumberDataValue getDataValue(short value)
Get a SQL SMALLINT with the given value. The second form re-uses the previous value, if non-null, as the data holder to return.


getDataValue

public NumberDataValue getDataValue(short value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDataValue

public NumberDataValue getDataValue(byte value)
Get a SQL TINYINT with the given value. The second form re-uses the previous value, if non-null, as the data holder to return.


getDataValue

public NumberDataValue getDataValue(byte value,
                                    NumberDataValue previous)
                             throws StandardException
Throws:
StandardException

getDecimalDataValue

public NumberDataValue getDecimalDataValue(java.lang.Number value)
                                    throws StandardException
Get a SQL DECIMAL with the given value. The second form re-uses the previous value, if non-null, as the data holder to return.

Throws:
StandardException - Thrown on error

getDecimalDataValue

public NumberDataValue getDecimalDataValue(java.lang.Number value,
                                           NumberDataValue previous)
                                    throws StandardException
Throws:
StandardException

getDecimalDataValue

public NumberDataValue getDecimalDataValue(java.lang.Long value,
                                           NumberDataValue previous)
                                    throws StandardException
Get a SQL DECIMAL with the given value.

Throws:
StandardException - Thrown on error

getDecimalDataValue

public NumberDataValue getDecimalDataValue(java.lang.String value)
                                    throws StandardException
Get a SQL DECIMAL with the given value. The second form re-uses the previous value, if non-null, as the data holder to return.

Throws:
StandardException - Thrown on error

getDecimalDataValue

public NumberDataValue getDecimalDataValue(java.lang.String value,
                                           NumberDataValue previous)
                                    throws StandardException
Throws:
StandardException

getDataValue

public BooleanDataValue getDataValue(boolean value)
Get a SQL boolean with the given value. The second form re-uses the previous value, if non-null, as the data holder to return.


getDataValue

public BooleanDataValue getDataValue(boolean value,
                                     BooleanDataValue previous)
                              throws StandardException
Throws:
StandardException

getBitDataValue

public BitDataValue getBitDataValue(byte[] value)
                             throws StandardException
Get a SQL bit with the given value. The second form re-uses the previous value, if non-null, as the data holder to return.

Throws:
StandardException - Thrown on error

getBitDataValue

public BitDataValue getBitDataValue(byte[] value,
                                    BitDataValue previous)
                             throws StandardException
Throws:
StandardException

getVarbitDataValue

public BitDataValue getVarbitDataValue(byte[] value)
                                throws StandardException
Get a SQL bit with the given value. The second form re-uses the previous value, if non-null, as the data holder to return.

Throws:
StandardException - Thrown on error

getVarbitDataValue

public BitDataValue getVarbitDataValue(byte[] value,
                                       BitDataValue previous)
                                throws StandardException
Throws:
StandardException

getCharDataValue

public StringDataValue getCharDataValue(java.lang.String value)
Get a SQL char with the given value. A null argument means get a SQL null value. The second form re-uses the previous value, if non-null, as the data holder to return.


getCharDataValue

public StringDataValue getCharDataValue(java.lang.String value,
                                        StringDataValue previous)
                                 throws StandardException
Throws:
StandardException

getNationalCharDataValue

public StringDataValue getNationalCharDataValue(java.lang.String value)
Get a SQL national char with the given value. A null argument means get a SQL null value. The second form re-uses the previous value, if non-null, as the data holder to return.


getNationalCharDataValue

public StringDataValue getNationalCharDataValue(java.lang.String value,
                                                StringDataValue previous)
                                         throws StandardException
Throws:
StandardException

getDataValue

public DateTimeDataValue getDataValue(java.sql.Date value)
                               throws StandardException
Get a SQL date with the given value. A null argument means get a SQL null value. The second form re-uses the previous value, if non-null, as the data holder to return.

Throws:
StandardException

getDataValue

public DateTimeDataValue getDataValue(java.sql.Date value,
                                      DateTimeDataValue previous)
                               throws StandardException
Throws:
StandardException

getDataValue

public DateTimeDataValue getDataValue(java.sql.Time value)
                               throws StandardException
Get a SQL time with the given value. A null argument means get a SQL null value. The second form re-uses the previous value, if non-null, as the data holder to return.

Throws:
StandardException

getDataValue

public DateTimeDataValue getDataValue(java.sql.Time value,
                                      DateTimeDataValue previous)
                               throws StandardException
Throws:
StandardException

getDataValue

public DateTimeDataValue getDataValue(java.sql.Timestamp value)
                               throws StandardException
Get a SQL timestamp with the given value. A null argument means get a SQL null value. The second form re-uses the previous value, if non-null, as the data holder to return.

Throws:
StandardException

getDataValue

public DateTimeDataValue getDataValue(java.sql.Timestamp value,
                                      DateTimeDataValue previous)
                               throws StandardException
Throws:
StandardException

getTimestamp

public DateTimeDataValue getTimestamp(DataValueDescriptor operand)
                               throws StandardException
Implement the timestamp SQL function: construct a SQL timestamp from a string, or timestamp.

Parameters:
operand - Must be a timestamp or a string convertible to a timestamp.
Throws:
StandardException

getTimestamp

public DateTimeDataValue getTimestamp(DataValueDescriptor date,
                                      DataValueDescriptor time)
                               throws StandardException
Construct a SQL timestamp from a date and time.

Parameters:
date - Must be convertible to a date.
time - Must be convertible to a time.
Throws:
StandardException

getDate

public DateTimeDataValue getDate(DataValueDescriptor operand)
                          throws StandardException
Implements the SQL date function

Parameters:
operand - A date, timestamp, string or integer.
Returns:
the corresponding date value
Throws:
StandardException - if the syntax is invalid or the date is out of range.

getDateValue

public DateTimeDataValue getDateValue(java.lang.String dateStr,
                                      boolean isJdbcEscape)
                               throws StandardException
Parameters:
dateStr - A date in one of the DB2 standard date formats or the local format.
isJdbcEscape - If true then the timestamp must be in the JDBC timestamp escape format, otherwise it must be in the DB2 timestamp format.
Returns:
A DateTimeDataValue
Throws:
StandardException - if the syntax is invalid or the date is out of range.

getTimeValue

public DateTimeDataValue getTimeValue(java.lang.String timeStr,
                                      boolean isJdbcEscape)
                               throws StandardException
Parameters:
timeStr - A date in one of the DB2 standard time formats or the local format.
isJdbcEscape - If true then the timestamp must be in the JDBC time escape format, otherwise it must be in the DB2 time format.
Returns:
A DateTimeDataValue
Throws:
StandardException - if the syntax is invalid or the time is out of range.

getTimestampValue

public DateTimeDataValue getTimestampValue(java.lang.String timestampStr,
                                           boolean isJdbcEscape)
                                    throws StandardException
Parameters:
isJdbcEscape - If true then the time must be in the JDBC time escape format, otherwise it must be in the DB2 time format.
Returns:
An internal timestamp
Throws:
StandardException - if the syntax is invalid or the timestamp is out of range.

getXMLDataValue

public XMLDataValue getXMLDataValue()
Get a null XML value. The second form re-uses the previous value, if non-null, as the data holder to return.


getXMLDataValue

public XMLDataValue getXMLDataValue(XMLDataValue previous)
                             throws StandardException
Throws:
StandardException

getNullInteger

public NumberDataValue getNullInteger(NumberDataValue dataValue)
Get a SQL int with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullShort

public NumberDataValue getNullShort(NumberDataValue dataValue)
Get a SQL smallint with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullByte

public NumberDataValue getNullByte(NumberDataValue dataValue)
Get a SQL tinyint with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullLong

public NumberDataValue getNullLong(NumberDataValue dataValue)
Get a SQL bigint with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullFloat

public NumberDataValue getNullFloat(NumberDataValue dataValue)
Get a SQL float with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullDouble

public NumberDataValue getNullDouble(NumberDataValue dataValue)
Get a SQL double with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullDecimal

public NumberDataValue getNullDecimal(NumberDataValue dataValue)
Get a SQL Decimal/Numeric with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullBoolean

public BooleanDataValue getNullBoolean(BooleanDataValue dataValue)
Get a SQL boolean with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullBit

public BitDataValue getNullBit(BitDataValue dataValue)
                        throws StandardException
Get a SQL Bit with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.

Throws:
StandardException - Thrown on error

getNullVarbit

public BitDataValue getNullVarbit(BitDataValue dataValue)
                           throws StandardException
Get a SQL Bit Varying with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.

Throws:
StandardException - Thrown on error

getNullLongVarbit

public BitDataValue getNullLongVarbit(BitDataValue dataValue)
                               throws StandardException
Get a SQL Long Bit Varying with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.

Throws:
StandardException - Thrown on error

getNullBlob

public BitDataValue getNullBlob(BitDataValue dataValue)
                         throws StandardException
Get a SQL Blob with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.

Throws:
StandardException - Thrown on error

getNullChar

public StringDataValue getNullChar(StringDataValue dataValue)
Get a SQL char with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullVarchar

public StringDataValue getNullVarchar(StringDataValue dataValue)
Get a SQL varchar with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullLongvarchar

public StringDataValue getNullLongvarchar(StringDataValue dataValue)
Get a SQL long varchar with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullClob

public StringDataValue getNullClob(StringDataValue dataValue)
Get a SQL long varchar with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullNationalChar

public StringDataValue getNullNationalChar(StringDataValue dataValue)
Get a SQL national char with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullNationalVarchar

public StringDataValue getNullNationalVarchar(StringDataValue dataValue)
Get a SQL national varchar with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullNationalLongvarchar

public StringDataValue getNullNationalLongvarchar(StringDataValue dataValue)
Get a SQL national long varchar with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullNClob

public StringDataValue getNullNClob(StringDataValue dataValue)
Get a SQL NCLOB with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullObject

public UserDataValue getNullObject(UserDataValue dataValue)
Get a User-defined data value with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullRef

public RefDataValue getNullRef(RefDataValue dataValue)
Get a RefDataValue with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullDate

public DateTimeDataValue getNullDate(DateTimeDataValue dataValue)
Get a SQL date with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullTime

public DateTimeDataValue getNullTime(DateTimeDataValue dataValue)
Get a SQL time with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullTimestamp

public DateTimeDataValue getNullTimestamp(DateTimeDataValue dataValue)
Get a SQL timestamp with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


getNullXML

public XMLDataValue getNullXML(XMLDataValue dataValue)
Get an XML with a SQL null value. If the supplied value is null then get a new value, otherwise set it to null and return that value.


Built on Tue 2006-10-10 19:23:47+0200, from revision exported

Apache Derby V10.1 Engine Documentation - Copyright © 1997,2005 The Apache Software Foundation or its licensors, as applicable.