Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

org.teiid.connector.api
Class SourceSystemFunctions

java.lang.Object
  extended by org.teiid.connector.api.SourceSystemFunctions

public class SourceSystemFunctions
extends java.lang.Object

Constants for all the possible standard system push down functions. The names and function forms follow the Open Group CLI functions, with a few exceptions (such as lpad, rpad, bitand, bitor, etc. which are most notably supported by Oracle).

Field Summary
static java.lang.String ABS
           
static java.lang.String ACOS
           
static java.lang.String ADD_OP
           
static java.lang.String ASCII
           
static java.lang.String ASIN
           
static java.lang.String ATAN
           
static java.lang.String ATAN2
           
static java.lang.String BITAND
           
static java.lang.String BITNOT
           
static java.lang.String BITOR
           
static java.lang.String BITXOR
           
static java.lang.String CEILING
           
static java.lang.String CHAR
           
static java.lang.String COALESCE
           
static java.lang.String CONCAT
           
static java.lang.String CONVERT
           
static java.lang.String COS
           
static java.lang.String COT
           
static java.lang.String CURDATE
           
static java.lang.String CURTIME
           
static java.lang.String DAYNAME
           
static java.lang.String DAYOFMONTH
           
static java.lang.String DAYOFWEEK
           
static java.lang.String DAYOFYEAR
           
static java.lang.String DEGREES
           
static java.lang.String DIVIDE_OP
           
static java.lang.String EXP
           
static java.lang.String FLOOR
           
static java.lang.String FORMATBIGDECIMAL
           
static java.lang.String FORMATBIGINTEGER
           
static java.lang.String FORMATDATE
           
static java.lang.String FORMATDOUBLE
           
static java.lang.String FORMATFLOAT
           
static java.lang.String FORMATINTEGER
           
static java.lang.String FORMATLONG
           
static java.lang.String FORMATTIME
           
static java.lang.String FORMATTIMESTAMP
           
static java.lang.String HOUR
           
static java.lang.String IFNULL
           
static java.lang.String INITCAP
           
static java.lang.String INSERT
           
static java.lang.String LCASE
           
static java.lang.String LEFT
           
static java.lang.String LENGTH
           
static java.lang.String LOCATE
           
static java.lang.String LOG
           
static java.lang.String LOG10
           
static java.lang.String LPAD
           
static java.lang.String LTRIM
           
static java.lang.String MINUTE
           
static java.lang.String MOD
           
static java.lang.String MODIFYTIMEZONE
           
static java.lang.String MONTH
           
static java.lang.String MONTHNAME
           
static java.lang.String MULTIPLY_OP
           
static java.lang.String NOW
           
static java.lang.String NULLIF
           
static java.lang.String PARSEBIGDECIMAL
           
static java.lang.String PARSEBIGINTEGER
           
static java.lang.String PARSEDATE
           
static java.lang.String PARSEDOUBLE
           
static java.lang.String PARSEFLOAT
           
static java.lang.String PARSEINTEGER
           
static java.lang.String PARSELONG
           
static java.lang.String PARSETIME
           
static java.lang.String PARSETIMESTAMP
           
static java.lang.String PI
           
static java.lang.String POWER
           
static java.lang.String QUARTER
           
static java.lang.String RADIANS
           
static java.lang.String RAND
           
static java.lang.String REPEAT
           
static java.lang.String REPLACE
           
static java.lang.String RIGHT
           
static java.lang.String ROUND
           
static java.lang.String RPAD
           
static java.lang.String RTRIM
           
static java.lang.String SECOND
           
static java.lang.String SIGN
           
static java.lang.String SIN
           
static java.lang.String SQRT
           
static java.lang.String SUBSTRING
           
static java.lang.String SUBTRACT_OP
           
static java.lang.String TAN
           
static java.lang.String TIMESTAMPADD
           
static java.lang.String TIMESTAMPCREATE
           
static java.lang.String TIMESTAMPDIFF
           
static java.lang.String TRANSLATE
           
static java.lang.String TRUNCATE
           
static java.lang.String UCASE
           
static java.lang.String WEEK
           
static java.lang.String XPATHVALUE
           
static java.lang.String YEAR
           
 
Constructor Summary
SourceSystemFunctions()
           
 
Method Summary
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

MULTIPLY_OP

