StreamSQL Guide Conventions

Shown in UPPERCASE font. Although StreamSQL is case insensitive with respect to keywords, StreamBase convention is to use uppercase characters for clarity.

Example: CREATE TABLE

Shown in lowercase monospace italic font. In StreamSQL applications, replace these placeholders with content suitable to the application. Any combination of upper and lower case characters is acceptable.

Example: CREATE INDEX index_identifier ON table_identifier

Indicate optional content. If an optional entry is used, do not include the brackets in the StreamSQL application.

Example: SELECT ... FROM ... [WHERE ...]

Indicates a choice. In StreamSQL applications choose one of the alternatives separated by the symbol.

Example: CREATE [MEMORY | DISK] TABLE table_identifier

When present, are a required part of the StreamSQL syntax and must be entered as illustrated.

Example: PRIMARY KEY(column_identifier[,...])

Indicate that a choice must be made from multiple alternatives. In StreamSQL applications, do not include the braces.

Example: USING {HASH | BTREE}

In some statements, parentheses or brackets are a required part of the StreamSQL syntax. In this case, each parenthesis or brace is shown within single quotation marks. In StreamSQL applications, the parentheses or brackets must be included.

Example: FROM stream_identifier '['window_specification']'

Indicate optional repeated content. If optional additional entries are used, do not include the brackets in the StreamSQL application.

Example: SELECT field_identifier[, ...]

Is equivalent to: SELECT field_identifier_1, field_identifier_2, ..., where the ellipsis indicates additional optional entries.

Indicates a comment. In StreamSQL, comments extend to the end of the line.

Example: -- This comment extends to the end of the line.