Generating the Information Schema Views
About this task
The Information Schema views are generated automatically
when you, as DBA, run the following DB-Access command:
dbaccess database-name $ONEDB_HOME/etc/xpg4_is.sqlThe
views display data from the system catalog tables. If tables, views,
or routines exist with any of the same names as the Information Schema
views, you must either rename those database objects or rename the
views in the script before you can install the views. You can drop
the views with the DROP VIEW statement on each view. To re-create
the views, rerun the script.
Important: In
addition to the columns specified for each Information Schema view,
individual vendors might include additional columns or change the
order of the columns. It is recommended that applications not use
the forms SELECT * or SELECT table-name* to access an Information
Schema view.