org.apache.derby.iapi.types

Interface ConcatableDataValue

All Superinterfaces:

DataValueDescriptor, java.io.Externalizable, Formatable, Orderable, java.io.Serializable, Storable, TypedFormat, VariableSizeDataValue

All Known Subinterfaces:

BitDataValue, StringDataValue

All Known Implementing Classes:

CollatorSQLChar, CollatorSQLClob, CollatorSQLLongvarchar, CollatorSQLVarchar, SQLBinary, SQLBit, SQLBlob, SQLChar, SQLClob, SQLLongVarbit, SQLLongvarchar, SQLVarbit, SQLVarchar

public interface ConcatableDataValue
extends DataValueDescriptor, VariableSizeDataValue

The ConcatableDataValue interface corresponds to the SQL 92 string value data type. It is implemented by datatypes that have a length, and can be concatenated. It is implemented by the character datatypes and the bit datatypes. The following methods are defined herein: charLength() The following is defined by the sub classes (bit and char) concatenate()

Field Summary

Fields inherited from interface org.apache.derby.iapi.types.DataValueDescriptor

UNKNOWN_LOGICAL_LENGTH

Fields inherited from interface org.apache.derby.iapi.types.Orderable

ORDER_OP_EQUALS, ORDER_OP_GREATEROREQUALS, ORDER_OP_GREATERTHAN, ORDER_OP_LESSOREQUALS, ORDER_OP_LESSTHAN

Fields inherited from interface org.apache.derby.iapi.types.VariableSizeDataValue

IGNORE_PRECISION

Method Summary

Methods

Modifier and Type	Method and Description
NumberDataValue	charLength(NumberDataValue result) The SQL char_length() function.
ConcatableDataValue	substring(NumberDataValue start, NumberDataValue length, ConcatableDataValue result, int maxLen) substr() function matchs DB2 syntax and behaviour.

Methods inherited from interface org.apache.derby.iapi.types.DataValueDescriptor

checkHostVariable, cloneHolder, cloneValue, coalesce, compare, compare, compare, compare, equals, estimateMemoryUsage, getBoolean, getByte, getBytes, getDate, getDouble, getFloat, getInt, getLength, getLong, getNewNull, getObject, getShort, getStream, getString, getTime, getTimestamp, getTraceString, getTypeName, greaterOrEquals, greaterThan, hasStream, in, isNotNull, isNullOp, lessOrEquals, lessThan, normalize, notEquals, readExternalFromArray, recycle, setBigDecimal, setInto, setInto, setObjectForCast, setToNull, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueFromResultSet, typePrecedence, typeToBigDecimal

Methods inherited from interface org.apache.derby.iapi.services.io.Storable

isNull, restoreToNull

Methods inherited from interface java.io.Externalizable

readExternal, writeExternal

Methods inherited from interface org.apache.derby.iapi.services.io.TypedFormat

getTypeFormatId

Methods inherited from interface org.apache.derby.iapi.types.VariableSizeDataValue

setWidth

Method Detail

charLength

NumberDataValue charLength(NumberDataValue result)
                           throws StandardException

The SQL char_length() function.

Parameters:

result - The result of a previous call to this method, null if not called yet.

Returns:

A NumberDataValue containing the result of the char_length

Throws:

StandardException - Thrown on error

substring

ConcatableDataValue substring(NumberDataValue start,
                            NumberDataValue length,
                            ConcatableDataValue result,
                            int maxLen)
                              throws StandardException

substr() function matchs DB2 syntax and behaviour.

Parameters:

start - Start of substr

length - Length of substr

result - The result of a previous call to this method, null if not called yet.

maxLen - Maximum length of the result string

Returns:

A ConcatableDataValue containing the result of the substr()

Throws:

StandardException - Thrown on error