Integrate Software AG Products Using Digital Event Services 10.4 | Integrate Software AG Products Using Digital Event Services | MashZone NextGen Help | Appendix | Legacy Presto components | MashZone NextGen Analytics | RAQL Queries | RAQL Query Syntax Reference
 
RAQL Query Syntax Reference
This topic contains syntax definitions and corresponding syntax diagrams for the Real-Time Analytics Query Language (RAQL) in MashZone NextGen.
ExplainOrSelectStatement
CharacterConstantSelectStatement rectCharacterConstant rectSelectStatement
Definition:
ExplainOrSelectStatement
::= ( 'EXPLAIN' ( '(' CharacterConstant ')' )? )? SelectStatement
Used In:
This is the starting definition of RAQL queries, which has no parent references.
CharacterConstant
S_CHAR_LITERALS_PARAMETER rectS_CHAR_LITERAL rectS_PARAMETER
Definition:
CharacterConstant
::= S_CHAR_LITERAL
| S_PARAMETER
Used In:
*ExplainOrSelectStatement
SelectStatement
SelectWithOrder rectSelectWithOrder
Definition:
SelectStatement
::= SelectWithOrder ';'?
Used In:
*ExplainOrSelectStatement
SelectWithOrder
QueryExpressionBodyOrderByClauseLimitClause rectQueryExpressionBody rectOrderByClause rectLimitClause
Definition:
SelectWithOrder
::= QueryExpressionBody OrderByClause? LimitClause?
Used In:
*SelectStatement
*SourceReferenceOrSubquery
QueryExpressionBody
QueryTerm rectQueryTerm
Definition:
QueryExpressionBody
::= QueryTerm ( ( 'UNION' | 'EXCEPT' | 'MINUS' ) ( 'ALL' | 'DISTINCT' )? QueryTerm )*
Used In:
*QueryPrimary
*SelectWithOrder
*SqlRelationalOperatorExpression
QueryTerm
QueryPrimary rectQueryPrimary
Definition:
QueryTerm
::= QueryPrimary ( 'INTERSECT' ( 'ALL' | 'DISTINCT' )? QueryPrimary )*
Used In:
*QueryExpressionBody
QueryPrimary
SelectWithoutOrderQueryExpressionBody rectSelectWithoutOrder rectQueryExpressionBody
Definition:
QueryPrimary
::= SelectWithoutOrder
| '(' QueryExpressionBody ')'
Used In:
*QueryTerm
SelectWithoutOrder
SelectListFromClauseWhereClauseGroupByClauseHavingClause rectSelectList rectFromClause rectWhereClause rectGroupByClause rectHavingClause
Definition:
SelectWithoutOrder
::= 'SELECT' ( 'ALL' | 'DISTINCT' )? SelectList FromClause WhereClause? GroupByClause? HavingClause?
Used In:
*QueryPrimary
SelectList
SelectItem rectSelectItem
Definition:
SelectList
::= SelectItem ( ',' SelectItem )*
Used In:
*SelectWithoutOrder
SelectItem
SelectStarSqlSimpleExpressionAlias rectSelectStar rectSqlSimpleExpression rectAlias
Definition:
SelectItem
::= '*'
| SelectStar
| SqlSimpleExpression Alias?
Used In:
*SelectList
SelectStar
ObjectNameObjectName rectObjectName rectObjectName
Definition:
SelectStar
::= ObjectName '.' ( ObjectName '.' )? '*'
Used In:
*SelectItem
ObjectName
S_IDENTIFIERS_QUOTED_IDENTIFIER rectS_IDENTIFIER rectS_QUOTED_IDENTIFIER
Definition:
ObjectName
::= S_IDENTIFIER
| S_QUOTED_IDENTIFIER
Used In:
*Alias
*GenericFunctionCall
*SelectStar
*SourceField
*SourceReference
*SqlPrimaryExpression
SqlSimpleExpression
SqlMultiplicativeExpression rectSqlMultiplicativeExpression
Definition:
SqlSimpleExpression
::= SqlMultiplicativeExpression ( ( '+' | '-' | '||' ) SqlMultiplicativeExpression )*
Used In:
*BooleanCaseCall
*SelectItem
*SimpleCaseCall
*SqlBetweenClause
*SqlLikeClause
*SqlRelationalExpression
*SqlRelationalOperatorExpression
SqlMultiplicativeExpression
SqlExponentExpression rectSqlExponentExpression
Definition:
SqlMultiplicativeExpression
::= SqlExponentExpression ( ( '*' | '/' | '%' ) SqlExponentExpression )*
Used In:
*SqlSimpleExpression
SqlExponentExpression
SqlUnaryExpression rectSqlUnaryExpression
Definition:
SqlExponentExpression
::= SqlUnaryExpression ( '**' SqlUnaryExpression )*
Used In:
*SqlMultiplicativeExpression
SqlUnaryExpression
SqlPrimaryExpression rectSqlPrimaryExpression
Definition:
SqlUnaryExpression
::= ( '+' | '-' )? SqlPrimaryExpression
Used In:
*SqlExponentExpression
SqlPrimaryExpression
SqlExpressionConstantFunctionCallAggregateFunctionCallGenericFunctionCallWindowSpecificationGroupingOperationWindowFunctionCallObjectNameGenericFunctionCallWindowSpecificationObjectNameObjectNameArrayElementReferenceArrayElementReferenceArrayValueConstructor rectSqlExpression rectConstant rectFunctionCall rectAggregateFunctionCall rectGenericFunctionCall rectWindowSpecification rectGroupingOperation rectWindowFunctionCall rectObjectName rectGenericFunctionCall rectWindowSpecification rectObjectName rectObjectName rectArrayElementReference rectArrayElementReference rectArrayValueConstructor
Definition:
SqlPrimaryExpression
::= '(' SqlExpression ')'
| Constant
| FunctionCall
| ( AggregateFunctionCall | GenericFunctionCall ) WindowSpecification?
| GroupingOperation
| WindowFunctionCall
| ObjectName ( '.' ( GenericFunctionCall WindowSpecification? | ObjectName ( '.' ObjectName )? ArrayElementReference? ) | ArrayElementReference )?
| ArrayValueConstructor
Used In:
*SqlUnaryExpression
SqlExpression
SqlAndExpression rectSqlAndExpression
Definition:
SqlExpression
::= SqlAndExpression ( 'OR' SqlAndExpression )*
Used In:
*AggregateFunctionCall
*BooleanCaseCall
*FunctionCall
*GroupingExpressionReference
*HavingClause
*JoinedTable
*OrderByClause
*SqlExpressionList
*SqlPrimaryExpression
*WhereClause
*WindowFunctionCall
SqlAndExpression
SqlUnaryLogicalExpression rectSqlUnaryLogicalExpression
Definition:
SqlAndExpression
::= SqlUnaryLogicalExpression ( 'AND' SqlUnaryLogicalExpression )*
Used In:
*SqlExpression
SqlUnaryLogicalExpression
SqlRelationalExpression rectSqlRelationalExpression
Definition:
SqlUnaryLogicalExpression
::= 'NOT'? SqlRelationalExpression
Used In:
*SqlAndExpression
SqlRelationalExpression
SqlExpressionListSqlSimpleExpressionSqlRelationalOperatorExpressionSqlInClauseSqlBetweenClauseSqlLikeClauseIsNullClause rectSqlExpressionList rectSqlSimpleExpression rectSqlRelationalOperatorExpression rectSqlInClause rectSqlBetweenClause rectSqlLikeClause rectIsNullClause
Definition:
SqlRelationalExpression
::= ( '(' SqlExpressionList ')' | SqlSimpleExpression ) ( SqlRelationalOperatorExpression | SqlInClause | SqlBetweenClause | SqlLikeClause | IsNullClause )?
Used In:
*SqlUnaryLogicalExpression
SqlExpressionList
SqlExpression rectSqlExpression
Definition:
SqlExpressionList
::= SqlExpression ( ',' SqlExpression )*
Used In:
*ArrayValueConstructor
*GenericFunctionCall
*GroupingOperation
*SqlInClause
*SqlRelationalExpression
*WindowSpecification
SqlRelationalOperatorExpression
RelopQueryExpressionBodySqlSimpleExpression rectRelop rectQueryExpressionBody rectSqlSimpleExpression
Definition:
SqlRelationalOperatorExpression
::= Relop ( '(' QueryExpressionBody ')' | SqlSimpleExpression )
Used In:
*SqlRelationalExpression
Relop
Definition:
Relop ::= '='
| '!='
| '#'
| '<>'
| '>'
| '>='
| '<'
| '<='
Used In:
*SqlRelationalOperatorExpression
SqlInClause
SqlExpressionList rectSqlExpressionList
Definition:
SqlInClause
::= 'NOT'? 'IN' '(' SqlExpressionList ')'
Used In:
*SqlRelationalExpression
SqlBetweenClause
SqlSimpleExpressionSqlSimpleExpression rectSqlSimpleExpression rectSqlSimpleExpression
Definition:
SqlBetweenClause
::= 'NOT'? 'BETWEEN' SqlSimpleExpression 'AND' SqlSimpleExpression
Used In:
*SqlRelationalExpression
SqlLikeClause
SqlSimpleExpression rectSqlSimpleExpression
Definition:
SqlLikeClause
::= 'NOT'? 'LIKE' SqlSimpleExpression
Used In:
*SqlRelationalExpression
IsNullClause
Definition:
IsNullClause
::= 'IS' 'NOT'? 'NULL'
Used In:
*SqlRelationalExpression
Constant
S_NUMBERS_CHAR_LITERALS_PARAMETER rectS_NUMBER rectS_CHAR_LITERAL rectS_PARAMETER
Definition:
Constant ::= 'NULL'
| ( '+' | '-' )? S_NUMBER
| S_CHAR_LITERAL
| 'TRUE'
| 'FALSE'
| S_PARAMETER
Used In:
*ConstantList
*SqlPrimaryExpression
*WindowFunctionCall
FunctionCall
SqlExpressionSqlExpressionSqlExpressionSqlExpressionSqlExpressionSqlExpressionSqlExpressionCastableDataTypeDeclarationSimpleCaseCallBooleanCaseCall rectSqlExpression rectSqlExpression rectSqlExpression rectSqlExpression rectSqlExpression rectSqlExpression rectSqlExpression rectCastableDataTypeDeclaration rectSimpleCaseCall rectBooleanCaseCall
Definition:
FunctionCall
::= ( ( ( 'ABS' | 'CEIL' | 'CEILING' | 'CHAR_LENGTH' | 'CHARACTER_LENGTH' | 'EXP' | 'FLOOR' | 'LN' | 'LOWER' | 'SQRT' | 'UPPER' ) '(' | ( 'MOD' | 'POWER' ) '(' SqlExpression ',' | 'TRIM' '(' ( ( 'LEADING' | 'TRAILING' | 'BOTH' )? SqlExpression? 'FROM' )? | 'SUBSTRING' '(' SqlExpression 'FROM' ( SqlExpression 'FOR' )? | ( 'ROUND' | 'TRUNC' | 'TRUNCATE' ) '(' ( SqlExpression ',' )? ) SqlExpression | 'CAST' '(' SqlExpression 'AS' CastableDataTypeDeclaration ) ')'
| 'CASE' ( SimpleCaseCall | BooleanCaseCall )
Used In:
*SqlPrimaryExpression
CastableDataTypeDeclaration
UserDefinedType rectUserDefinedType
Definition:
CastableDataTypeDeclaration
::= ( 'BIG_DECIMAL' | 'BYTE' | 'INTEGER' | 'FLOAT' | 'LONG' | 'SHORT' | 'DOUBLE' | 'CHARACTER' | 'STRING' | 'SQL_DATE' | 'SQL_TIMESTAMP' | 'SQL_TIME' | 'DATE' | 'BOOLEAN' | 'BLOB' | 'CLOB' | 'REF' | 'STRUCT' | 'UNKNOWN' | UserDefinedType ) 'ARRAY'?
Used In:
*FunctionCall
UserDefinedType
S_IDENTIFIERS_IDENTIFIER rectS_IDENTIFIER rectS_IDENTIFIER
Definition:
UserDefinedType
::= S_IDENTIFIER ( '.' S_IDENTIFIER )?
Used In:
*CastableDataTypeDeclaration
SimpleCaseCall
SqlSimpleExpressionSqlSimpleExpressionSqlSimpleExpressionSqlSimpleExpression rectSqlSimpleExpression rectSqlSimpleExpression rectSqlSimpleExpression rectSqlSimpleExpression
Definition:
SimpleCaseCall
::= SqlSimpleExpression ( 'WHEN' SqlSimpleExpression 'THEN' SqlSimpleExpression )+ ( 'ELSE' SqlSimpleExpression )? 'END'
Used In:
*FunctionCall
BooleanCaseCall
SqlExpressionSqlSimpleExpressionSqlSimpleExpression rectSqlExpression rectSqlSimpleExpression rectSqlSimpleExpression
Definition:
BooleanCaseCall
::= ( 'WHEN' SqlExpression 'THEN' SqlSimpleExpression )+ ( 'ELSE' SqlSimpleExpression )? 'END'
Used In:
*FunctionCall
AggregateFunctionCall
SourceFieldSqlExpressionSourceFieldSqlExpressionSqlExpressionSourceFieldSqlExpressionSourceField rectSourceField rectSqlExpression rectSourceField rectSqlExpression rectSqlExpression rectSourceField rectSqlExpression rectSourceField
Definition:
AggregateFunctionCall
::= ( ( 'AVG' | 'MAX' | 'MIN' | 'STDDEV_POP' | 'STDDEV' | 'STDDEV_SAMP' | 'SUM' | 'VAR_POP' | 'VARIANCE' | 'VAR_SAMP' ) '(' ( ( 'ALL' | 'DISTINCT' ) SourceField | SqlExpression ) | 'COUNT' '(' ( '*' | ( 'ALL' | 'DISTINCT' ) SourceField | SqlExpression ) | ( 'CORR' | 'COVAR_POP' | 'COVAR_SAMP' | 'COVAR' | 'REGR_INTERCEPT' | 'REGR_R2' | 'REGR_SLOPE' ) '(' ( SqlExpression | SourceField ) ',' ( SqlExpression | SourceField ) ) ')'
Used In:
*SqlPrimaryExpression
SourceField
ObjectNameObjectNameObjectName rectObjectName rectObjectName rectObjectName
Definition:
SourceField
::= ObjectName ( '.' ObjectName ( '.' ObjectName )? )?
Used In:
*AggregateFunctionCall
*SourceFieldList
*WindowFunctionCall
GenericFunctionCall
ObjectNameSqlExpressionListConstantList rectObjectName rectSqlExpressionList rectConstantList
Definition:
GenericFunctionCall
::= ObjectName '(' SqlExpressionList? ( ';' ConstantList )? ')'
Used In:
*SqlPrimaryExpression
ConstantList
Constant rectConstant
Definition:
ConstantList
::= Constant ( ',' Constant )*
Used In:
*GenericFunctionCall
WindowSpecification
SqlExpressionListOrderByClauseWindowFrameClause rectSqlExpressionList rectOrderByClause rectWindowFrameClause
Definition:
WindowSpecification
::= 'OVER' '(' ( 'PARTITION' 'BY' SqlExpressionList )? OrderByClause? WindowFrameClause? ')'
Used In:
*SqlPrimaryExpression
*WindowFunctionCall
OrderByClause
SqlExpression rectSqlExpression
Definition:
OrderByClause
::= 'ORDER' 'BY' SqlExpression ( 'ASC' | 'DESC' )? ( 'NULLS' ( 'FIRST' | 'LAST' ) )? ( ',' SqlExpression ( 'ASC' | 'DESC' )? ( 'NULLS' ( 'FIRST' | 'LAST' ) )? )*
Used In:
*SelectWithOrder
*WindowSpecification
WindowFrameClause
WindowFrameStartWindowFrameBoundWindowFrameBound rectWindowFrameStart rectWindowFrameBound rectWindowFrameBound
Definition:
WindowFrameClause
::= ( 'ROWS' | 'RANGE' ) ( WindowFrameStart | 'BETWEEN' WindowFrameBound 'AND' WindowFrameBound )
Used In:
*WindowSpecification
WindowFrameStart
FrameBound rectFrameBound
Definition:
WindowFrameStart
::= ( 'UNBOUNDED' | FrameBound ) 'PRECEDING'
| 'CURRENT' 'ROW'
Used In:
*WindowFrameBound
*WindowFrameClause
FrameBound
S_NUMBERS_PARAMETER rectS_NUMBER rectS_PARAMETER
Definition:
FrameBound
::= S_NUMBER
| S_PARAMETER
Used In:
*WindowFrameBound
*WindowFrameStart
WindowFrameBound
FrameBoundWindowFrameStart rectFrameBound rectWindowFrameStart
Definition:
WindowFrameBound
::= ( 'UNBOUNDED' | FrameBound ) 'FOLLOWING'
| WindowFrameStart
Used In:
*WindowFrameClause
GroupingOperation
SqlExpressionList rectSqlExpressionList
Definition:
GroupingOperation
::= 'GROUPING' '(' SqlExpressionList ')'
Used In:
*SqlPrimaryExpression
WindowFunctionCall
LongConstantSqlExpressionSourceFieldIntegerConstantConstantSqlExpressionSourceFieldSqlExpressionSourceFieldIntegerConstantConstantWindowSpecification rectLongConstant rectSqlExpression rectSourceField rectIntegerConstant rectConstant rectSqlExpression rectSourceField rectSqlExpression rectSourceField rectIntegerConstant rectConstant rectWindowSpecification
Definition:
WindowFunctionCall
::= ( ( 'RANK' | 'DENSE_RANK' | 'PERCENT_RANK' | 'CUME_DIST' | 'ROW_NUMBER' ) '(' | 'NTILE' '(' LongConstant | ( 'LEAD' | 'LAG' ) '(' ( SqlExpression | SourceField ) ( ',' IntegerConstant ( ',' Constant )? )? | ( ( 'FIRST_VALUE' | 'LAST_VALUE' ) '(' ( SqlExpression | SourceField ) | 'NTH_VALUE' '(' ( SqlExpression | SourceField ) ',' IntegerConstant ) ( ',' Constant )? ) ')' WindowSpecification
Used In:
*SqlPrimaryExpression
LongConstant
S_NUMBERS_PARAMETER rectS_NUMBER rectS_PARAMETER
Definition:
LongConstant
::= S_NUMBER
| S_PARAMETER
Used In:
*LimitClause
*WindowFunctionCall
IntegerConstant
S_NUMBERS_PARAMETER rectS_NUMBER rectS_PARAMETER
Definition:
IntegerConstant
::= S_NUMBER
| S_PARAMETER
Used In:
*ArrayElementReference
*WindowFunctionCall
ArrayElementReference
IntegerConstant rectIntegerConstant
Definition:
ArrayElementReference
::= '[' IntegerConstant ']'
Used In:
*SqlPrimaryExpression
ArrayValueConstructor
SqlExpressionList rectSqlExpressionList
Definition:
ArrayValueConstructor
::= 'ARRAY' '[' SqlExpressionList ']'
Used In:
*SqlPrimaryExpression
Alias
ObjectName rectObjectName
Definition:
Alias ::= 'AS'? ObjectName
Used In:
*SelectItem
*SourceReferenceOrSubquery
FromClause
FromItem rectFromItem
Definition:
FromClause
::= 'FROM' FromItem ( ',' FromItem )*
Used In:
*SelectWithoutOrder
FromItem
SourceReferenceOrSubqueryJoinedTable rectSourceReferenceOrSubquery rectJoinedTable
Definition:
FromItem ::= SourceReferenceOrSubquery JoinedTable*
Used In:
*FromClause
SourceReferenceOrSubquery
SourceReferenceSelectWithOrderAlias rectSourceReference rectSelectWithOrder rectAlias
Definition:
SourceReferenceOrSubquery
::= ( SourceReference | '(' SelectWithOrder ')' ) Alias?
Used In:
*FromItem
*JoinedTable
SourceReference
ObjectNameObjectName rectObjectName rectObjectName
Definition:
SourceReference
::= ObjectName ( '.' ObjectName )? ( '/' ObjectName ( '.' ObjectName )? )*
Used In:
*SourceReferenceOrSubquery
JoinedTable
SourceReferenceOrSubquerySourceReferenceOrSubquerySqlExpressionSourceFieldList rectSourceReferenceOrSubquery rectSourceReferenceOrSubquery rectSqlExpression rectSourceFieldList
Definition:
JoinedTable
::= ( 'CROSS' | 'NATURAL' ( 'INNER' | ( 'LEFT' | 'RIGHT' | 'FULL' ) 'OUTER'? )? ) 'JOIN' SourceReferenceOrSubquery
| ( 'INNER' | ( 'LEFT' | 'RIGHT' | 'FULL' ) 'OUTER'? )? 'JOIN' SourceReferenceOrSubquery ( 'ON' SqlExpression | 'USING' '(' SourceFieldList ')' )?
Used In:
*FromItem
SourceFieldList
SourceField rectSourceField
Definition:
SourceFieldList
::= SourceField ( ',' SourceField )*
Used In:
*JoinedTable
WhereClause
SqlExpression rectSqlExpression
Definition:
WhereClause
::= 'WHERE' SqlExpression
Used In:
*SelectWithoutOrder
GroupByClause
GroupingElementList rectGroupingElementList
Definition:
GroupByClause
::= 'GROUP' 'BY' ( 'ALL' | 'DISTINCT' )? GroupingElementList
Used In:
*SelectWithoutOrder
GroupingElementList
GroupingElement rectGroupingElement
Definition:
GroupingElementList
::= GroupingElement ( ',' GroupingElement )*
Used In:
*GroupByClause
GroupingElement
EmptyGroupingSetOrdinaryGroupingSetRollupListCubeListGroupingSetsSpecification rectEmptyGroupingSet rectOrdinaryGroupingSet rectRollupList rectCubeList rectGroupingSetsSpecification
Definition:
GroupingElement
::= EmptyGroupingSet
| OrdinaryGroupingSet
| RollupList
| CubeList
| GroupingSetsSpecification
Used In:
*GroupingElementList
EmptyGroupingSet
Definition:
EmptyGroupingSet
::= '(' ')'
Used In:
*GroupingElement
*GroupingSet
OrdinaryGroupingSet
GroupingExpressionReferenceListGroupingExpressionReference rectGroupingExpressionReferenceList rectGroupingExpressionReference
Definition:
OrdinaryGroupingSet
::= '(' GroupingExpressionReferenceList ')'
| GroupingExpressionReference
Used In:
*GroupingElement
*GroupingSet
*OrdinaryGroupingSetList
GroupingExpressionReferenceList
GroupingExpressionReference rectGroupingExpressionReference
Definition:
GroupingExpressionReferenceList
::= GroupingExpressionReference ( ',' GroupingExpressionReference )*
Used In:
*OrdinaryGroupingSet
GroupingExpressionReference
SqlExpression rectSqlExpression
Definition:
GroupingExpressionReference
::= SqlExpression
Used In:
*GroupingExpressionReferenceList
*OrdinaryGroupingSet
RollupList
OrdinaryGroupingSetList rectOrdinaryGroupingSetList
Definition:
RollupList
::= 'ROLLUP' '(' OrdinaryGroupingSetList ')'
Used In:
*GroupingElement
*GroupingSet
OrdinaryGroupingSetList
OrdinaryGroupingSet rectOrdinaryGroupingSet
Definition:
OrdinaryGroupingSetList
::= OrdinaryGroupingSet ( ',' OrdinaryGroupingSet )*
Used In:
*CubeList
*RollupList
CubeList
OrdinaryGroupingSetList rectOrdinaryGroupingSetList
Definition:
CubeList ::= 'CUBE' '(' OrdinaryGroupingSetList ')'
Used In:
*GroupingElement
*GroupingSet
GroupingSetsSpecification
GroupingSetList rectGroupingSetList
Definition:
GroupingSetsSpecification
::= 'GROUPING' 'SETS' '(' GroupingSetList ')'
Used In:
*GroupingElement
*GroupingSet
GroupingSetList
GroupingSet rectGroupingSet
Definition:
GroupingSetList
::= GroupingSet ( ',' GroupingSet )*
Used In:
*GroupingSetsSpecification
GroupingSet
EmptyGroupingSetOrdinaryGroupingSetRollupListCubeListGroupingSetsSpecification rectEmptyGroupingSet rectOrdinaryGroupingSet rectRollupList rectCubeList rectGroupingSetsSpecification
Definition:
GroupingSet
::= EmptyGroupingSet
| OrdinaryGroupingSet
| RollupList
| CubeList
| GroupingSetsSpecification
Used In:
*GroupingSetList
HavingClause
SqlExpression rectSqlExpression
Definition:
HavingClause
::= 'HAVING' SqlExpression
Used In:
*SelectWithoutOrder
LimitClause
LongConstantLongConstant rectLongConstant rectLongConstant
Definition:
LimitClause
::= 'LIMIT' LongConstant ( ',' LongConstant )?
Used In:
*SelectWithOrder
S_NUMBER
FLOATINTEGER rectFLOAT rectINTEGER
Definition:
S_NUMBER ::= FLOAT ( [eE] [-+]? INTEGER )?
Used In:
*Constant
*FrameBound
*IntegerConstant
*LongConstant
FLOAT
INTEGERINTEGER rectINTEGER rectINTEGER
Definition:
FLOAT ::= ( INTEGER? '.' )? INTEGER
Used In:
*S_NUMBER
INTEGER
DIGIT rectDIGIT
Definition:
INTEGER ::= DIGIT+
Used In:
*FLOAT
*S_NUMBER
DIGIT
Definition:
DIGIT ::= [0-9]
Used In:
*INTEGER
S_PARAMETER
S_IDENTIFIERS_QUOTED_IDENTIFIER rectS_IDENTIFIER rectS_QUOTED_IDENTIFIER
Definition:
S_PARAMETER
::= ':' ( S_IDENTIFIER | S_QUOTED_IDENTIFIER )
Used In:
*CharacterConstant
*Constant
*FrameBound
*IntegerConstant
*LongConstant
S_IDENTIFIER
NAMESTARTCHARNAMECHAR rectNAMESTARTCHAR rectNAMECHAR
Definition:
S_IDENTIFIER
::= NAMESTARTCHAR NAMECHAR*
Used In:
*ObjectName
*S_PARAMETER
*UserDefinedType
NAMESTARTCHAR
Definition:
NAMESTARTCHAR
::= [A-Z_a-z#x00C0-#x00D6#x00D8-#x00F6#x00F8-#x02FF#x0370-#x037D#x037F-#x1FFF#x200C-#x200D#x2070-#x218F#x2C00-#x2FEF#x3001-#xD7FF#xF900-#xFDCF#xFDF0-#xFFFD]
Used In:
*NAMECHAR
*S_IDENTIFIER
NAMECHAR
NAMESTARTCHAR rectNAMESTARTCHAR
Definition:
NAMECHAR ::= NAMESTARTCHAR
| [:$0-9#x00B7#x0300-#x036F#x203F-#x2040]
Used In:
*S_IDENTIFIER
S_QUOTED_IDENTIFIER
Definition:
S_QUOTED_IDENTIFIER
::= '"' [^"#x000A#x000D]* '"'
Used In:
*ObjectName
*S_PARAMETER
S_CHAR_LITERAL
Definition:
S_CHAR_LITERAL
::= "'" ( "'" "'" | [^'] )* "'"
Used In:
*CharacterConstant
*Constant
IgnorableWhitespace
LINE_COMMENTMULTI_LINE_COMMENT rectLINE_COMMENT rectMULTI_LINE_COMMENT
Definition:
IgnorableWhitespace
::= [ #x0009#x000D#x000A]
| LINE_COMMENT
| MULTI_LINE_COMMENT
LINE_COMMENT
Definition:
LINE_COMMENT
::= '--' [^#x000D#x000A]*
Used In:
*IgnorableWhitespace
MULTI_LINE_COMMENT
Definition:
MULTI_LINE_COMMENT
::= '/' '*' ( [^*] | '*'+ [^*/] )* '*'+ '/'
Used In:
*IgnorableWhitespace

Copyright © 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release