|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Field Summary | |
static int |
BOTH
|
static int |
LEADING
|
static int |
TRAILING
|
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 | |
StringDataValue |
concatenate(StringDataValue leftOperand,
StringDataValue rightOperand,
StringDataValue result)
The SQL concatenation '||' operator. |
char[] |
getCharArray()
Get a char array. |
BooleanDataValue |
like(DataValueDescriptor pattern)
The SQL like() function with out escape clause. |
BooleanDataValue |
like(DataValueDescriptor pattern,
DataValueDescriptor escape)
The SQL like() function WITH escape clause. |
NumberDataValue |
locate(StringDataValue searchFrom,
NumberDataValue start,
NumberDataValue result)
Position in searchFrom of the first occurrence of this.value. |
StringDataValue |
lower(StringDataValue result)
Convert the string to lower case. |
StringDataValue |
trim(int trimType,
StringDataValue result)
The SQL trim(), ltrim() and rtrim() functions. |
StringDataValue |
upper(StringDataValue result)
Convert the string to upper case. |
XMLDataValue |
XMLParse(XMLDataValue result,
boolean preserveWS)
|
Methods inherited from interface org.apache.derby.iapi.types.ConcatableDataValue |
charLength, substring |
Methods inherited from interface org.apache.derby.iapi.types.DataValueDescriptor |
checkHostVariable, coalesce, compare, compare, equals, estimateMemoryUsage, getBoolean, getByte, getBytes, getClone, getDate, getDouble, getFloat, getInt, getLength, getLong, getNewNull, getObject, getShort, getStream, getString, getTime, getTimestamp, getTypeName, greaterOrEquals, greaterThan, in, isNotNull, isNullOp, lessOrEquals, lessThan, normalize, notEquals, readExternalFromArray, setBigDecimal, setInto, setInto, setObjectForCast, setToNull, 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 |
Field Detail |
public static final int BOTH
public static final int TRAILING
public static final int LEADING
Method Detail |
public StringDataValue concatenate(StringDataValue leftOperand, StringDataValue rightOperand, StringDataValue result) throws StandardException
leftOperand
- String on the left hand side of '||'rightOperand
- String on the right hand side of '||'result
- The result of a previous call to this method,
null if not called yet.
StandardException
- Thrown on errorpublic BooleanDataValue like(DataValueDescriptor pattern) throws StandardException
pattern
- the pattern to use
StandardException
- Thrown on errorpublic BooleanDataValue like(DataValueDescriptor pattern, DataValueDescriptor escape) throws StandardException
pattern
- the pattern to useescape
- the escape character
StandardException
- Thrown on errorpublic StringDataValue trim(int trimType, StringDataValue result) throws StandardException
trimType
- Type of trimresult
- The result of a previous call to this method,
null if not called yet.
StandardException
- Thrown on errorpublic StringDataValue upper(StringDataValue result) throws StandardException
result
- The result (reusable - allocate if null).
StandardException
- Thrown on errorpublic StringDataValue lower(StringDataValue result) throws StandardException
result
- The result (reusable - allocate if null).
StandardException
- Thrown on errorpublic NumberDataValue locate(StringDataValue searchFrom, NumberDataValue start, NumberDataValue result) throws StandardException
searchFrom
- - The string to search fromstart
- - The position to search from in string searchFromresult
- - The object to return
StandardException
- Thrown on errorpublic char[] getCharArray() throws StandardException
WARNING: may return a character array that has spare characters at the end. MUST be used in conjunction with getLength() to be safe.
StandardException
- Thrown on errorpublic XMLDataValue XMLParse(XMLDataValue result, boolean preserveWS) throws StandardException
StandardException
|
Built on Mon 2007-06-04 09:58:47+0400, from revision ??? | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |