|
Query |
|
| |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
com.sas.iquery.metadata.serverprop.FunctionNameID
@Immutable public final class FunctionNameID
Defines "constants" that can be used to retrieve specific function definitions from a ServerProperties object.
Not all functions available from a ServerProperties object are defined within this class. And because server properties differ between the type of server that is being accessed, there is no guarantee that a function ID given here is associated with a given function for a particular server being accessed.
Field Summary | |
---|---|
static FunctionNameID |
ADDITION
Name ID for the ADDITION Operation (x)+(y) |
static FunctionNameID |
AND
Name ID for the AND Boolean Operation (x) AND (y) |
static FunctionNameID |
AVG
Name ID for the Function AVG(column-name) |
static FunctionNameID |
AVG_DISTINCT
Name ID for the Function AVG_DISTINCT(column-name) |
static FunctionNameID |
BETWEEN
Name ID for the Function BETWEEN (column-name) |
static FunctionNameID |
CASE_SEARCH
Name ID for the Function CASE WHEN {0} THEN {1} END |
static FunctionNameID |
CASE_SIMPLE
Name ID for the Function CASE {0} WHEN {1} THEN {2} END |
static FunctionNameID |
CASE_WHENTHEN
Name ID for the Function CASE extra clauses of WHEN {0} THEN {1} |
static FunctionNameID |
CONCATENATION
Name ID for the CONCATENATION Operation "x"||"y" |
static FunctionNameID |
CONTAINS
Name ID for the Function CONTAINS (column-name) |
static FunctionNameID |
COUNT
Name ID for the Function COUNT(column-name) |
static FunctionNameID |
COUNT_DISTINCT
Name ID for the Function COUNT_DISTRINT(column-name) |
static FunctionNameID |
COUNT_PLUS_NMISS
Name ID for the Function COUNT_PLUS_NMISS(column-name) |
static FunctionNameID |
COUNT_PLUS_NMISS_DISTINCT
Name ID for the Function COUNT_PLUS_NMISS_DISTINCT (column-name) |
static FunctionNameID |
COUNT_STAR
Name ID for the Function COUNT(*) |
static FunctionNameID |
CSS
Name ID for the Function CSS(column-name) |
static FunctionNameID |
CSS_DISTINCT
Name ID for the Function CSS_DISTINCT(column-name) |
static FunctionNameID |
CV
Name ID for the Function CV(column-name) |
static FunctionNameID |
CV_DISTINCT
Name ID for the Function CV_DISTINCT(column-name) |
static FunctionNameID |
DATE
Name ID for the Function DATE (column-name) |
static FunctionNameID |
DATE_PART
Name ID for the Function DATE_PART (column-name) |
static FunctionNameID |
DATE_TIME
Name ID for the Function DATA_TIME (column-name) |
static FunctionNameID |
DAY
Name ID for the Function DAY (column-name) |
static FunctionNameID |
DIVISION
Name ID for the DIVISION Operation (x)/(y) |
static FunctionNameID |
EQUALS
Name ID for the EQUALS Comparison Operation (x)=(y) |
static FunctionNameID |
EQUALS_TRUNC
Name ID for the EQUALS Comparison Operation (x)=(y) |
static FunctionNameID |
EXPONENTIATION
Name ID for the EXPONENTIATION Operation (x)**(y) |
static FunctionNameID |
FREQ
Name ID for the Function FREQ(column-name) |
static FunctionNameID |
FREQ_DISTINCT
Name ID for the Function FREQ_DISTRINCT(column-name) |
static FunctionNameID |
GREATER_THAN
Name ID for the GREATER_THAN Comparison Operation (x)>(y) |
static FunctionNameID |
GREATER_THAN_OR_EQUALS
Name ID for the GREATER_THAN_OR_EQUALS Comparison Operation |
static FunctionNameID |
GREATER_THAN_OR_EQUALS_TRUNC
Name ID for the GREATER_THAN_OR_EQUALS Comparison Operation |
static FunctionNameID |
GREATER_THAN_TRUNC
Name ID for the GREATER_THAN Comparison Operation (x)>(y) |
static FunctionNameID |
IN
Name ID for the Function IN (column-name) |
static FunctionNameID |
INPUT
Name ID for the Function INPUT(column-name) |
static FunctionNameID |
INPUT_Q
Name ID for the Function INPUT(column-name, |
static FunctionNameID |
INTERNAL_AGGREGATION
Name ID for the Function INTERNAL_AGGREGATION (column-name) |
static FunctionNameID |
INTERNAL_AGGREGATION_ADDITIVE
Name ID for the Function INTERNAL_AGGREGATION_ADDITIVE (column-name) |
static FunctionNameID |
IS_MISSING
Name ID for the IS_MISSING Comparison Operation |
static FunctionNameID |
IS_NOT_MISSING
Name ID for the IS_NOT_MISSING Comparison Operation |
static FunctionNameID |
IS_NOT_NULL
Name ID for the IS_NOT_NULL Comparison Operation |
static FunctionNameID |
IS_NULL
Name ID for the Function IS_NULL (column-name) |
static FunctionNameID |
LEFT
Name ID for the Function LEFT(column-name) |
static FunctionNameID |
LENGTH
Name ID for the Function LENGTH(column-name) |
static FunctionNameID |
LESS_THAN
Name ID for the LESS_THAN Comparison Operation (x)<(y) |
static FunctionNameID |
LESS_THAN_OR_EQUALS
Name ID for the LESS_THAN_OR_EQUALS Comparison Operation (x)<=(y) |
static FunctionNameID |
LESS_THAN_OR_EQUALS_TRUNC
Name ID for the LESS_THAN_OR_EQUALS Comparison Operation (x)<=(y) |
static FunctionNameID |
LESS_THAN_TRUNC
Name ID for the LESS_THAN Comparison Operation (x)<(y) |
static FunctionNameID |
LIKE
Name ID for the Function LIKE (column-name) |
static FunctionNameID |
LIKE_ESC
Name ID for the LIKE_ESC Comparison Operation |
static FunctionNameID |
LOWCASE
Name ID for the Function LOWCASE (column-name) |
static FunctionNameID |
MAX
Name ID for the Function MAX(column-name) |
static FunctionNameID |
MAX_DISTINCT
Name ID for the Function MAX(column-name) |
static FunctionNameID |
MEAN
Name ID for the Function MEAN(column-name) |
static FunctionNameID |
MEAN_DISTINCT
Name ID for the Function MEAN_DISTRINCT(column-name) |
static FunctionNameID |
MIN
Name ID for the Function MIN(column-name) |
static FunctionNameID |
MIN_DISTINCT
Name ID for the Function MIN(column-name) |
static FunctionNameID |
MONTH
Name ID for the Function MONTH (column-name) |
static FunctionNameID |
MULTIPLICATION
Name ID for the MULTIPLICATION Operation (x)*(y) |
static FunctionNameID |
N
Name ID for the Function N(column-name) |
static FunctionNameID |
N_DISTINCT
Name ID for the Function N_DISTRINCT(column-name) |
static FunctionNameID |
NEGATION
Name ID for the NEGATION Operation -(x) |
static FunctionNameID |
NMISS
Name ID for the Function NMISS(column-name) |
static FunctionNameID |
NMISS_DISTINCT
Name ID for the Function NMISS_DISTINCT(column-name) |
static FunctionNameID |
NOT
Name ID for the NOT Boolean Operation NOT (x) |
static FunctionNameID |
NOT_BETWEEN
Name ID for the Function NOT_BETWEEN (column-name) |
static FunctionNameID |
NOT_CONTAINS
Name ID for the Function NOT_CONTAINS (column-name) |
static FunctionNameID |
NOT_EQUALS
Name ID for the NOT_EQUALS Comparison Operation (x)<>(y) |
static FunctionNameID |
NOT_EQUALS_TRUNC
Name ID for the NOT_EQUALS Comparison Operation (x)<>(y) |
static FunctionNameID |
NOT_IN
Name ID for the Function NOT_IN(column-name) |
static FunctionNameID |
NOT_LIKE
Name ID for the NOT_LIKE Comparison Operation |
static FunctionNameID |
NOT_LIKE_ESC
Name ID for the NOT_LIKE_ESC Comparison Operation |
static FunctionNameID |
OR
Name ID for the OR Boolean Operation (x) OR (y) |
static FunctionNameID |
PARENTHESIS
Name ID for the PARENTHESIS Operation '('(x)')' |
static FunctionNameID |
POSTCOMMENT
Name ID for the Post Comment Operation x '/''*' y '*''/' |
static FunctionNameID |
POSTXMLCOMMENT
Name ID for the Post Comment Operation x '<''!'' |
static FunctionNameID |
PRECOMMENT
Name ID for the Pre Comment Operation '/''*' x '*''/' y |
static FunctionNameID |
PREXMLCOMMENT
Name ID for the Pre Comment Operation '<''!'' |
static FunctionNameID |
PRT
Name ID for the Function PRT(column-name) |
static FunctionNameID |
PRT_DISTINCT
Name ID for the Function PRT_DISTINCT(column-name) |
static FunctionNameID |
PUT
Name ID for the Function PUT(column-name) |
static FunctionNameID |
PUT_Q
Name ID for the Function PUT(column-name,? |
static FunctionNameID |
RANGE
Name ID for the Function RANGE(column-name) |
static FunctionNameID |
RANGE_DISTINCT
Name ID for the Function RANGE_DISTINCT(column-name) |
static FunctionNameID |
RIGHT
Name ID for the Function RIGHT (column-name) |
static FunctionNameID |
STD
Name ID for the Function STD(column-name) |
static FunctionNameID |
STD_DISTINCT
Name ID for the Function STD_DISTINCT(column-name) |
static FunctionNameID |
STDERR
Name ID for the Function STDERR(column-name) |
static FunctionNameID |
STDERR_DISTINCT
Name ID for the Function STDERR_DISTINCT(column-name) |
static FunctionNameID |
STRIP
Name ID for the Function STRIP (column-name) |
static FunctionNameID |
SUBTRACTION
Name ID for the SUBTRACTION Operation (x)-(y) |
static FunctionNameID |
SUM
Name ID for the Function SUM(column-name) |
static FunctionNameID |
SUM_DISTINCT
Name ID for the Function SUM_DISTINCT(column-name) |
static FunctionNameID |
T
Name ID for the Function NMISS(column-name) |
static FunctionNameID |
T_DISTINCT
Name ID for the Function NMISS_DISTINCT(column-name) |
static FunctionNameID |
TIME
Name ID for the Function TIME_PART (column-name) |
static FunctionNameID |
TIME_PART
Name ID for the Function TIME_PART (column-name) |
static FunctionNameID |
TODAY
Name ID for the Function TODAY (column-name) |
static FunctionNameID |
TRIM
Name ID for the Function TRIM (column-name) |
static FunctionNameID |
TRIM_N
Name ID for the Function TRIM_N (column-name) |
static FunctionNameID |
UNITY
Name ID for the UNITY Operation +(x) |
static FunctionNameID |
UPCASE
Name ID for the Function UPCASE (column-name) |
static FunctionNameID |
USS
Name ID for the Function NMISS(column-name) |
static FunctionNameID |
USS_DISTINCT
Name ID for the Function NMISS_DISTINCT(column-name) |
static FunctionNameID |
VAR
Name ID for the Function VAR(column-name) |
static FunctionNameID |
VAR_DISTINCT
Name ID for the Function NMISS_DISTINCT(column-name) |
Field Detail |
---|
public static final FunctionNameID AVG
public static final FunctionNameID AVG_DISTINCT
public static final FunctionNameID SUM
public static final FunctionNameID SUM_DISTINCT
public static final FunctionNameID MEAN
public static final FunctionNameID MEAN_DISTINCT
public static final FunctionNameID MIN
public static final FunctionNameID MAX
public static final FunctionNameID FREQ
public static final FunctionNameID FREQ_DISTINCT
public static final FunctionNameID COUNT
public static final FunctionNameID COUNT_STAR
public static final FunctionNameID COUNT_DISTINCT
public static final FunctionNameID N
public static final FunctionNameID N_DISTINCT
public static final FunctionNameID NMISS
public static final FunctionNameID NMISS_DISTINCT
public static final FunctionNameID COUNT_PLUS_NMISS
public static final FunctionNameID COUNT_PLUS_NMISS_DISTINCT
public static final FunctionNameID DATE
public static final FunctionNameID DATE_PART
public static final FunctionNameID DATE_TIME
public static final FunctionNameID DAY
public static final FunctionNameID MONTH
public static final FunctionNameID TIME
public static final FunctionNameID TIME_PART
public static final FunctionNameID TODAY
public static final FunctionNameID LEFT
public static final FunctionNameID LENGTH
public static final FunctionNameID LOWCASE
public static final FunctionNameID PUT
public static final FunctionNameID PUT_Q
public static final FunctionNameID RIGHT
public static final FunctionNameID STRIP
public static final FunctionNameID TRIM
public static final FunctionNameID TRIM_N
public static final FunctionNameID UPCASE
public static final FunctionNameID LIKE
public static final FunctionNameID BETWEEN
public static final FunctionNameID NOT_BETWEEN
public static final FunctionNameID IS_NULL
public static final FunctionNameID IN
public static final FunctionNameID NOT_IN
public static final FunctionNameID CONTAINS
public static final FunctionNameID NOT_CONTAINS
public static final FunctionNameID INTERNAL_AGGREGATION
public static final FunctionNameID INTERNAL_AGGREGATION_ADDITIVE
public static final FunctionNameID MIN_DISTINCT
public static final FunctionNameID MAX_DISTINCT
public static final FunctionNameID INPUT
public static final FunctionNameID INPUT_Q
public static final FunctionNameID NOT_LIKE
public static final FunctionNameID LIKE_ESC
public static final FunctionNameID NOT_LIKE_ESC
public static final FunctionNameID IS_NOT_NULL
public static final FunctionNameID IS_MISSING
public static final FunctionNameID IS_NOT_MISSING
public static final FunctionNameID CV
public static final FunctionNameID CV_DISTINCT
public static final FunctionNameID CSS
public static final FunctionNameID CSS_DISTINCT
public static final FunctionNameID PRT
public static final FunctionNameID PRT_DISTINCT
public static final FunctionNameID RANGE
public static final FunctionNameID RANGE_DISTINCT
public static final FunctionNameID STD
public static final FunctionNameID STD_DISTINCT
public static final FunctionNameID STDERR
public static final FunctionNameID STDERR_DISTINCT
public static final FunctionNameID T
public static final FunctionNameID T_DISTINCT
public static final FunctionNameID USS
public static final FunctionNameID USS_DISTINCT
public static final FunctionNameID VAR
public static final FunctionNameID VAR_DISTINCT
public static final FunctionNameID PRECOMMENT
public static final FunctionNameID POSTCOMMENT
public static final FunctionNameID PREXMLCOMMENT
public static final FunctionNameID POSTXMLCOMMENT
public static final FunctionNameID PARENTHESIS
public static final FunctionNameID EXPONENTIATION
public static final FunctionNameID UNITY
public static final FunctionNameID NEGATION
public static final FunctionNameID ADDITION
public static final FunctionNameID SUBTRACTION
public static final FunctionNameID MULTIPLICATION
public static final FunctionNameID DIVISION
public static final FunctionNameID CONCATENATION
public static final FunctionNameID NOT
public static final FunctionNameID AND
public static final FunctionNameID OR
public static final FunctionNameID EQUALS
public static final FunctionNameID NOT_EQUALS
public static final FunctionNameID LESS_THAN
public static final FunctionNameID LESS_THAN_OR_EQUALS
public static final FunctionNameID GREATER_THAN
public static final FunctionNameID GREATER_THAN_OR_EQUALS
public static final FunctionNameID EQUALS_TRUNC
public static final FunctionNameID NOT_EQUALS_TRUNC
public static final FunctionNameID LESS_THAN_TRUNC
public static final FunctionNameID LESS_THAN_OR_EQUALS_TRUNC
public static final FunctionNameID GREATER_THAN_TRUNC
public static final FunctionNameID GREATER_THAN_OR_EQUALS_TRUNC
public static final FunctionNameID CASE_SIMPLE
public static final FunctionNameID CASE_SEARCH
public static final FunctionNameID CASE_WHENTHEN
|
Query |
|
| |||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |