org.apache.derby.iapi.types
Interface DataValueFactory

All Known Implementing Classes:

CDCDataValueFactory, DataValueFactoryImpl, J2SEDataValueFactory

public interface DataValueFactory

This interface is how we get data values of different types. For any method that takes a 'previous' argument it is required that the caller pass in an object of the same class that would be returned by the call if null was passed for previous.

Method Summary

BitDataValue	getBitDataValue(byte[] value) Get a SQL bit with the given value.
BitDataValue	getBitDataValue(byte[] value, BitDataValue previous)
BitDataValue	getBlobDataValue(byte[] value, BitDataValue previous) Get a SQL Blob with the given value.
java.text.RuleBasedCollator	getCharacterCollator(int collationType) Return the RuleBasedCollator depending on the collation type.
StringDataValue	getCharDataValue(java.lang.String value) Get a new SQLChar object to represent a SQL CHAR (UCS_BASIC) with the given value.
StringDataValue	getCharDataValue(java.lang.String value, StringDataValue previous) Get a SQLChar object to represent a SQL CHAR (UCS_BASIC with the given value.
StringDataValue	getCharDataValue(java.lang.String value, StringDataValue previous, int collationType) Get a StringDataValue to represent a SQL CHAR with the passed in collationType.
StringDataValue	getClobDataValue(java.lang.String value, StringDataValue previous) Get a SQLClob object to represent a SQL CLOB (UCS_BASIC) with the given value.
StringDataValue	getClobDataValue(java.lang.String value, StringDataValue previous, int collationType) Get a StringDataValue to represent a SQL LONG VARCHAR with the passed in collationType.
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(java.lang.Byte value) Get a SQL TINYINT with the given value.
NumberDataValue	getDataValue(byte value, NumberDataValue previous) Get a SQL TINYINT with the given value.
NumberDataValue	getDataValue(java.lang.Byte value, NumberDataValue previous)
NumberDataValue	getDataValue(char value, NumberDataValue previous) Get a SQL int with a char value.
DateTimeDataValue	getDataValue(java.sql.Date value) Get a SQL date with the given value.
DateTimeDataValue	getDataValue(java.sql.Date value, DateTimeDataValue previous)
NumberDataValue	getDataValue(java.lang.Double value) Get a SQL double precision with the given value.
NumberDataValue	getDataValue(double value, NumberDataValue previous) Get a SQL double precision with the given value.
NumberDataValue	getDataValue(java.lang.Double value, NumberDataValue previous)
NumberDataValue	getDataValue(java.lang.Float value) Get a SQL real with the given value.
NumberDataValue	getDataValue(float value, NumberDataValue previous) Get a SQL real with the given value.
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, NumberDataValue previous) Get a SQL int with the given value.
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, RefDataValue previous) Get a RefDataValue with the given value.
NumberDataValue	getDataValue(java.lang.Short value) Get a SQL smallint with the given value.
NumberDataValue	getDataValue(short value, NumberDataValue previous) Get a SQL SMALLINT with the given value.
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, BitDataValue previous) Get a SQL Long Bit Varying with the given value.
StringDataValue	getLongvarcharDataValue(java.lang.String value) Get a SQL long varchar with the given value.
StringDataValue	getLongvarcharDataValue(java.lang.String value, StringDataValue previous) Get a SQLLongvarchar object to represent a SQL LONG VARCHAR (UCS_BASIC) with the given value.
StringDataValue	getLongvarcharDataValue(java.lang.String value, StringDataValue previous, int collationType) Get a StringDataValue to represent a SQL LONG VARCHAR with the passed in collationType.
DataValueDescriptor	getNull(int formatId, int collationType) Return an object based on the format id and collation type.
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 (UCS_BASIC) with a SQL null value.
StringDataValue	getNullChar(StringDataValue dataValue, int collationType) Get a SQL CHAR set to NULL with collation set to collationType.
StringDataValue	getNullClob(StringDataValue dataValue) Get a SQL CLOB (UCS_BASIC) with a SQL null value.
StringDataValue	getNullClob(StringDataValue dataValue, int collationType) Get a SQL CLOB set to NULL with collation set to collationType.
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 (UCS_BASIC) with a SQL null value.
StringDataValue	getNullLongvarchar(StringDataValue dataValue, int collationType) Get a SQL LONG VARCHAR set to NULL with collation set to collationType.
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 (UCS_BASIC) with a SQL null value.
StringDataValue	getNullVarchar(StringDataValue dataValue, int collationType) Get a SQL VARCHAR set to NULL with collation set to collationType.
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, BitDataValue previous) Get a SQL bit with the given value.
StringDataValue	getVarcharDataValue(java.lang.String value) Get a SQL varchar with the given value.
StringDataValue	getVarcharDataValue(java.lang.String value, StringDataValue previous) Get a SQLVarhar object to represent a SQL VARCHAR (UCS_BASIC) with the given value.
StringDataValue	getVarcharDataValue(java.lang.String value, StringDataValue previous, int collationType) Get a StringDataValue to represent a SQL VARCHAR with the passed in collationType.
XMLDataValue	getXMLDataValue(XMLDataValue previous) Get a null XML value.

