Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


Key to Syntax Diagrams


A word bounded by diagram lines must be separated from adjoining words by at least one separator.

A separator is represented by a white-space character (ASCII HEX-values 09 to 0D, or 20, i.e. <TAB>, <LF>, <VT>, <FF>, <CR> or <SP>).

Words separated from each other by at least one space in the syntax diagram must also be separated from each other by at least one separator in the statement.

Where the descriptive names for identifiers used in the diagrams consist of more than one word, these are bound together by hyphens.

Branched lines indicate alternative constructions. Only one branch may be followed for any one passage along the line: in this example either option-1 or option-2 may be used, but not both.

This representation is used to show that a section of the syntax construction may be repeated. Any construction required between the repetitions is shown on the "repeat line".

In this example, the statement must contain at least one instance of "parameter"; if several instances are given, they must be separated from each other by a comma. If a comma or other separator is specified in a list, blank spaces need not be used between the elements of the list.

Arrows at the beginning and end of a statement show that the statement is complete.

Dots at the beginning or end of a line in a diagram show that the statement on the line is incomplete.

The continuation may be in the same diagram or relate to a separate diagram, as in the language elements see SQL Language Elements. The dots are not part of the statement syntax.

KEYWORDS

Keywords are words that are defined in the SQL language. Keywords are written in UPPERCASE in the diagrams. They must always be written in the statement exactly as shown, except that the case of letters is not significant.

Examples of keywords are:

 ALTER CREATE SYNONYM NULL
 

Spaces between keywords are significant. Thus the keywords CREATE SYNONYM in this example must be separated by at least one space.

Parameters

Parameters are indicated by words in lowercase in the diagrams, and replaced by the appropriate identifiers or constructions when statements are written. Examples of parameters are:

 column-name expression data-type
 

The blank spaces in the diagrams are significant. Words bound together by hyphens (e.g. column-name, data-type) represent single parameters.

Syntax Diagram Example

The following sample illustrates the use of the syntax diagrams.

Some valid formulations are:

 KEYWORD-1
 
 (parameter) option-1 KEYWORD-2 string
 KEYWORD-1
 (parameter, parameter) option-1 KEYWORD-2 string option-3
 KEYWORD-1
 (parameter, parameter, parameter) option-2 KEYWORD-2 string

The following formulations are not valid:

 KEYWORD-1
 (parameter) KEYWORD-2 string
 
Note: 'option-1' or 'option-2' missing
 KEYWORD-1
 parameter  option-1 KEYWORD-2 string
 
Note: parentheses missing
 KEYWORD-1 
 (parameter,) parameter option-2 KEYWORD-2 string
 
Note: closing parentheses wrongly placed
 KEYWORD-1
 (parameter, parameter)
 option-1KEYWORD-2 stringoption-3
 
Note: separating blanks missing
 KEYWORD-1
 (parameter parameter parameter) option-2 KEYWORD-2 string
 
Note: no commas in parameter list



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX