Ask a question?
  • Contact Us
  • Support Case System
  • Support Forum

What Does Custom Catalog Views Do?

"Custom Catalog Views" controls whether custom OpenLink views are used to return meta-data for some ODBC catalog functions. These custom views provide more meta-data than is normally available. To create and use them, the script odbccat[8|9].sql must be run beforehand.

The ODBC catalog functions affected are: SQLForeignKeys, SQLPrimaryKeys, SQLProcedureColumns, SQLProcedures, SQLSpecialColumns

The odbccat[8|9].sql scripts create the following OpenLink 'internal' views: OPENLINK$SQL_FOREIGN_KEYS OPENLINK$SQL_PRIMARY_KEYS OPENLINK$SQL_SPEC_COLUMNS OPENLINK$SQL_PROC_COLUMNS OPENLINK$SQL_PROCEDURES OPENLINK$SQL_PROCS_NOCOUNT

If "Custom Catalog Views" is enabled, these internal views will be used. Otherwise only standard Oracle data dictionary views are used.

To run these scripts you need to start the Oracle server manager (svrmgr or sqldba if you do this from the command line). Connect as internal and run the script by locating the relevant script file as you would any other Oracle SQL script file.