SAS Query Services: Class FunctionNameID

All Libraries

This Library

Package

Class

Use

Tree

Deprecated

Index

Grand Index

Help

Query

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: INNER | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

*** This class is subject to change ***

com.sas.iquery.metadata.serverprop
Class FunctionNameID

java.lang.Object
  |
  +--com.sas.iquery.metadata.serverprop.FunctionNameID

public class FunctionNameID
extends Object

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 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 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 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 FREQ
          Name ID for the Function FREQ(column-name)

static FunctionNameID FREQ_DISTINCT
          Name ID for the Function FREQ_DISTRINCT(column-name)

static FunctionNameID IN
          Name ID for the Function IN (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_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 LIKE
          Name ID for the Function LIKE (column-name)

static FunctionNameID LOWCASE
          Name ID for the Function LOWCASE (column-name)

static FunctionNameID MAX
          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 MONTH
          Name ID for the Function MONTH (column-name)

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 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_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_IN
          Name ID for the Function NOT_IN(column-name)

static FunctionNameID PUT
          Name ID for the Function PUT(column-name)

static FunctionNameID RIGHT
          Name ID for the Function RIGHT (column-name)

static FunctionNameID STRIP
          Name ID for the Function STRIP (column-name)

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 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 UPCASE
          Name ID for the Function UPCASE (column-name)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

AVG

public static final FunctionNameID AVG

Name ID for the Function AVG(column-name)

AVG_DISTINCT

public static final FunctionNameID AVG_DISTINCT

Name ID for the Function AVG_DISTINCT(column-name)

SUM

public static final FunctionNameID SUM

Name ID for the Function SUM(column-name)

SUM_DISTINCT

public static final FunctionNameID SUM_DISTINCT

Name ID for the Function SUM_DISTINCT(column-name)

MEAN

public static final FunctionNameID MEAN

Name ID for the Function MEAN(column-name)

MEAN_DISTINCT

public static final FunctionNameID MEAN_DISTINCT

Name ID for the Function MEAN_DISTRINCT(column-name)

MIN

public static final FunctionNameID MIN

Name ID for the Function MIN(column-name)

MAX

public static final FunctionNameID MAX

Name ID for the Function MAX(column-name)

FREQ

public static final FunctionNameID FREQ

Name ID for the Function FREQ(column-name)

FREQ_DISTINCT

public static final FunctionNameID FREQ_DISTINCT

Name ID for the Function FREQ_DISTRINCT(column-name)

COUNT

public static final FunctionNameID COUNT

Name ID for the Function COUNT(column-name)

COUNT_STAR

public static final FunctionNameID COUNT_STAR

Name ID for the Function COUNT(*)

COUNT_DISTINCT

public static final FunctionNameID COUNT_DISTINCT

Name ID for the Function COUNT_DISTRINT(column-name)

N

public static final FunctionNameID N

Name ID for the Function N(column-name)

N_DISTINCT

public static final FunctionNameID N_DISTINCT

Name ID for the Function N_DISTRINCT(column-name)

NMISS

public static final FunctionNameID NMISS

Name ID for the Function NMISS(column-name)

NMISS_DISTINCT

public static final FunctionNameID NMISS_DISTINCT

Name ID for the Function NMISS_DISTINCT(column-name)

COUNT_PLUS_NMISS

public static final FunctionNameID COUNT_PLUS_NMISS

Name ID for the Function COUNT_PLUS_NMISS(column-name)

COUNT_PLUS_NMISS_DISTINCT

public static final FunctionNameID COUNT_PLUS_NMISS_DISTINCT

Name ID for the Function COUNT_PLUS_NMISS_DISTINCT (column-name)

DATE

public static final FunctionNameID DATE

Name ID for the Function DATE (column-name)

DATE_PART

public static final FunctionNameID DATE_PART

Name ID for the Function DATE_PART (column-name)

DATE_TIME

public static final FunctionNameID DATE_TIME

Name ID for the Function DATA_TIME (column-name)

DAY

public static final FunctionNameID DAY

Name ID for the Function DAY (column-name)

MONTH

public static final FunctionNameID MONTH

Name ID for the Function MONTH (column-name)

TIME

public static final FunctionNameID TIME

Name ID for the Function TIME_PART (column-name)

TIME_PART

public static final FunctionNameID TIME_PART

Name ID for the Function TIME_PART (column-name)

TODAY

public static final FunctionNameID TODAY

Name ID for the Function TODAY (column-name)

LEFT

public static final FunctionNameID LEFT

Name ID for the Function LEFT(column-name)

LENGTH

public static final FunctionNameID LENGTH

Name ID for the Function LENGTH(column-name)

LOWCASE

public static final FunctionNameID LOWCASE

Name ID for the Function LOWCASE (column-name)

PUT

public static final FunctionNameID PUT

Name ID for the Function PUT(column-name)

RIGHT

public static final FunctionNameID RIGHT

Name ID for the Function RIGHT (column-name)

STRIP

public static final FunctionNameID STRIP

Name ID for the Function STRIP (column-name)

TRIM

public static final FunctionNameID TRIM

Name ID for the Function TRIM (column-name)

TRIM_N

public static final FunctionNameID TRIM_N

Name ID for the Function TRIM_N (column-name)

UPCASE

public static final FunctionNameID UPCASE

Name ID for the Function UPCASE (column-name)

LIKE

public static final FunctionNameID LIKE

Name ID for the Function LIKE (column-name)

BETWEEN

public static final FunctionNameID BETWEEN

Name ID for the Function BETWEEN (column-name)

NOT_BETWEEN

public static final FunctionNameID NOT_BETWEEN

Name ID for the Function NOT_BETWEEN (column-name)

IS_NULL

public static final FunctionNameID IS_NULL

Name ID for the Function IS_NULL (column-name)

IN

public static final FunctionNameID IN

Name ID for the Function IN (column-name)

NOT_IN

public static final FunctionNameID NOT_IN

Name ID for the Function NOT_IN(column-name)

CONTAINS

public static final FunctionNameID CONTAINS

Name ID for the Function CONTAINS (column-name)

NOT_CONTAINS

public static final FunctionNameID NOT_CONTAINS

Name ID for the Function NOT_CONTAINS (column-name)

INTERNAL_AGGREGATION

public static final FunctionNameID INTERNAL_AGGREGATION

Name ID for the Function INTERNAL_AGGREGATION (column-name)

INTERNAL_AGGREGATION_ADDITIVE

public static final FunctionNameID INTERNAL_AGGREGATION_ADDITIVE

Name ID for the Function INTERNAL_AGGREGATION_ADDITIVE (column-name)