Assumptions relating to examples of SQL statements

The examples of SQL statements shown in this guide assume the following.

• SQL keywords are highlighted.
• Table names used in the examples are the sample tables provided in the SQL Programming topic collection. Table names that are not provided in that appendix should use schemas that you create. You can create a set of sample tables in your own schema by issuing the following SQL statement:

  CALL QSYS.CREATE_SQL_SAMPLE ('your-schema-name')

• The SQL naming convention is used.
• For COBOL examples, the APOST and APOSTSQL precompiler options are assumed (although they are not the default in COBOL). Character-string constants within SQL and host language statements are delimited by apostrophes (').
• A collating sequence of *HEX is used.

Whenever the examples vary from these assumptions, it is stated.