Section 1.11. DB2 Syntax Diagram Conventions


1.11. DB2 Syntax Diagram Conventions

DB2 supports a comprehensive set of statements for data access and manipulation. These statements are documented online in the DB2 Information Center, which gives you access to all information about DB2 UDB as well as major DB2 features and components. It can be conveniently accessed by using a browser, as shown in Figure 1.13. The DB2 Information Center is also available through the Internet at http://publib.boulder.ibm.com/infocenter/db2help.

Figure 1.13. The DB2 Information Center


You can find the syntax of the statements we introduce in this book in the DB2 Information Center. Understanding how to read the syntax diagrams will help you use the numerous options available with many of the statements.

Syntax diagrams are all read from left to right and top to bottom following the path of each line. Table 1.2 summarizes a few of the most commonly used symbols in a syntax diagram.

Table 1.2. Summary of Some Symbols Used in Syntax Diagrams

Symbol

Description

>>---

Indicates the beginning of a syntax diagram.

--->

Indicates that the syntax is continued on the next line.

>---

Indicates that the syntax is continued from the previous line.

---><

Indicates the end of a syntax diagram.


When a mandatory field is required, it appears on the horizontal line (the main path) like this.

 >>-mandatory_field-------------------------------------->< 

Optional fields appear below the main path.

 >>-mandatory_field--+----------------+------------------><                     '-optional_field-' 

If an optional field appears above the main path, it means that it is the default option.

                     .-default_field-. >>-mandatory_field--+---------------+-------------------><                     '-optional_field-' 

If two or more mandatory choices are available, one of the mandatory choices will appear in the main path, and the rest will appear in a stack. You must choose one of these options.

 >>-mandatory_field--+-mandatory_choice1-+---------------><                     '-mandatory_choice2-' 

An arrow returning to the left, above the main line, indicates an option can be repeated. In this example, repeated options are separated by one or more blanks.

                      .-----------------.                      V                 | >>-mandatory_field----repeatable_field-+---------------->< 

If the repeat arrow contains a comma, you must separate repeated items with a comma.

                      .-,---------------.                      V                 | >>-mandatory_field----repeatable_field-+---------------->< 

You now know how to read syntax diagrams in the DB2 manuals. Browse through the DB2 online documentation and review some examples there.



Understanding DB2(R. Learning Visually with Examples)
Understanding DB2: Learning Visually with Examples (2nd Edition)
ISBN: 0131580183
EAN: 2147483647
Year: 2004
Pages: 313

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net