a brief overview of volume 1 SQL descriptor area(SQLDA)"describes the SQLDA structure Catalog views"describes the database catalog views Federated systems"describes options and type mappings for federated "Sample database tables"describes the sample tables used in examples Reserved schema names and reserved words" contains the reserved schema names and the reserved words for the IBM SQL and ISO/ANS SQL99 standards Comparison of isolation levels" contains a summary of the isolation levels 'Interaction of triggers and constraints"discusses the interaction of triggers and referential constraints Explain tables"describes the Explain tables Explain register values"describes the interaction of the CurREnt EXPLAIN MODE and CURRENT EXPLAIN SNAPSHOT special register values with each other and with the prep and bind commands Recursion example: bill of materials"contains an example of a recursive query. Exception tables"contains information about user-created tables that are used with the SEt INTEGRiTY statement SQL statements allowed in routines" lists the SQl statements that are allowed to execute in routines with different SQL data access contexts call describes the Call statement that can be invoked from a compiled statement Japanese and traditional-Chinese EUC considerations"lists considerations when using extended UNIX code(EUC)character sets BNF specifications for DATALINKs"contains the Backus-Naur form(BNF) specifications for DATALINKs How to read the syntax diagrams Throughout this book, syntax is described using the structure defined as follows Read the syntax diagrams from left to right and top to bottom, following the path of the line The rk symbol indicates the beginning of a syntax diagram The symbol indicates that the syntax is continued on the next line The - symbol indicates that the syntax is continued from the previous line VIll SQL Reference, Volume 2v “SQL descriptor area (SQLDA)” describes the SQLDA structure. v “Catalog views” describes the database catalog views. v “Federated systems” describes options and type mappings for federated systems. v “Sample database tables” describes the sample tables used in examples. v “Reserved schema names and reserved words” contains the reserved schema names and the reserved words for the IBM SQL and ISO/ANS SQL99 standards. v “Comparison of isolation levels” contains a summary of the isolation levels. v “Interaction of triggers and constraints” discusses the interaction of triggers and referential constraints. v “Explain tables” describes the Explain tables. v “Explain register values” describes the interaction of the CURRENT EXPLAIN MODE and CURRENT EXPLAIN SNAPSHOT special register values with each other and with the PREP and BIND commands. v “Recursion example: bill of materials” contains an example of a recursive query. v “Exception tables” contains information about user-created tables that are used with the SET INTEGRITY statement. v “SQL statements allowed in routines” lists the SQL statements that are allowed to execute in routines with different SQL data access contexts. v “CALL” describes the CALL statement that can be invoked from a compiled statement. v “Japanese and traditional-Chinese EUC considerations” lists considerations when using extended UNIX code (EUC) character sets. v “BNF specifications for DATALINKs” contains the Backus-Naur form (BNF) specifications for DATALINKs. How to read the syntax diagrams Throughout this book, syntax is described using the structure defined as follows: Read the syntax diagrams from left to right and top to bottom, following the path of the line. The

─── symbol indicates the beginning of a syntax diagram. The ───
symbol indicates that the syntax is continued on the next line. The
─── symbol indicates that the syntax is continued from the previous line. A brief overview of Volume 1 viii SQL Reference, Volume 2