These topics describe the iSeries™ server
implementation of the Structured Query Language (SQL) using DB2® UDB for iSeries and
the DB2 UDB Query Manager and SQL Development Kit Version 5 licensed
program.
The examples of SQL statements shown in this topic collection are based
on the sample tables and assume the following:
- They are shown in the interactive SQL environment or they are written
in ILE C or in COBOL.
EXEC SQL and END-EXEC are used to delimit an SQL statement in a COBOL program.
- Each SQL example is shown on several lines, with each clause of the statement
on a separate line.
- SQL keywords are highlighted.
- Table names provided in the sample tables use the schema CORPDATA. Table
names that are not found in the Sample Tables should use schemas you create.
- Calculated columns are enclosed in parentheses, (), and brackets, [].
- The SQL naming convention is used.
- The APOST and APOSTSQL precompiler options are assumed although they are
not the default options in COBOL.
Character string literals within SQL and host language statements are delimited
by single-quotation marks (').
- A sort sequence of *HEX is used, unless otherwise noted.
Whenever the examples vary from these assumptions, it is stated.
Because this topic collection is for the application programmer,
most of the examples are shown as if they were written in an application program.
However, many examples can be slightly changed and run interactively by using
interactive SQL. The syntax of an SQL statement, when using interactive SQL,
differs slightly from the format of the same statement when it is embedded
in a program.