SourceSystemFunctions (Teiid 8.2.0.Final API)

java.lang.Object
- org.teiid.translator.SourceSystemFunctions

```
public class SourceSystemFunctions
extends 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). Note that not all system functions are listed as some functions will use a common name such as CONCAT vs. the || operator, and other functions will be rewritten and not pushed down, such as SPACE.

Field Summary

Fields
Modifier and Type	Field and Description
`static String`	`ABS`
`static String`	`ACOS`
`static String`	`ADD_OP`
`static String`	`ARRAY_GET`
`static String`	`ARRAY_LENGTH`
`static String`	`ASCII`
`static String`	`ASIN`
`static String`	`ATAN`
`static String`	`ATAN2`
`static String`	`BITAND`
`static String`	`BITNOT`
`static String`	`BITOR`
`static String`	`BITXOR`
`static String`	`CEILING`
`static String`	`CHAR`
`static String`	`COALESCE`
`static String`	`CONCAT`
`static String`	`CONCAT2`
`static String`	`CONVERT`
`static String`	`COS`
`static String`	`COT`
`static String`	`CURDATE`
`static String`	`CURTIME`
`static String`	`DAYNAME`
`static String`	`DAYOFMONTH`
`static String`	`DAYOFWEEK`
`static String`	`DAYOFYEAR`
`static String`	`DEGREES`
`static String`	`DIVIDE_OP`
`static String`	`EXP`
`static String`	`FLOOR`
`static String`	`FORMATBIGDECIMAL`
`static String`	`FORMATBIGINTEGER` Deprecated.
`static String`	`FORMATDOUBLE` Deprecated.
`static String`	`FORMATFLOAT` Deprecated.
`static String`	`FORMATINTEGER` Deprecated.
`static String`	`FORMATLONG` Deprecated.
`static String`	`FORMATTIMESTAMP`
`static String`	`HOUR`
`static String`	`IFNULL`
`static String`	`INITCAP`
`static String`	`INSERT`
`static String`	`JSONTOXML`
`static String`	`LCASE`
`static String`	`LEFT`
`static String`	`LENGTH`
`static String`	`LOCATE`
`static String`	`LOG`
`static String`	`LOG10`
`static String`	`LPAD`
`static String`	`LTRIM`
`static String`	`MINUTE`
`static String`	`MOD`
`static String`	`MODIFYTIMEZONE`
`static String`	`MONTH`
`static String`	`MONTHNAME`
`static String`	`MULTIPLY_OP`
`static String`	`NOW`
`static String`	`NULLIF`
`static String`	`PARSEBIGDECIMAL`
`static String`	`PARSEBIGINTEGER` Deprecated.
`static String`	`PARSEDOUBLE` Deprecated.
`static String`	`PARSEFLOAT` Deprecated.
`static String`	`PARSEINTEGER` Deprecated.
`static String`	`PARSELONG` Deprecated.
`static String`	`PARSETIMESTAMP`
`static String`	`PI`
`static String`	`POWER`
`static String`	`QUARTER`
`static String`	`RADIANS`
`static String`	`RAND`
`static String`	`REPEAT`
`static String`	`REPLACE`
`static String`	`RIGHT`
`static String`	`ROUND`
`static String`	`RPAD`
`static String`	`RTRIM`
`static String`	`SECOND`
`static String`	`SIGN`
`static String`	`SIN`
`static String`	`SQRT`
`static String`	`SUBSTRING`
`static String`	`SUBTRACT_OP`
`static String`	`TAN`
`static String`	`TIMESTAMPADD`
`static String`	`TIMESTAMPCREATE`
`static String`	`TIMESTAMPDIFF`
`static String`	`TO_BYTES`
`static String`	`TO_CHARS`
`static String`	`TRANSLATE`
`static String`	`TRIM` The trim function is only used for a non-space trim character
`static String`	`TRUNCATE`
`static String`	`UCASE`
`static String`	`UNESCAPE`
`static String`	`UUID`
`static String`	`WEEK`
`static String`	`XMLCOMMENT`
`static String`	`XMLCONCAT`
`static String`	`XMLPI`
`static String`	`XPATHVALUE`
`static String`	`XSLTRANSFORM`
`static String`	`YEAR`

Constructor Summary

Constructors
Constructor and Description

SourceSystemFunctions()

Constructors
Constructor and Description
`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 String MULTIPLY_OP
```
See Also:
Constant Field Values

ADD_OP
```
public static final String ADD_OP
```
See Also:
Constant Field Values

SUBTRACT_OP
```
public static final String SUBTRACT_OP
```
See Also:
Constant Field Values

DIVIDE_OP
```
public static final String DIVIDE_OP
```
See Also:
Constant Field Values

ASCII
```
public static final String ASCII
```
See Also:
Constant Field Values

CHAR
```
public static final String CHAR
```
See Also:
Constant Field Values

CONCAT
```
public static final String CONCAT
```
See Also:
Constant Field Values

CONCAT2
```
public static final String CONCAT2
```
See Also:
Constant Field Values

INITCAP
```
public static final String INITCAP
```
See Also:
Constant Field Values

INSERT
```
public static final String INSERT
```
See Also:
Constant Field Values

LCASE
```
public static final String LCASE
```
See Also:
Constant Field Values

LPAD
```
public static final String LPAD
```
See Also:
Constant Field Values

LEFT
```
public static final String LEFT
```
See Also:
Constant Field Values

LENGTH
```
public static final String LENGTH
```
See Also:
Constant Field Values

LOCATE
```
public static final String LOCATE
```
See Also:
Constant Field Values

LTRIM
```
public static final String LTRIM
```
See Also:
Constant Field Values

REPEAT
```
public static final String REPEAT
```
See Also:
Constant Field Values

REPLACE
```
public static final String REPLACE
```
See Also:
Constant Field Values

RIGHT
```
public static final String RIGHT
```
See Also:
Constant Field Values

RPAD
```
public static final String RPAD
```
See Also:
Constant Field Values

RTRIM
```
public static final String RTRIM
```
See Also:
Constant Field Values

SUBSTRING
```
public static final String SUBSTRING
```
See Also:
Constant Field Values

TO_BYTES
```
public static final String TO_BYTES
```
See Also:
Constant Field Values

TO_CHARS
```
public static final String TO_CHARS
```
See Also:
Constant Field Values

TRIM
```
public static final String TRIM
```
The trim function is only used for a non-space trim character

See Also:
Constant Field Values

UCASE
```
public static final String UCASE
```
See Also:
Constant Field Values

UNESCAPE
```
public static final String UNESCAPE
```
See Also:
Constant Field Values

ABS
```
public static final String ABS
```
See Also:
Constant Field Values

ACOS
```
public static final String ACOS
```
See Also:
Constant Field Values

ASIN
```
public static final String ASIN
```
See Also:
Constant Field Values

ATAN
```
public static final String ATAN
```
See Also:
Constant Field Values

ATAN2
```
public static final String ATAN2
```
See Also:
Constant Field Values

CEILING
```
public static final String CEILING
```
See Also:
Constant Field Values

COS
```
public static final String COS
```
See Also:
Constant Field Values

COT
```
public static final String COT
```
See Also:
Constant Field Values

DEGREES
```
public static final String DEGREES
```
See Also:
Constant Field Values

EXP
```
public static final String EXP
```
See Also:
Constant Field Values

FLOOR
```
public static final String FLOOR
```
See Also:
Constant Field Values

FORMATINTEGER

@Deprecated
public static final String FORMATINTEGER

Deprecated.

See Also:: Constant Field Values

FORMATLONG

@Deprecated
public static final String FORMATLONG

Deprecated.

See Also:: Constant Field Values

FORMATDOUBLE

@Deprecated
public static final String FORMATDOUBLE

Deprecated.

See Also:: Constant Field Values

FORMATFLOAT

@Deprecated
public static final String FORMATFLOAT

Deprecated.

See Also:: Constant Field Values

FORMATBIGINTEGER

@Deprecated
public static final String FORMATBIGINTEGER

Deprecated.

See Also:: Constant Field Values

FORMATBIGDECIMAL

public static final String FORMATBIGDECIMAL

See Also:: Constant Field Values

LOG
```
public static final String LOG
```
See Also:
Constant Field Values

LOG10
```
public static final String LOG10
```
See Also:
Constant Field Values

MOD
```
public static final String MOD
```
See Also:
Constant Field Values

PARSEINTEGER

@Deprecated
public static final String PARSEINTEGER

Deprecated.

See Also:: Constant Field Values

PARSELONG

@Deprecated
public static final String PARSELONG

Deprecated.

See Also:: Constant Field Values

PARSEDOUBLE

@Deprecated
public static final String PARSEDOUBLE

Deprecated.

See Also:: Constant Field Values

PARSEFLOAT

@Deprecated
public static final String PARSEFLOAT

Deprecated.

See Also:: Constant Field Values

PARSEBIGINTEGER

@Deprecated
public static final String PARSEBIGINTEGER

Deprecated.

See Also:: Constant Field Values

PARSEBIGDECIMAL

public static final String PARSEBIGDECIMAL

See Also:: Constant Field Values

PI
```
public static final String PI
```
See Also:
Constant Field Values

POWER
```
public static final String POWER
```
See Also:
Constant Field Values

RADIANS
```
public static final String RADIANS
```
See Also:
Constant Field Values

RAND
```
public static final String RAND
```
See Also:
Constant Field Values

ROUND
```
public static final String ROUND
```
See Also:
Constant Field Values

SIGN
```
public static final String SIGN
```
See Also:
Constant Field Values

SIN
```
public static final String SIN
```
See Also:
Constant Field Values

SQRT
```
public static final String SQRT
```
See Also:
Constant Field Values

TAN
```
public static final String TAN
```
See Also:
Constant Field Values

TRANSLATE
```
public static final String TRANSLATE
```
See Also:
Constant Field Values

TRUNCATE
```
public static final String TRUNCATE
```
See Also:
Constant Field Values

BITAND
```
public static final String BITAND
```
See Also:
Constant Field Values

BITOR
```
public static final String BITOR
```
See Also:
Constant Field Values

BITNOT
```
public static final String BITNOT
```
See Also:
Constant Field Values

BITXOR
```
public static final String BITXOR
```
See Also:
Constant Field Values

CURDATE
```
public static final String CURDATE
```
See Also:
Constant Field Values

CURTIME
```
public static final String CURTIME
```
See Also:
Constant Field Values

DAYNAME
```
public static final String DAYNAME
```
See Also:
Constant Field Values

DAYOFMONTH
```
public static final String DAYOFMONTH
```
See Also:
Constant Field Values

DAYOFWEEK
```
public static final String DAYOFWEEK
```
See Also:
Constant Field Values

DAYOFYEAR
```
public static final String DAYOFYEAR
```
See Also:
Constant Field Values

FORMATTIMESTAMP

public static final String FORMATTIMESTAMP

See Also:: Constant Field Values

HOUR
```
public static final String HOUR
```
See Also:
Constant Field Values

MINUTE
```
public static final String MINUTE
```
See Also:
Constant Field Values

MODIFYTIMEZONE

public static final String MODIFYTIMEZONE

See Also:: Constant Field Values

MONTH
```
public static final String MONTH
```
See Also:
Constant Field Values

MONTHNAME
```
public static final String MONTHNAME
```
See Also:
Constant Field Values

NOW
```
public static final String NOW
```
See Also:
Constant Field Values

PARSETIMESTAMP

public static final String PARSETIMESTAMP

See Also:: Constant Field Values

QUARTER
```
public static final String QUARTER
```
See Also:
Constant Field Values

SECOND
```
public static final String SECOND
```
See Also:
Constant Field Values

TIMESTAMPADD

public static final String TIMESTAMPADD

See Also:: Constant Field Values

TIMESTAMPCREATE

public static final String TIMESTAMPCREATE

See Also:: Constant Field Values

TIMESTAMPDIFF

public static final String TIMESTAMPDIFF

See Also:: Constant Field Values

WEEK
```
public static final String WEEK
```
See Also:
Constant Field Values

YEAR
```
public static final String YEAR
```
See Also:
Constant Field Values

IFNULL
```
public static final String IFNULL
```
See Also:
Constant Field Values

COALESCE
```
public static final String COALESCE
```
See Also:
Constant Field Values

NULLIF
```
public static final String NULLIF
```
See Also:
Constant Field Values

ARRAY_GET
```
public static final String ARRAY_GET
```
See Also:
Constant Field Values

ARRAY_LENGTH

public static final String ARRAY_LENGTH

See Also:: Constant Field Values

CONVERT
```
public static final String CONVERT
```
See Also:
Constant Field Values

XPATHVALUE
```
public static final String XPATHVALUE
```
See Also:
Constant Field Values

XSLTRANSFORM

public static final String XSLTRANSFORM

See Also:: Constant Field Values

XMLCONCAT
```
public static final String XMLCONCAT
```
See Also:
Constant Field Values

XMLCOMMENT
```
public static final String XMLCOMMENT
```
See Also:
Constant Field Values

XMLPI
```
public static final String XMLPI
```
See Also:
Constant Field Values

JSONTOXML
```
public static final String JSONTOXML
```
See Also:
Constant Field Values

UUID
```
public static final String UUID
```
See Also:
Constant Field Values

Constructor Detail
- SourceSystemFunctions
```
public SourceSystemFunctions()
```

Class SourceSystemFunctions

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

MULTIPLY_OP

ADD_OP

SUBTRACT_OP

DIVIDE_OP

ASCII

CHAR

CONCAT

CONCAT2

INITCAP

INSERT

LCASE

LPAD

LEFT

LENGTH

LOCATE

LTRIM

REPEAT

REPLACE

RIGHT

RPAD

RTRIM

SUBSTRING

TO_BYTES

TO_CHARS

TRIM

UCASE

UNESCAPE

ABS

ACOS

ASIN

ATAN

ATAN2

CEILING

COS

COT

DEGREES

EXP

FLOOR

FORMATINTEGER

FORMATLONG

FORMATDOUBLE

FORMATFLOAT

FORMATBIGINTEGER

FORMATBIGDECIMAL

LOG

LOG10

MOD

PARSEINTEGER

PARSELONG

PARSEDOUBLE

PARSEFLOAT

PARSEBIGINTEGER

PARSEBIGDECIMAL

PI

POWER

RADIANS

RAND

ROUND

SIGN

SIN

SQRT

TAN

TRANSLATE

TRUNCATE

BITAND

BITOR

BITNOT

BITXOR

CURDATE

CURTIME

DAYNAME

DAYOFMONTH

DAYOFWEEK

DAYOFYEAR