SYSSTAT COLUMNS EMPLOYEE table SYSSTATINDEXES EMP ACT table SYSSTAT ROUTINES EMP PHOTO table 810 SYSSTAT TABLES 757 EMP RESUME table IN TRAY table Appendix E Federated systems ORG table Valid server types in SQL statements PROJECT table CTLIB wrapper SALES table DBLIB 759 STAFF table DJXMSSQL3 wrapper 759 STAFFG table(double-byte code pages only) 815 DRDA wrapper ample files with BLOB and CLOB data type 816 Informix wrapper 761 Quintana photo MSSQLODBC3 wrapper Quintana resume 816 NET8 wrapper Nicholls photo ODBC wrapper Nicholls resume OLE DB wrapper Adamson photo Function mapping option6s:,p的 SQLNET wrapper Column options for federated syst Walker resume erver options for federated systems Appendix G. Reserved schema names User options for federated systems and reserved words 823 Wrapper options for federated systems 774 Default forward data type mappings Appendix H. Comparison of isolation DB2 for z/OS and OS/390 data sources 776 evels DB2 for iSeries data sources DB2 Server for VM and VsE data sources 779 Appendix I Interaction of triggers and DB2 for UNIX and Windows data sources 780 constraints Informix data sources Oracle SqlneT data sources Appendix J. Explain tables 833 Oracle net8 data sources Microsoft SQL Server data sources EXPLAIN ARGUMENT table oDBC data sources EXPLAIN INSTANCE table Sybase data sources EXPLAIN_OBJECT table 841 Default reverse data type mappings EXPLAIN OPERATOR table DB2 for z/OS and OS/390 data sources EXPLAIN PREDICATE table DB2 for iseries data sources EXPLAIN STATEMENT table DB2 Server for VM and Vse data sources 795 EXPLAIN STREAM table 851 DB2 for unix and windows data sources 796 ADVISE INDEX table Informix data sources ADVISE WORKLOAD table Oracle SqLneT data sources Oracle net8 data sources Appendix K. Explain register values 85 Microsoft SQL Server data sources Sybase data sources 801 Appendix L. Recursion example: bill of materials Appendix F The SAMPLE database Example 1: Single level explosion Creating the SAMPLE database Example 2: Summarized explo OSIO Erasing the SAMPLE database Example 3: Controlling depth CL SCHED table DEPARTMENT table VIll SQL Reference, Volume 1SYSSTAT.COLUMNS. . . . . . . . . 749 SYSSTAT.INDEXES . . . . . . . . . 751 SYSSTAT.ROUTINES. . . . . . . . . 755 SYSSTAT.TABLES . . . . . . . . . . 757 Appendix E. Federated systems . . . . 759 Valid server types in SQL statements . . . 759 CTLIB wrapper . . . . . . . . . 759 DBLIB wrapper . . . . . . . . . 759 DJXMSSQL3 wrapper . . . . . . . 759 DRDA wrapper . . . . . . . . . 759 Informix wrapper. . . . . . . . . 761 MSSQLODBC3 wrapper . . . . . . 761 NET8 wrapper. . . . . . . . . . 761 ODBC wrapper . . . . . . . . . 761 OLE DB wrapper . . . . . . . . . 761 SQLNET wrapper. . . . . . . . . 761 Column options for federated systems . . . 762 Function mapping options for federated systems . . . . . . . . . . . . . 763 Server options for federated systems . . . 764 User options for federated systems . . . . 773 Wrapper options for federated systems . . 774 Default forward data type mappings . . . 775 DB2 for z/OS and OS/390 data sources 776 DB2 for iSeries data sources . . . . . 777 DB2 Server for VM and VSE data sources 779 DB2 for UNIX and Windows data sources 780 Informix data sources . . . . . . . 781 Oracle SQLNET data sources . . . . . 782 Oracle NET8 data sources . . . . . . 783 Microsoft SQL Server data sources . . . 785 ODBC data sources . . . . . . . . 788 Sybase data sources . . . . . . . . 789 Default reverse data type mappings. . . . 791 DB2 for z/OS and OS/390 data sources 792 DB2 for iSeries data sources . . . . . 793 DB2 Server for VM and VSE data sources 795 DB2 for UNIX and Windows data sources 796 Informix data sources . . . . . . . 797 Oracle SQLNET data sources . . . . . 798 Oracle NET8 data sources . . . . . . 799 Microsoft SQL Server data sources . . . 801 Sybase data sources . . . . . . . . 801 Appendix F. The SAMPLE database . . . 803 Creating the SAMPLE database . . . . . 803 Erasing the SAMPLE database . . . . . 803 CL_SCHED table . . . . . . . . . . 803 DEPARTMENT table . . . . . . . . . 804 EMPLOYEE table . . . . . . . . . . 806 EMP_ACT table . . . . . . . . . . 808 EMP_PHOTO table . . . . . . . . . 810 EMP_RESUME table . . . . . . . . . 810 IN_TRAY table . . . . . . . . . . . 811 ORG table . . . . . . . . . . . . 811 PROJECT table. . . . . . . . . . . 811 SALES table . . . . . . . . . . . 812 STAFF table. . . . . . . . . . . . 814 STAFFG table (double-byte code pages only) 815 Sample files with BLOB and CLOB data type 816 Quintana photo . . . . . . . . . 816 Quintana resume . . . . . . . . . 816 Nicholls photo . . . . . . . . . . 818 Nicholls resume . . . . . . . . . 818 Adamson photo . . . . . . . . . 819 Adamson resume . . . . . . . . . 819 Walker photo . . . . . . . . . . 821 Walker resume . . . . . . . . . . 821 Appendix G. Reserved schema names and reserved words . . . . . . . . 823 Appendix H. Comparison of isolation levels . . . . . . . . . . . . . 827 Appendix I. Interaction of triggers and constraints . . . . . . . . . . . 829 Appendix J. Explain tables . . . . . . 833 Explain tables . . . . . . . . . . . 833 EXPLAIN_ARGUMENT table . . . . . . 834 EXPLAIN_INSTANCE table . . . . . . 838 EXPLAIN_OBJECT table . . . . . . . 841 EXPLAIN_OPERATOR table . . . . . . 844 EXPLAIN_PREDICATE table . . . . . . 846 EXPLAIN_STATEMENT table. . . . . . 848 EXPLAIN_STREAM table . . . . . . . 851 ADVISE_INDEX table . . . . . . . . 853 ADVISE_WORKLOAD table . . . . . . 856 Appendix K. Explain register values. . . 857 Appendix L. Recursion example: bill of materials . . . . . . . . . . . . 861 Example 1: Single level explosion . . . . 861 Example 2: Summarized explosion . . . . 863 Example 3: Controlling depth . . . . . . 864 viii SQL Reference, Volume 1