The syntax notation used in the documentation is derived from the Backus Naur Form (BNF). The following conventions apply.
Syntax Element |
Description |
---|---|
KEYWORD |
Keywords are shown in uppercase letters for the sake of emphasis. If there is no specific reference to case-sensitivity in the documentation, you can write keywords in either upper- or lowercase letters. |
<variable> |
Placeholder for syntax elements, such as variables. When you enter the variable, do not enter the angle brackets. |
[syntax_element] |
Optional syntax element When you enter the syntax element, do not enter the square brackets. |
syntax_element1 | syntax_element2 |
Alternative syntax elements (OR) |
syntax_element, ... |
Syntax element can be repeated as often as required. |
Example |
Description |
---|---|
dbmcli db_enum |
Commands and SQL statements that users should enter are formatted in a bold monospace font. |
OK DEMODB C:\Program Files\sdb\Installation_1 7.8.01.04 fast running |
System replies and output from database tools and other programs are formatted in a monospace font. |
The db_enum command lists all databases. The documentation uses the DEMODB demo database. |
Syntax elements and examples in continuous text are formatted in a monospace font. |
sqlcli -d <database_name> -u <database_user>,<database_user_password> <sql_statement>
To illustrate commands and actions, the documentation uses the DEMODB demo database with the HOTEL schema sample data:
sqlcli -d demodb -u mona,red SELECT * FROM hotel.city
| ZIP | NAME | STATE |
| ----- | -------------------- | ----- |
| 10019 | New York | NY |
| 10580 | New York | NY |
| 11788 | Long Island | NY |
| 12203 | Albany | NY |
| 20005 | Washington | DC |
| 20019 | Washington | DC |
SQL Reference Manual, SQL Syntax
Loader, Syntax Rules