public static final java.lang.String MULTIPLY_OP
See Also:
Constant Field Values

ADD_OP

public static final java.lang.String ADD_OP
See Also:
Constant Field Values

SUBTRACT_OP

public static final java.lang.String SUBTRACT_OP
See Also:
Constant Field Values

DIVIDE_OP

public static final java.lang.String DIVIDE_OP
See Also:
Constant Field Values

ASCII

public static final java.lang.String ASCII
See Also:
Constant Field Values

CHAR

public static final java.lang.String CHAR
See Also:
Constant Field Values

CONCAT

public static final java.lang.String CONCAT
See Also:
Constant Field Values

INITCAP

public static final java.lang.String INITCAP
See Also:
Constant Field Values

INSERT

public static final java.lang.String INSERT
See Also:
Constant Field Values

LCASE

public static final java.lang.String LCASE
See Also:
Constant Field Values

LPAD

public static final java.lang.String LPAD
See Also:
Constant Field Values

LEFT

public static final java.lang.String LEFT
See Also:
Constant Field Values

LENGTH

public static final java.lang.String LENGTH
See Also:
Constant Field Values

LOCATE

public static final java.lang.String LOCATE
See Also:
Constant Field Values

LTRIM

public static final java.lang.String LTRIM
See Also:
Constant Field Values

REPEAT

public static final java.lang.String REPEAT
See Also:
Constant Field Values

REPLACE

public static final java.lang.String REPLACE
See Also:
Constant Field Values

RIGHT

public static final java.lang.String RIGHT
See Also:
Constant Field Values

RPAD

public static final java.lang.String RPAD
See Also:
Constant Field Values

RTRIM

public static final java.lang.String RTRIM
See Also:
Constant Field Values

SUBSTRING

public static final java.lang.String SUBSTRING
See Also:
Constant Field Values

UCASE

public static final java.lang.String UCASE
See Also:
Constant Field Values

ABS

public static final java.lang.String ABS
See Also:
Constant Field Values

ACOS

public static final java.lang.String ACOS
See Also:
Constant Field Values

ASIN

public static final java.lang.String ASIN
See Also:
Constant Field Values

ATAN

public static final java.lang.String ATAN
See Also:
Constant Field Values

ATAN2

public static final java.lang.String ATAN2
See Also:
Constant Field Values

CEILING

public static final java.lang.String CEILING
See Also:
Constant Field Values

COS

public static final java.lang.String COS
See Also:
Constant Field Values

COT

public static final java.lang.String COT
See Also:
Constant Field Values

DEGREES

public static final java.lang.String DEGREES
See Also:
Constant Field Values

EXP

public static final java.lang.String EXP
See Also:
Constant Field Values

FLOOR

public static final java.lang.String FLOOR
See Also:
Constant Field Values

FORMATINTEGER

public static final java.lang.String FORMATINTEGER
See Also:
Constant Field Values

FORMATLONG

public static final java.lang.String FORMATLONG
See Also:
Constant Field Values

FORMATDOUBLE

public static final java.lang.String FORMATDOUBLE
See Also:
Constant Field Values

FORMATFLOAT

public static final java.lang.String FORMATFLOAT
See Also:
Constant Field Values

FORMATBIGINTEGER

public static final java.lang.String FORMATBIGINTEGER
See Also:
Constant Field Values

FORMATBIGDECIMAL

public static final java.lang.String FORMATBIGDECIMAL
See Also:
Constant Field Values

LOG

public static final java.lang.String LOG
See Also:
Constant Field Values

LOG10

public static final java.lang.String LOG10
See Also:
Constant Field Values

MOD

public static final java.lang.String MOD
See Also:
Constant Field Values

PARSEINTEGER

public static final java.lang.String PARSEINTEGER
See Also:
Constant Field Values

PARSELONG

public static final java.lang.String PARSELONG
See Also:
Constant Field Values

PARSEDOUBLE

public static final java.lang.String PARSEDOUBLE
See Also:
Constant Field Values

PARSEFLOAT

public static final java.lang.String PARSEFLOAT
See Also:
Constant Field Values

PARSEBIGINTEGER

public static final java.lang.String PARSEBIGINTEGER
See Also:
Constant Field Values

PARSEBIGDECIMAL

public static final java.lang.String PARSEBIGDECIMAL
See Also:
Constant Field Values

