• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Welcome
  5. Conventions

Conventions

Example Conventions

Example

Description

dbadmin

Indicates the user operating and maintaining the DWS appointed at installation.

8000

Indicates the port number used by DWS to monitor connection requests from the client.

SQL examples in this manual are developed based on the TPC-DS model. Before you execute the examples, install the TPC-DS benchmark by following the instructions on the official website http://www.tpc.org/tpcds/.

SQL Syntax Text Conventions

To better understand the syntax usage, you can refer to the SQL syntax text conventions described as follows:

Format

Description

Uppercase characters

Keywords must be in uppercase.

Lowercase characters

Indicates that parameters must be in lowercase.

[ ]

Indicates that the items in brackets [] are optional.

...

Indicates that preceding elements can appear repeatedly.

[ x | y | ... ]

Indicates that one item is selected from two or more options or no item is selected.

{ x | y | ... }

Indicates that one item is selected from two or more options.

[x | y | ... ] [ ... ]

Indicates that multiple parameters or no parameter can be selected. If multiple parameters are selected, separate them with spaces.

[ x | y | ... ] [ ,... ]

Indicates that multiple parameters or no parameter can be selected. If multiple parameters are selected, separate them with commas (,).

{ x | y | ... } [ ... ]

Indicates that at least one parameter can be selected. If multiple parameters are selected, separate them with spaces.

{ x | y | ... } [ ,... ]

Indicates that at least one parameter can be selected. If multiple parameters are selected, separate them with commas (,).