Method Detail

getDataValue

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

Get a SQL int with the given value. A null argument means get a SQL null value. Uses the previous value (if non-null) to hold the return value.

Throws:

StandardException

getDataValue

NumberDataValue getDataValue(char value,
                             NumberDataValue previous)
                             throws StandardException

Get a SQL int with a char value. A null argument means get a SQL null value. Uses the previous value (if non-null) to hold the return value.

Throws:

StandardException

getDataValue

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

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

Throws:

StandardException

getDataValue

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

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

Throws:

StandardException

getDataValue

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

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

Throws:

StandardException

getDataValue

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

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

Throws:

StandardException

getDataValue

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

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

Throws:

StandardException

getDataValue

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

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

Throws:

StandardException

getLongVarbitDataValue

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

Get a SQL Long Bit Varying with the given value. A null argument means get a SQL null value. Uses the previous value (if non-null) to hold the return value.

Throws:

StandardException - Thrown on error

getBlobDataValue

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

Get a SQL Blob with the given value. A null argument means get a SQL null value. Uses the previous value (if non-null) to hold the return value.

Throws:

StandardException - Thrown on error

getDataValue

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

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

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

Get a SQLVarhar object to represent a SQL VARCHAR (UCS_BASIC) with the given value. A null argument means get a SQL NULL value. If previous is not null (Java reference) then it will be set to the value passed in and returned, otherwise a new SQLVarchar will be created and set to the value.

Throws:

StandardException

getVarcharDataValue

StringDataValue getVarcharDataValue(java.lang.String value,
                                    StringDataValue previous,
                                    int collationType)
                                    throws StandardException

Get a StringDataValue to represent a SQL VARCHAR with the passed in collationType. A null argument means get a SQL NULL value. If previous is not null (Java reference) then it will be set to the value passed in and returned, otherwise a new StringDataValue will be created and set to the value. If collationType is equal to StringDataValue.COLLATION_TYPE_UCS_BASIC then the call is the equivalent of the overload without collationType.

Throws:

StandardException

getLongvarcharDataValue

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

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

Get a SQLLongvarchar object to represent a SQL LONG VARCHAR (UCS_BASIC) with the given value. A null argument means get a SQL NULL value. If previous is not null (Java reference) then it will be set to the value passed in and returned, otherwise a new SQLLongvarchar will be created and set to the value.

Throws:

StandardException

getLongvarcharDataValue

StringDataValue getLongvarcharDataValue(java.lang.String value,
                                        StringDataValue previous,
                                        int collationType)
                                        throws StandardException

Get a StringDataValue to represent a SQL LONG VARCHAR with the passed in collationType. A null argument means get a SQL NULL value. If previous is not null (Java reference) then it will be set to the value passed in and returned, otherwise a new StringDataValue will be created and set to the value. If collationType is equal to StringDataValue.COLLATION_TYPE_UCS_BASIC then the call is the equivalent of the overload without collationType.

Throws:

StandardException

getClobDataValue

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

Get a SQLClob object to represent a SQL CLOB (UCS_BASIC) with the given value. A null argument means get a SQL NULL value. If previous is not null (Java reference) then it will be set to the value passed in and returned, otherwise a new SQLLongvarchar will be created and set to the value.

Throws:

StandardException

getClobDataValue

StringDataValue getClobDataValue(java.lang.String value,
                                 StringDataValue previous,
                                 int collationType)
                                 throws StandardException

