Actuate SQL syntax
Actuate SQL syntax is similar to SQL-92 syntax. Actuate SQL has additional syntax for naming tables and columns. Table 7-1 provides a description of the typographical conventions used in describing Actuate SQL grammar.
ITALICIZED UPPERCASE
[ ] (brackets)
{ } (braces)
Indicating that the preceding item can be repeated n number of times. The item occurrences are separated by commas.
Indicating that the preceding item can be repeated n number of times. The item occurrences are separated by blanks.
The name for a block of syntax. This convention is used to label syntax that can appear in more than one place within a statement. Each location in which the block of syntax can appear is shown with the label enclosed in chevrons, for example <label>.
Table 7-2 lists the tokens used in the Actuate SQL grammar.
A sequence of Unicode letters, digits, dollar signs, and underscores combining characters and extenders. The first character must be a letter. Use double quotes to quote identifiers. To represent a double quote within a quoted identifier, use two double quotes. Quoted identifiers can include any characters except carriage return or new line.
Any Unicode text between single quotes other than carriage return or new line. To represent a single quote, use two single quotes. Multiple consecutive character literals are concatenated.
An integer literal followed by a decimal point and an optional integer representing the fractional part.
Syntax: (INTEGER_LITERAL .) | (. INTEGER_LITERAL) | (INTEGER_LITERAL. [INTEGER_LITERAL])
Syntax: ((. INTEGER_LITERAL) | (INTEGER_LITERAL. [INTEGER_LITERAL])) [(e|E) [-|+] INTEGER_LITERAL]
A literal string that is interpreted as a timestamp value, such as '2002-03-31 13:56:02.7'. Years are 4 digits. Seconds are 2 digits with an optional fraction up to 3 digits. All other fields are 2 digits. The space between the date and time sections is required.

Additional Links:

Copyright Actuate Corporation 2012