QLCA field descriptions 615 SYSCAT. HIERARCHIES Error reporting 619 SYSCATINDEXAUTH SQLCA usage in partitioned database SYSCATINDEXCOLUSE 75 620 SYSCATINDEXDEP SYSCATINDEXES Appendix C. SQLDA (SQL descriptor SYSCATINDEXEXPLOITRULES 621 SYSCATINDEXEXTENSIONDEP SQLDA field descriptions SYSCAT. INDEXEXTENSIONMETHODS Fields in the SQLDA header SYSCATINDEXEXTENSIONPARMS Fields in an occurrence of a base SQLVAR 623 SYSCAT. INDEXEXTENSIONS Fields in an occurrence of a secondary SYSCATINDEXOPTIONS QLVAR SYSCAT.KEYCOLUSE Effect of dESCribe on the SQLDA SYSCAT. NAMEMAPPINGS SQLTYPE and SQLLEN 629 SYSCAT. PACKAGEAUTH ognized and unsupported SYSCAT. PACKAGEDEP SQLTYPEs SYSCAT. PACKAC Packed decimal numbers 631 SYSCAT. PARTTTIONMAPS SQLLEN field for decimal SYSCATPASSTHRUAUTH SYSCAT. PREDICATESPECS Appendix D Catalog views 633 SYSCAT. PROCOPTIONS Road map to catalog views 633 SYSCAT PROCPARMOPTIONS Road map to updatable catalog views 636 SYSCAT.REFERENCES System catalog views SYSCAT. REVTYPEMAPPINGS 705 SYSIBM.SYSDUMMY1 SYSCAT. ROUTINEAUTH 707 SYSCAT.ATTRIBUTES 639 SYSCAT. ROUTINEDEP SYSCAT BUFFERPOOLDBPARTITIONS 641 SYSCAT. ROUTINEPARMS SYSCAT. BUFFERPOOLS 642 SYSCAT ROUTINES SYSCAT. CASTFUNCTIONS SYSCAT. SCHEMAAUTH SYSCAT. CHECKS SYSCAT. SCHEMATA SYSCAT. COLAUTH SYSCAT. SEQUENCEAUTH SYSCAT. COLCHECKS SYSCAT.SEQU! SYSCAT. COLDIST SYSCAT. SERVEROPTIONS SYSCAT COLGROUPDIST SYSCAT SERVERS SYSCAT COLGROUPDISTCOUNTS 649 SYSCAT.STATEMENTS SYSCAT COLGROUPS SYSCAT.TABAUTH SYSCAT. COLOPTIONS 651 SYSCAT. TABCONST SYSCAT. COLUMNS SYSCAT.TABDEP SYSCAT. COLUSE SYSCAT. TABLES SYSCAT CONSTDEP 658 SYSCAT.TABLESPACES 735 SYSCATDATATYPES SYSCAT. TABOPTIONS SYSCATDBAUTH SYSCAT.TBSPACEAUTH SYSCAT. DBPARTITIONGROUPDEF SYSCAT. TRANSFORMS SYSCAT. DBPARTITIONGROUPS SYSCAT.TRIGDEP SYSCAT.EVENTMONITORS 665 SYSCAT. TRIGGERS SYSCAT.EVENTS SYSCAT.TYPEMAPPINGS SYSCATEVENTTABLES 668 SYSCAT. USEROPTIONS SYSCAT. FULLHIERARCHIES 669 SYSCAT. VIEWS SYSCAT. FUNCMAPOPTIONS SYSCAT. WRAPOPTIONS SYSCAT. FUNCMAPPARMOPTIONS SYSCAT. WRAPPERS 746 SYSCAT. FUNCMAPPINGS SYSSTAT. COLDIST Contents vIlSQLCA field descriptions . . . . . . . 615 Error reporting. . . . . . . . . . . 619 SQLCA usage in partitioned database systems . . . . . . . . . . . . . 620 Appendix C. SQLDA (SQL descriptor area) . . . . . . . . . . . . . . 621 SQLDA field descriptions . . . . . . . 621 Fields in the SQLDA header . . . . . 622 Fields in an occurrence of a base SQLVAR 623 Fields in an occurrence of a secondary SQLVAR . . . . . . . . . . . . 625 Effect of DESCRIBE on the SQLDA . . . . 627 SQLTYPE and SQLLEN . . . . . . . . 629 Unrecognized and unsupported SQLTYPEs . . . . . . . . . . . 631 Packed decimal numbers . . . . . . 631 SQLLEN field for decimal . . . . . . 632 Appendix D. Catalog views . . . . . . 633 ‘Road map’ to catalog views . . . . . . 633 ‘Road map’ to updatable catalog views . . 636 System catalog views . . . . . . . . 636 SYSIBM.SYSDUMMY1 . . . . . . . . 638 SYSCAT.ATTRIBUTES . . . . . . . . 639 SYSCAT.BUFFERPOOLDBPARTITIONS . . 641 SYSCAT.BUFFERPOOLS . . . . . . . 642 SYSCAT.CASTFUNCTIONS . . . . . . 643 SYSCAT.CHECKS . . . . . . . . . . 644 SYSCAT.COLAUTH . . . . . . . . . 645 SYSCAT.COLCHECKS . . . . . . . . 646 SYSCAT.COLDIST . . . . . . . . . 647 SYSCAT.COLGROUPDIST . . . . . . . 648 SYSCAT.COLGROUPDISTCOUNTS. . . . 649 SYSCAT.COLGROUPS . . . . . . . . 650 SYSCAT.COLOPTIONS . . . . . . . . 651 SYSCAT.COLUMNS . . . . . . . . . 652 SYSCAT.COLUSE . . . . . . . . . . 657 SYSCAT.CONSTDEP . . . . . . . . . 658 SYSCAT.DATATYPES . . . . . . . . 659 SYSCAT.DBAUTH . . . . . . . . . 661 SYSCAT.DBPARTITIONGROUPDEF . . . 663 SYSCAT.DBPARTITIONGROUPS . . . . 664 SYSCAT.EVENTMONITORS . . . . . . 665 SYSCAT.EVENTS . . . . . . . . . . 667 SYSCAT.EVENTTABLES . . . . . . . 668 SYSCAT.FULLHIERARCHIES . . . . . . 669 SYSCAT.FUNCMAPOPTIONS . . . . . 670 SYSCAT.FUNCMAPPARMOPTIONS . . . 671 SYSCAT.FUNCMAPPINGS. . . . . . . 672 SYSCAT.HIERARCHIES. . . . . . . . 673 SYSCAT.INDEXAUTH . . . . . . . . 674 SYSCAT.INDEXCOLUSE . . . . . . . 675 SYSCAT.INDEXDEP . . . . . . . . . 676 SYSCAT.INDEXES . . . . . . . . . 677 SYSCAT.INDEXEXPLOITRULES . . . . . 682 SYSCAT.INDEXEXTENSIONDEP . . . . 683 SYSCAT.INDEXEXTENSIONMETHODS . . 684 SYSCAT.INDEXEXTENSIONPARMS . . . 685 SYSCAT.INDEXEXTENSIONS. . . . . . 686 SYSCAT.INDEXOPTIONS . . . . . . . 687 SYSCAT.KEYCOLUSE . . . . . . . . 688 SYSCAT.NAMEMAPPINGS . . . . . . 689 SYSCAT.PACKAGEAUTH . . . . . . . 690 SYSCAT.PACKAGEDEP. . . . . . . . 691 SYSCAT.PACKAGES . . . . . . . . . 693 SYSCAT.PARTITIONMAPS . . . . . . 699 SYSCAT.PASSTHRUAUTH. . . . . . . 700 SYSCAT.PREDICATESPECS . . . . . . 701 SYSCAT.PROCOPTIONS . . . . . . . 702 SYSCAT.PROCPARMOPTIONS . . . . . 703 SYSCAT.REFERENCES . . . . . . . . 704 SYSCAT.REVTYPEMAPPINGS . . . . . 705 SYSCAT.ROUTINEAUTH . . . . . . . 707 SYSCAT.ROUTINEDEP . . . . . . . . 708 SYSCAT.ROUTINEPARMS . . . . . . . 709 SYSCAT.ROUTINES . . . . . . . . . 711 SYSCAT.SCHEMAAUTH . . . . . . . 718 SYSCAT.SCHEMATA . . . . . . . . 719 SYSCAT.SEQUENCEAUTH . . . . . . 720 SYSCAT.SEQUENCES . . . . . . . . 721 SYSCAT.SERVEROPTIONS. . . . . . . 723 SYSCAT.SERVERS. . . . . . . . . . 724 SYSCAT.STATEMENTS . . . . . . . . 725 SYSCAT.TABAUTH . . . . . . . . . 726 SYSCAT.TABCONST . . . . . . . . . 728 SYSCAT.TABDEP . . . . . . . . . . 729 SYSCAT.TABLES . . . . . . . . . . 730 SYSCAT.TABLESPACES . . . . . . . . 735 SYSCAT.TABOPTIONS . . . . . . . . 736 SYSCAT.TBSPACEAUTH . . . . . . . 737 SYSCAT.TRANSFORMS. . . . . . . . 738 SYSCAT.TRIGDEP . . . . . . . . . 739 SYSCAT.TRIGGERS . . . . . . . . . 740 SYSCAT.TYPEMAPPINGS . . . . . . . 741 SYSCAT.USEROPTIONS . . . . . . . 743 SYSCAT.VIEWS . . . . . . . . . . 744 SYSCAT.WRAPOPTIONS . . . . . . . 745 SYSCAT.WRAPPERS . . . . . . . . . 746 SYSSTAT.COLDIST . . . . . . . . . 747 Contents vii