Get a StringDataValue to represent a SQL LONG VARCHAR with the passed in collationType. A null argument means get a SQL NULL value. If previous is not null (Java reference) then it will be set to the value passed in and returned, otherwise a new StringDataValue will be created and set to the value. If collationType is equal to StringDataValue.COLLATION_TYPE_UCS_BASIC then the call is the equivalent of the overload without collationType.

Throws:

StandardException

getDataValue

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

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

getDataValue

RefDataValue getDataValue(RowLocation value,
                          RefDataValue previous)

Get a RefDataValue with the given value. A null argument means get a SQL null value. Uses the previous value (if non-null) to hold the return value.

getDataValue

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

NumberDataValue getDataValue(int value,
                             NumberDataValue previous)
                             throws StandardException

Throws:

StandardException

getDataValue

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

NumberDataValue getDataValue(long value,
                             NumberDataValue previous)
                             throws StandardException

Throws:

StandardException

getDataValue

NumberDataValue getDataValue(float value,
                             NumberDataValue previous)
                             throws StandardException

Get a SQL real with the given value. Uses the previous value, if non-null, as the data holder to return.

Throws:

StandardException - Thrown on error

getDataValue

NumberDataValue getDataValue(double value,
                             NumberDataValue previous)
                             throws StandardException

Get a SQL double precision with the given value. Uses the previous value, if non-null, as the data holder to return.

Throws:

StandardException - Thrown on error

getDataValue

NumberDataValue getDataValue(short value,
                             NumberDataValue previous)
                             throws StandardException

Get a SQL SMALLINT with the given value. Uses the previous value, if non-null, as the data holder to return.

Throws:

StandardException

getDataValue

NumberDataValue getDataValue(byte value,
                             NumberDataValue previous)
                             throws StandardException

Get a SQL TINYINT with the given value. Uses the previous value, if non-null, as the data holder to return.

Throws:

StandardException

getDecimalDataValue

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

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

Throws:

StandardException

getDecimalDataValue

NumberDataValue getDecimalDataValue(java.lang.Long value,
                                    NumberDataValue previous)
                                    throws StandardException

Get a SQL DECIMAL with the given value.

Throws:

StandardException - Thrown on error

getDecimalDataValue

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

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

Throws:

StandardException

getDataValue

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

BooleanDataValue getDataValue(boolean value,
                              BooleanDataValue previous)
                              throws StandardException

Throws:

StandardException

getBitDataValue

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

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

Throws:

StandardException

getVarbitDataValue

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

Get a SQL bit with the given value. Uses the previous value, if non-null, as the data holder to return.

Throws:

StandardException - Thrown on error

getCharDataValue

StringDataValue getCharDataValue(java.lang.String value)

Get a new SQLChar object to represent a SQL CHAR (UCS_BASIC) with the given value. A null argument means get a SQL NULL value.

getCharDataValue

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

Get a SQLChar object to represent a SQL CHAR (UCS_BASIC with the given value. A null argument means get a SQL NULL value. If previous is not null (Java reference) then it will be set to the value passed in and returned, otherwise a new SQLChar will be created and set to the value.

Throws:

StandardException

getCharDataValue

StringDataValue getCharDataValue(java.lang.String value,
                                 StringDataValue previous,
                                 int collationType)
                                 throws StandardException

Get a StringDataValue to represent a SQL CHAR with the passed in collationType. A null argument means get a SQL NULL value. If previous is not null (Java reference) then it will be set to the value passed in and returned, otherwise a new StringDataValue will be created and set to the value. If collationType is equal to StringDataValue.COLLATION_TYPE_UCS_BASIC then the call is the equivalent of the overload without collationType.

Throws:

StandardException

getDataValue

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

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

Throws:

StandardException

getDataValue

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

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

Throws:

StandardException

getDataValue

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

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

Throws:

StandardException

getTimestamp

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

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

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

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

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

DateTimeDataValue getTimestampValue(java.lang.String timestampStr,
                                    boolean isJdbcEscape)
                                    throws StandardException

Parameters:

timestampStr - A time in string format.

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

XMLDataValue getXMLDataValue(XMLDataValue previous)
                             throws StandardException

Get a null XML value. Uses the previous value, if non-null, as the data holder to return.

Throws:

StandardException

getNullInteger

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

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

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

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