HPlogo IMAGE/SQL Administration Guide: HP 3000 MPE/iX Computer Systems

Appendix E SQL Views for Indices

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Glossary

 » Index

This appendix is new with the G.2 version of this manual. It includes information on executing SQLINSTL and ODBCVIEW, as well as information on these four views that are related to indices:

  • SYSTEM.IMAGEKEY

  • CATALOG.IMAGEKEY

  • SYSTEM.TPINDEX

  • CATALOG.TPINDEX

Information related to these views for B-Tree indices is also included:

  • SYSTEM.INDEX

  • CATALOG.INDEX

Whenever you ATTACH a database to a DBEnvironment, the definitions for TurboIMAGE/XL and third-party indices (TPIs) are entered in the system catalog of the DBEnvironment. The definitions of TPIs are propagated to all DBEnvironments the database is attached to. You can observe the indices in the SQL views.

Feedback to webmaster