Package org.eclipse.persistence.expressions

Class ExpressionOperator

java.lang.Object
org.eclipse.persistence.expressions.ExpressionOperator
All Implemented Interfaces:
Serializable
Direct Known Subclasses:
ListExpressionOperator
public class ExpressionOperator extends Object implements Serializable

Purpose: ADVANCED: The expression operator is used internally to define SQL operations and functions. It is possible for an advanced user to define their own operators.

See Also:

  • Field Details

  • Constructor Details

    • ExpressionOperator

      public ExpressionOperator()
      ADVANCED: Create a new operator.

    • ExpressionOperator

      public ExpressionOperator(int selector, List<String> newDatabaseStrings)
      ADVANCED: Create a new operator with the given name(s) and strings to print.

  • Method Details

    • isBindingSupported

      @Deprecated public Boolean isBindingSupported()
      Deprecated.
      PUBLIC: Return if binding is compatible with this operator.

    • setIsBindingSupported

      @Deprecated public void setIsBindingSupported(Boolean isBindingSupported)
      Deprecated.
      PUBLIC: Set if binding is compatible with this operator. Some databases do not allow binding, or require casting with certain operators.

    • equals

      public boolean equals(Object object)
      INTERNAL: Return if the operator is equal to the other.
      Overrides:
      equals in class Object

    • hashCode

      public int hashCode()
      INTERNAL: Return the hash-code based on the unique selector.
      Overrides:
      hashCode in class Object

    • abs

      public static ExpressionOperator abs()
      INTERNAL: Build operator.

    • acos

      public static ExpressionOperator acos()
      INTERNAL: Build operator.

    • add

      public static ExpressionOperator add()
      INTERNAL: Build operator.

    • addDate

      public static ExpressionOperator addDate()
      INTERNAL: Build operator.

    • addMonths

      public static ExpressionOperator addMonths()
      INTERNAL: Build operator.

    • addOperator

      public static void addOperator(ExpressionOperator exOperator)
      ADVANCED: Add an operator to the user defined list of operators.

    • registerOperator

      public static void registerOperator(int selector, String name)
      ADVANCED: Define a name for a user defined operator.

    • and

      public static ExpressionOperator and()
      INTERNAL: Create the AND operator.

    • applyFunction

      public Object applyFunction(Object source, List arguments)
      INTERNAL: Apply this to an object in memory. Throw an error if the function is not supported.

    • ascending

      public static ExpressionOperator ascending()
      INTERNAL: Create the ASCENDING operator.

    • as

      public static ExpressionOperator as()
      INTERNAL: Create the AS operator.

    • nullsFirst

      public static ExpressionOperator nullsFirst()
      INTERNAL: Create the NULLS FIRST ordering operator.

    • nullsLast

      public static ExpressionOperator nullsLast()
      INTERNAL: Create the NULLS LAST ordering operator.

    • ascii

      public static ExpressionOperator ascii()
      INTERNAL: Build operator.

    • asin

      public static ExpressionOperator asin()
      INTERNAL: Build operator.

    • atan

      public static ExpressionOperator atan()
      INTERNAL: Build operator.

    • average

      public static ExpressionOperator average()
      INTERNAL: Create the AVERAGE operator.

    • bePostfix

      public void bePostfix()
      ADVANCED: Tell the operator to be postfix, i.e. its strings start printing after those of its first argument.

    • bePrefix

      public void bePrefix()
      ADVANCED: Tell the operator to be pretfix, i.e. its strings start printing before those of its first argument.

    • beRepeating

      public void beRepeating()
      INTERNAL: Make this a repeating argument. Currently unused.

    • between

      public static ExpressionOperator between()
      INTERNAL: Create the BETWEEN Operator

    • notBetween

      public static ExpressionOperator notBetween()
      INTERNAL: Create the NOT BETWEEN Operator

    • caseStatement

      public static ExpressionOperator caseStatement()
      INTERNAL: Build operator. Note: This operator works differently from other operators.
      See Also:

    • caseConditionStatement

      public static ExpressionOperator caseConditionStatement()
      INTERNAL: Build operator. Note: This operator works differently from other operators.
      See Also:

    • ceil

      public static ExpressionOperator ceil()
      INTERNAL: Build operator.

    • charIndex

      public static ExpressionOperator charIndex()
      INTERNAL: Build operator.

    • charLength

      public static ExpressionOperator charLength()
      INTERNAL: Build operator.

    • chr

      public static ExpressionOperator chr()
      INTERNAL: Build operator.

    • coalesce

      public static ExpressionOperator coalesce()
      INTERNAL: Build operator. Note: This operator works differently from other operators.
      See Also:

    • concat

      public static ExpressionOperator concat()
      INTERNAL: Build operator.

    • conformBetween

      public boolean conformBetween(Object left, Object right)
      INTERNAL: Compare between in memory.

    • conformLike

      public boolean conformLike(Object left, Object right)
      INTERNAL: Compare like in memory. This only works for % not _.

    • clone

      public ExpressionOperator clone()
      Overrides:
      clone in class Object

    • copyTo

      public void copyTo(ExpressionOperator operator)

    • cos

      public static ExpressionOperator cos()
      INTERNAL: Build operator.

    • cosh

      public static ExpressionOperator cosh()
      INTERNAL: Build operator.

    • cot

      public static ExpressionOperator cot()
      INTERNAL: Build operator.

    • count

      public static ExpressionOperator count()
      INTERNAL: Create the COUNT operator.

    • dateDifference

      public static ExpressionOperator dateDifference()
      INTERNAL: Build operator.

    • dateName

      public static ExpressionOperator dateName()
      INTERNAL: Build operator.

    • oracleDateName

      @Deprecated public static ExpressionOperator oracleDateName()
      Deprecated.
      INTERNAL: Oracle equivalent to DATENAME is TO_CHAR.

    • datePart

      public static ExpressionOperator datePart()
      INTERNAL: Build operator.

    • dateToString

      public static ExpressionOperator dateToString()
      INTERNAL: Build operator.

    • toChar

      public static ExpressionOperator toChar()
      INTERNAL: Build operator.

    • toCharWithFormat

      public static ExpressionOperator toCharWithFormat()
      INTERNAL: Build operator.

    • decode

      public static ExpressionOperator decode()
      INTERNAL: Build operator. Note: This operator works differently from other operators.
      See Also:

    • deref

      public static ExpressionOperator deref()
      INTERNAL: Build operator.

    • descending

      public static ExpressionOperator descending()
      INTERNAL: Create the DESCENDING operator.

    • difference

      public static ExpressionOperator difference()
      INTERNAL: Build operator.

    • distinct

      public static ExpressionOperator distinct()
      INTERNAL: Create the DISTINCT operator.

    • divide

      public static ExpressionOperator divide()
      INTERNAL: Create the DISTINCT operator.

    • doesRelationConform

      public boolean doesRelationConform(Object left, Object right)
      INTERNAL: Compare the values in memory. Used for in-memory querying, all operators are not support.

    • equal

      public static ExpressionOperator equal()

    • equalOuterJoin

      public static ExpressionOperator equalOuterJoin()
      INTERNAL: Initialize the outer join operator Note: This is merely a shell which is incomplete, and so will be replaced by the platform's operator when we go to print. We need to create this here so that the expression class is correct, normally it assumes functions for unknown operators.

    • exists

      public static ExpressionOperator exists()
      INTERNAL: Create the EXISTS operator.

    • exp

      public static ExpressionOperator exp()
      INTERNAL: Build operator.

    • expressionFor

      public Expression expressionFor(Expression base)
      INTERNAL: Create an expression for this operator, using the given base.

    • expressionFor

      public Expression expressionFor(Expression base, Object value)
      INTERNAL: Create an expression for this operator, using the given base and a single argument.

    • expressionForWithBaseLast

      public Expression expressionForWithBaseLast(Expression base, Object value)
      INTERNAL: Create an expression for this operator, using the given base and a single argument. Base is used last in the expression

    • expressionForArguments

      public Expression expressionForArguments(Expression base, List arguments)
      INTERNAL: Create an expression for this operator, using the given base and arguments.

    • extractXml

      public static ExpressionOperator extractXml()
      INTERNAL: Create the extract expression operator

    • extractValue

      public static ExpressionOperator extractValue()
      INTERNAL: Create the extractValue expression operator

    • existsNode

      public static ExpressionOperator existsNode()
      INTERNAL: Create the existsNode expression operator

    • getStringVal

      public static ExpressionOperator getStringVal()

    • getNumberVal

      public static ExpressionOperator getNumberVal()

    • isFragment

      public static ExpressionOperator isFragment()

    • floor

      public static ExpressionOperator floor()
      INTERNAL: Build operator.

    • getAllOperators

      public static Map<Integer,ExpressionOperator> getAllOperators()
      ADVANCED: Return the map of all operators.

    • getAllInternalOperators

      public static Map<Integer,ExpressionOperator> getAllInternalOperators()
      INTERNAL:

    • getPlatformOperatorSelectors

      public static Map<String,Integer> getPlatformOperatorSelectors()

    • getDatabaseStrings

      @Deprecated public String[] getDatabaseStrings()
      Deprecated.
      INTERNAL:

    • getDatabaseStrings

      public String[] getDatabaseStrings(int arguments)
      INTERNAL:

    • getJavaStrings

      public String[] getJavaStrings()
      INTERNAL:

    • getNodeClass

      public Class getNodeClass()
      INTERNAL:

    • getOperator

      public static ExpressionOperator getOperator(Integer selector)
      INTERNAL: Lookup the operator with the given id.

      This will only check user defined operators. For operators defined internally, see ExpressionOperator#getInternalOperator()

    • getInternalOperator

      public static ExpressionOperator getInternalOperator(Integer selector)
      INTERNAL: Lookup the internal operator with the given id.

    • getSelector

      public int getSelector()
      INTERNAL: Return the selector id.

    • getName

      public String getName()
      INTERNAL: Return the name.

    • setName

      public void setName(String name)
      INTERNAL: Set the name.

    • getType

      public int getType()
      ADVANCED: Return the type of function. This must be one of the static function types defined in this class.

    • greaterThan

      public static ExpressionOperator greaterThan()
      INTERNAL: Build operator.

    • greaterThanEqual

      public static ExpressionOperator greaterThanEqual()
      INTERNAL: Build operator.

    • greatest

      public static ExpressionOperator greatest()
      INTERNAL: Build operator.

    • hexToRaw

      public static ExpressionOperator hexToRaw()
      INTERNAL: Build operator.

    • ifNull

      public static ExpressionOperator ifNull()
      INTERNAL: Build operator.

    • in

      public static ExpressionOperator in()
      INTERNAL: Create the IN operator.

    • inSubQuery

      public static ExpressionOperator inSubQuery()
      INTERNAL: Create the IN operator taking a subquery. Note, the subquery itself comes with parenethesis, so the IN operator should not add any parenethesis.

    • initcap

      public static ExpressionOperator initcap()
      INTERNAL: Build operator.

    • initializeAggregateFunctionOperators

      protected static void initializeAggregateFunctionOperators()
      INTERNAL:

    • initializeComparisonOperators

      protected static void initializeComparisonOperators()
      INTERNAL:

    • initializeFunctionOperators

      protected static void initializeFunctionOperators()
      INTERNAL:

    • initializeLogicalOperators

      protected static void initializeLogicalOperators()
      INTERNAL:

    • initializeOrderOperators

      protected static void initializeOrderOperators()
      INTERNAL:

    • initializeRelationOperators

      protected static void initializeRelationOperators()
      INTERNAL:

    • initializeOperators

      public static Map initializeOperators()
      INTERNAL:

    • getPlatformOperatorName

      public static String getPlatformOperatorName(int operator)
      INTERNAL: Initialize a mapping to the platform operator names for usage with exceptions.

    • getPlatformOperatorNames

      public static Map getPlatformOperatorNames()
      INTERNAL: Initialize a mapping to the platform operator names for usage with exceptions.

    • initializePlatformOperatorNames

      public static Map<Integer,String> initializePlatformOperatorNames()
      INTERNAL: Initialize a mapping to the platform operator names for usage with exceptions.

    • initializePlatformOperatorSelectors

      public static Map<String,Integer> initializePlatformOperatorSelectors()
      INTERNAL: Initialize a mapping to the platform operator names for usage with exceptions.

    • instring

      public static ExpressionOperator instring()
      INTERNAL: Build operator.

    • isAggregateOperator

      public boolean isAggregateOperator()
      Aggregate functions are function in the select such as COUNT.

    • isComparisonOperator

      public boolean isComparisonOperator()
      Comparison functions are functions such as = and >.

    • isComplete

      public boolean isComplete()
      INTERNAL: If we have all the required information, this operator is complete and can be used as is. Otherwise we will need to look up a platform- specific operator.

    • isFunctionOperator

      public boolean isFunctionOperator()
      General functions are any normal function such as UPPER.

    • isLogicalOperator

      public boolean isLogicalOperator()
      Logical functions are functions such as and and or.

    • isNull

      public static ExpressionOperator isNull()
      INTERNAL: Create the ISNULL operator.

    • isOrderOperator

      public boolean isOrderOperator()
      Order functions are used in the order by such as ASC.

    • isPrefix

      public boolean isPrefix()
      ADVANCED: Return true if this is a prefix operator.

    • lastDay

      public static ExpressionOperator lastDay()
      INTERNAL: Build operator.

    • least

      public static ExpressionOperator least()
      INTERNAL: Build operator.

    • leftPad

      public static ExpressionOperator leftPad()
      INTERNAL: Build operator.

    • leftTrim

      public static ExpressionOperator leftTrim()
      INTERNAL: Build operator.

    • leftTrim2

      public static ExpressionOperator leftTrim2()
      INTERNAL: Build leftTrim operator that takes one parameter.

    • length

      public static ExpressionOperator length()
      INTERNAL: Build operator.

    • lessThan

      public static ExpressionOperator lessThan()

    • lessThanEqual

      public static ExpressionOperator lessThanEqual()

    • like

      public static ExpressionOperator like()
      INTERNAL: Create the LIKE operator.

    • regexp

      public static ExpressionOperator regexp()
      INTERNAL: Create the REGEXP operator. REGEXP allows for comparison through regular expression, this is supported by many databases and with be part of the next SQL standard.

    • likeEscape

      public static ExpressionOperator likeEscape()
      INTERNAL: Create the LIKE operator with ESCAPE.

    • notLikeEscape

      public static ExpressionOperator notLikeEscape()
      INTERNAL: Create the LIKE operator with ESCAPE.

    • ln

      public static ExpressionOperator ln()
      INTERNAL: Build operator.

    • locate

      public static ExpressionOperator locate()
      INTERNAL: Build locate operator i.e. LOCATE("ob", t0.F_NAME)

    • locate2

      public static ExpressionOperator locate2()
      INTERNAL: Build locate operator with 3 params i.e. LOCATE("coffee", t0.DESCRIP, 4). Last parameter is a start at.

    • log

      public static ExpressionOperator log()
      INTERNAL: Build operator.

    • maximum

      public static ExpressionOperator maximum()
      INTERNAL: Create the MAXIMUM operator.

    • minimum

      public static ExpressionOperator minimum()
      INTERNAL: Create the MINIMUM operator.

    • mod

      public static ExpressionOperator mod()
      INTERNAL: Build operator.

    • monthsBetween

      public static ExpressionOperator monthsBetween()
      INTERNAL: Build operator.

    • multiply

      public static ExpressionOperator multiply()
      INTERNAL: Build operator.

    • newExpressionForArgument

      public Expression newExpressionForArgument(Expression base, Object singleArgument)
      INTERNAL: Create a new expression. Optimized for the single argument case.

    • createNode

      protected Expression createNode()
      INTERNAL: Instantiate an instance of the operator's node class.

    • newExpressionForArgumentWithBaseLast

      public Expression newExpressionForArgumentWithBaseLast(Expression base, Object singleArgument)
      INTERNAL: Create a new expression. Optimized for the single argument case with base last

    • newExpressionForArguments

      public Expression newExpressionForArguments(Expression base, List arguments)
      INTERNAL: The general case.

    • negate

      public static ExpressionOperator negate()
      INTERNAL: Build operator.

    • newTime

      public static ExpressionOperator newTime()
      INTERNAL: Build operator.

    • nextDay

      public static ExpressionOperator nextDay()
      INTERNAL: Build operator.

    • notEqual

      public static ExpressionOperator notEqual()

    • notExists

      public static ExpressionOperator notExists()
      INTERNAL: Create the NOT EXISTS operator.

    • notIn

      public static ExpressionOperator notIn()
      INTERNAL: Create the NOTIN operator.

    • notInSubQuery

      public static ExpressionOperator notInSubQuery()
      INTERNAL: Create the NOTIN operator taking a subQuery. Note, the subquery itself comes with parenethesis, so the IN operator should not add any parenethesis.

    • notLike

      public static ExpressionOperator notLike()
      INTERNAL: Create the NOTLIKE operator.

    • notNull

      public static ExpressionOperator notNull()
      INTERNAL: Create the NOTNULL operator.

    • notOperator

      public static ExpressionOperator notOperator()
      INTERNAL: Create the NOT operator.

    • nullIf

      public static ExpressionOperator nullIf()
      INTERNAL: Build operator.

    • or

      public static ExpressionOperator or()
      INTERNAL: Create the OR operator.

    • power

      public static ExpressionOperator power()
      INTERNAL: Build operator.

    • printCollection

      public void printCollection(List<Expression> items, org.eclipse.persistence.internal.expressions.ExpressionSQLPrinter printer)
      INTERNAL: Print the collection onto the SQL stream.

    • printJavaCollection

      public void printJavaCollection(List<Expression> items, org.eclipse.persistence.internal.expressions.ExpressionJavaPrinter printer)
      INTERNAL: Print the collection onto the SQL stream.

    • printDuo

      public void printDuo(Expression first, Expression second, org.eclipse.persistence.internal.expressions.ExpressionSQLPrinter printer)
      INTERNAL: For performance, special case printing two children, since it's by far the most common

    • printJavaDuo

      public void printJavaDuo(Expression first, Expression second, org.eclipse.persistence.internal.expressions.ExpressionJavaPrinter printer)
      INTERNAL: For performance, special case printing two children, since it's by far the most common

    • printsAs

      public void printsAs(String s)
      ADVANCED: Set the single string for this operator.

    • printsAs

      public void printsAs(List<String> dbStrings)
      ADVANCED: Set the strings for this operator.

    • printsJavaAs

      public void printsJavaAs(String s)
      ADVANCED: Set the single string for this operator.

    • printsJavaAs

      public void printsJavaAs(List<String> dbStrings)
      ADVANCED: Set the strings for this operator.

    • ref

      public static ExpressionOperator ref()
      INTERNAL: Build operator.

    • refToHex

      public static ExpressionOperator refToHex()
      INTERNAL: Build operator.

    • replace

      public static ExpressionOperator replace()
      INTERNAL: Build operator.

    • replicate

      public static ExpressionOperator replicate()
      INTERNAL: Build operator.

    • resetOperators

      public static void resetOperators()
      INTERNAL: Reset all the operators.

    • reverse

      public static ExpressionOperator reverse()
      INTERNAL: Build operator.

    • right

      public static ExpressionOperator right()
      INTERNAL: Build operator.

    • rightPad

      public static ExpressionOperator rightPad()
      INTERNAL: Build operator.

    • rightTrim

      public static ExpressionOperator rightTrim()
      INTERNAL: Build operator.

    • rightTrim2

      public static ExpressionOperator rightTrim2()
      INTERNAL: Build rightTrim operator that takes one parameter.

    • round

      public static ExpressionOperator round()
      INTERNAL: Build operator.

    • roundDate

      public static ExpressionOperator roundDate()
      INTERNAL: Build operator.

    • setArgumentIndices

      public void setArgumentIndices(int[] indices)
      ADVANCED: Set the array of indexes to use when building the SQL function. The index of the array is the position in the printout, from left to right, starting with zero. The value of the array entry is the number of the argument to print at that particular output position. So each argument can be used zero, one or many times.

    • setNodeClass

      public void setNodeClass(Class nodeClass)
      ADVANCED: Set the node class for this operator. For user-defined functions this is set automatically but can be changed.

      A list of Operator types, an example, and the node class used follows.

      LogicalOperator AND LogicalExpression

      ComparisonOperator <> RelationExpression

      AggregateOperator COUNT FunctionExpression

      OrderOperator ASCENDING "

      FunctionOperator RTRIM "

      Node classes given belong to org.eclipse.persistence.internal.expressions.

    • setSelector

      public void setSelector(int selector)
      INTERNAL: Set the selector id.

    • setType

      public void setType(int type)
      ADVANCED: Set the type of function. This must be one of the static function types defined in this class.

    • sign

      public static ExpressionOperator sign()
      INTERNAL: Build operator.

    • simpleAggregate

      public static ExpressionOperator simpleAggregate(int selector, String databaseName, String javaName)
      INTERNAL: Create an operator for a simple aggregate given a Java name and a single String for the database (parentheses will be added automatically).

    • simpleFunction

      public static ExpressionOperator simpleFunction(int selector, String databaseName)
      INTERNAL: Create an operator for a simple function given a Java name and a single String for the database (parentheses will be added automatically).

    • simpleFunctionNoParentheses

      public static ExpressionOperator simpleFunctionNoParentheses(int selector, String databaseName)
      INTERNAL: Create an operator for a simple function call without parentheses

    • simpleFunction

      public static ExpressionOperator simpleFunction(int selector, String databaseName, String javaName)
      INTERNAL: Create an operator for a simple function given a Java name and a single String for the database (parentheses will be added automatically).

    • simpleLogical

      public static ExpressionOperator simpleLogical(int selector, String databaseName, String javaName)
      INTERNAL: Create an operator for a simple logical given a Java name and a single String for the database (parentheses will be added automatically).

    • simpleMath

      public static ExpressionOperator simpleMath(int selector, String databaseName)
      INTERNAL: Create an operator for a simple math operation, i.e. +, -, *, /

    • simpleOrdering

      public static ExpressionOperator simpleOrdering(int selector, String databaseName, String javaName)
      INTERNAL: Create an operator for a simple ordering given a Java name and a single String for the database (parentheses will be added automatically).

    • simpleRelation

      public static ExpressionOperator simpleRelation(int selector, String databaseName)
      INTERNAL: Create an operator for a simple relation given a Java name and a single String for the database (parentheses will be added automatically).

    • simpleRelation

      public static ExpressionOperator simpleRelation(int selector, String databaseName, String javaName)
      INTERNAL: Create an operator for a simple relation given a Java name and a single String for the database (parentheses will be added automatically).

    • simpleThreeArgumentFunction

      public static ExpressionOperator simpleThreeArgumentFunction(int selector, String dbString)
      INTERNAL: Build operator.

    • simpleTwoArgumentFunction

      public static ExpressionOperator simpleTwoArgumentFunction(int selector, String dbString)
      INTERNAL: Build operator.

    • simpleLogicalNoParens

      public static ExpressionOperator simpleLogicalNoParens(int selector, String dbString)
      INTERNAL: e.g.: ... "Bob" CONCAT "Smith" ... Parentheses will not be addded. [RMB - March 5 2000]

    • sin

      public static ExpressionOperator sin()
      INTERNAL: Build operator.

    • sinh

      public static ExpressionOperator sinh()
      INTERNAL: Build operator.

    • soundex

      public static ExpressionOperator soundex()
      INTERNAL: Build operator.

    • sqrt

      public static ExpressionOperator sqrt()
      INTERNAL: Build operator.

    • standardDeviation

      public static ExpressionOperator standardDeviation()
      INTERNAL: Build operator.

    • substring

      public static ExpressionOperator substring()
      INTERNAL: Build operator.

    • substringSingleArg

      public static ExpressionOperator substringSingleArg()
      INTERNAL: Build operator.

    • subtract

      public static ExpressionOperator subtract()

    • sum

      public static ExpressionOperator sum()
      Create the SUM operator.

    • sybaseAddMonthsOperator

      @Deprecated public static ExpressionOperator sybaseAddMonthsOperator()
      Deprecated.
      INTERNAL: Function, to add months to a date.

    • sybaseAtan2Operator

      @Deprecated public static ExpressionOperator sybaseAtan2Operator()
      Deprecated.
      INTERNAL: Build operator.

    • sybaseInStringOperator

      @Deprecated public static ExpressionOperator sybaseInStringOperator()
      Deprecated.
      INTERNAL: Build instring operator

    • sybaseToNumberOperator

      @Deprecated public static ExpressionOperator sybaseToNumberOperator()
      Deprecated.
      INTERNAL: Build Sybase equivalent to TO_NUMBER.

    • sybaseToDateToStringOperator

      @Deprecated public static ExpressionOperator sybaseToDateToStringOperator()
      Deprecated.
      INTERNAL: Build Sybase equivalent to TO_CHAR.

    • sybaseToDateOperator

      @Deprecated public static ExpressionOperator sybaseToDateOperator()
      Deprecated.
      INTERNAL: Build Sybase equivalent to TO_DATE.

    • sybaseToCharOperator

      @Deprecated public static ExpressionOperator sybaseToCharOperator()
      Deprecated.
      INTERNAL: Build Sybase equivalent to TO_CHAR.

    • sybaseToCharWithFormatOperator

      @Deprecated public static ExpressionOperator sybaseToCharWithFormatOperator()
      Deprecated.
      INTERNAL: Build Sybase equivalent to TO_CHAR.

    • sybaseLocateOperator

      @Deprecated public static ExpressionOperator sybaseLocateOperator()
      Deprecated.
      INTERNAL: Build the Sybase equivalent to Locate

    • sybaseLocate2Operator

      @Deprecated public static ExpressionOperator sybaseLocate2Operator()
      Deprecated.
      INTERNAL: Build the Sybase equivalent to Locate with a start index. Sybase does not define this, so this gets a little complex...

    • tan

      public static ExpressionOperator tan()
      INTERNAL: Build operator.

    • tanh

      public static ExpressionOperator tanh()
      INTERNAL: Build operator.

    • toDate

      public static ExpressionOperator toDate()
      INTERNAL: Build operator.

    • today

      public static ExpressionOperator today()
      INTERNAL: Build operator.

    • currentTimeStamp

      public static ExpressionOperator currentTimeStamp()
      INTERNAL: Build operator.

    • currentDate

      public static ExpressionOperator currentDate()
      INTERNAL: Build operator.

    • currentTime

      public static ExpressionOperator currentTime()
      INTERNAL: Build operator.

    • toLowerCase

      public static ExpressionOperator toLowerCase()
      INTERNAL: Create the toLowerCase operator.

    • toNumber

      public static ExpressionOperator toNumber()
      INTERNAL: Build operator.

    • toString

      public String toString()
      Print a debug representation of this operator.
      Overrides:
      toString in class Object

    • toUpperCase

      public static ExpressionOperator toUpperCase()
      INTERNAL: Create the TOUPPERCASE operator.

    • translate

      public static ExpressionOperator translate()
      INTERNAL: Build operator.

    • trim

      public static ExpressionOperator trim()
      INTERNAL: Build operator.

    • trim2

      public static ExpressionOperator trim2()
      INTERNAL: Build Trim operator.

    • trunc

      public static ExpressionOperator trunc()
      INTERNAL: Build operator.

    • truncateDate

      public static ExpressionOperator truncateDate()
      INTERNAL: Build operator.

    • cast

      public static ExpressionOperator cast()
      INTERNAL: Build operator.

    • extract

      public static ExpressionOperator extract()
      INTERNAL: Build operator.

    • value

      public static ExpressionOperator value()
      INTERNAL: Build operator.

    • variance

      public static ExpressionOperator variance()
      INTERNAL: Build operator.

    • any

      public static ExpressionOperator any()
      INTERNAL: Create the ANY operator.

    • some

      public static ExpressionOperator some()
      INTERNAL: Create the SOME operator.

    • all

      public static ExpressionOperator all()
      INTERNAL: Create the ALL operator.

    • union

      public static ExpressionOperator union()
      INTERNAL: Create the UNION operator.

    • unionAll

      public static ExpressionOperator unionAll()
      INTERNAL: Create the UNION ALL operator.

    • intersect

      public static ExpressionOperator intersect()
      INTERNAL: Create the INTERSECT operator.

    • intersectAll

      public static ExpressionOperator intersectAll()
      INTERNAL: Create the INTERSECT ALL operator.

    • except

      public static ExpressionOperator except()
      INTERNAL: Create the EXCEPT operator.

    • exceptAll

      public static ExpressionOperator exceptAll()
      INTERNAL: Create the EXCEPT ALL operator.

    • isAny

      public boolean isAny()
      INTERNAL: Indicates whether operator has selector Any or Some

    • isAll

      public boolean isAll()
      INTERNAL: Indicates whether operator has selector All

    • isAnyOrAll

      public boolean isAnyOrAll()
      INTERNAL: Indicates whether operator has selector Any, Some or All