PI

public static final java.lang.String PI
See Also:
Constant Field Values

POWER

public static final java.lang.String POWER
See Also:
Constant Field Values

RADIANS

public static final java.lang.String RADIANS
See Also:
Constant Field Values

RAND

public static final java.lang.String RAND
See Also:
Constant Field Values

ROUND

public static final java.lang.String ROUND
See Also:
Constant Field Values

SIGN

public static final java.lang.String SIGN
See Also:
Constant Field Values

SIN

public static final java.lang.String SIN
See Also:
Constant Field Values

SQRT

public static final java.lang.String SQRT
See Also:
Constant Field Values

TAN

public static final java.lang.String TAN
See Also:
Constant Field Values

TRANSLATE

public static final java.lang.String TRANSLATE
See Also:
Constant Field Values

TRUNCATE

public static final java.lang.String TRUNCATE
See Also:
Constant Field Values

BITAND

public static final java.lang.String BITAND
See Also:
Constant Field Values

BITOR

public static final java.lang.String BITOR
See Also:
Constant Field Values

BITNOT

public static final java.lang.String BITNOT
See Also:
Constant Field Values

BITXOR

public static final java.lang.String BITXOR
See Also:
Constant Field Values

CURDATE

public static final java.lang.String CURDATE
See Also:
Constant Field Values

CURTIME

public static final java.lang.String CURTIME
See Also:
Constant Field Values

DAYNAME

public static final java.lang.String DAYNAME
See Also:
Constant Field Values

DAYOFMONTH

public static final java.lang.String DAYOFMONTH
See Also:
Constant Field Values

DAYOFWEEK

public static final java.lang.String DAYOFWEEK
See Also:
Constant Field Values

DAYOFYEAR

public static final java.lang.String DAYOFYEAR
See Also:
Constant Field Values

FORMATDATE

public static final java.lang.String FORMATDATE
See Also:
Constant Field Values

FORMATTIME

public static final java.lang.String FORMATTIME
See Also:
Constant Field Values

FORMATTIMESTAMP

public static final java.lang.String FORMATTIMESTAMP
See Also:
Constant Field Values

HOUR

public static final java.lang.String HOUR
See Also:
Constant Field Values

MINUTE

public static final java.lang.String MINUTE
See Also:
Constant Field Values

MODIFYTIMEZONE

public static final java.lang.String MODIFYTIMEZONE
See Also:
Constant Field Values

MONTH

public static final java.lang.String MONTH
See Also:
Constant Field Values

MONTHNAME

public static final java.lang.String MONTHNAME
See Also:
Constant Field Values

NOW

public static final java.lang.String NOW
See Also:
Constant Field Values

PARSEDATE

public static final java.lang.String PARSEDATE
See Also:
Constant Field Values

PARSETIME

public static final java.lang.String PARSETIME
See Also:
Constant Field Values

PARSETIMESTAMP

public static final java.lang.String PARSETIMESTAMP
See Also:
Constant Field Values

QUARTER

public static final java.lang.String QUARTER
See Also:
Constant Field Values

SECOND

public static final java.lang.String SECOND
See Also:
Constant Field Values

TIMESTAMPADD

public static final java.lang.String TIMESTAMPADD
See Also:
Constant Field Values

TIMESTAMPCREATE

public static final java.lang.String TIMESTAMPCREATE
See Also:
Constant Field Values

TIMESTAMPDIFF

public static final java.lang.String TIMESTAMPDIFF
See Also:
Constant Field Values

WEEK

public static final java.lang.String WEEK
See Also:
Constant Field Values

YEAR

public static final java.lang.String YEAR
See Also:
Constant Field Values

IFNULL

public static final java.lang.String IFNULL
See Also:
Constant Field Values

COALESCE

public static final java.lang.String COALESCE
See Also:
Constant Field Values

NULLIF

public static final java.lang.String NULLIF
See Also:
Constant Field Values

CONVERT

public static final java.lang.String CONVERT
See Also:
Constant Field Values

XPATHVALUE

public static final java.lang.String XPATHVALUE
See Also:
Constant Field Values
Constructor Detail

SourceSystemFunctions

public SourceSystemFunctions()
Overview  Package   Class  Use  Tree  Deprecated  Index  Help 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD
Copyright © 2009. All Rights Reserved.