Creating or updating QMF catalog objects

Use the Create or update catalog objects page of the Register QMF Catalog wizard to choose whether the QMF catalog objects will be created or updated on the current database.

About this task

To create or update QMF catalog database objects:

Procedure

  1. Open the Create or update catalog objects page of the Register QMF Catalog wizard.
  2. Specify whether a set of QMF catalog tables has ever been created on the database and what kind of object names (long or short) are or will be supported by the QMF catalog that exists or will be created. Select one of the following:
    • Select Catalog tables have already been created if the QMF catalog tables already exist on this database and you do not want to update them. A set of catalog tables would have been created for the database when it was originally configured in either a repository or by a prior version of the application. You would select this option if you know the tables have already been created and you only want to rerun stored procedures or rebind the catalog packages.
    • Select Create or update catalog tables to support short names if you are registering the QMF catalog for the database that has never had QMF catalog tables installed before and you will only use short names for objects, or you are upgrading from a previous version of the application and the existing QMF catalog tables will continue to support only short names for objects. If no QMF catalog tables exist on the database, then they will be created. If you are upgrading to a new version, and a set of tables exist on the database, they will be checked and updated or added as necessary. You are given the opportunity to confirm and modify the SQL statements used to create the tables. Any data that is in the existing catalog tables is maintained.
    • Select Create or update catalog tables to support long names if you are registering the QMF catalog for this database for the first time and want to create a set of QMF catalog tables that use long names; you are upgrading from a previous version of the application and the existing QMF catalog tables will continue to support only long names for objects; or you want to convert the existing catalog tables that support short names to catalog tables that support long names. To select this option, the current database must support long names. If you choose to create the QMF catalog tables so that they support long names, QMF applications prior to Version 8.1 will not be able to use the long names QMF catalog tables.

      If no QMF catalog tables exist on the database, then they will be created and they will support long names. If a set of QMF catalog tables that support long names are detected on the database, they will be updated or added to as necessary. If an existing set of QMF catalog tables that use short names are detected on the database, they will be converted to support long names. The database will be checked to ensure that the support for long names is available. There is no requirement to use long names in the QMF catalog tables. If the database uses long names, the QMF catalog tables can still use short names. Once converted, only 8.1 or later of QMF applications can use these QMF catalog tables.

      You are given the opportunity to confirm and modify the SQL statements used to create or update the tables. Any data that is in the existing catalog tables is maintained.

  3. If catalog tables have not been created, you can select the Enable customization of database object names check box to open a window where you can customize how database objects are named.
  4. Click Next to open the next page of the wizard. If you selected:
    • Catalog tables have already been created option, the Protect QMF Catalog tables page of the wizard opens.
    • Create or update catalog tables to support short names or Create or update catalog tables to support long names option and you did not check the Enable customization of database object names check box, the Choose object listing option page of the wizard opens.
    • Create or update catalog tables to support short names or Create or update catalog tables to support long names option and you did check the Enable customization of database object names check box, the Enter Substitution Variable Values window opens. Enter your customized database object names in the Value column and click OK.
      Note: The Value column of the dialog displays the default name of each database object. This gives you an opportunity to review and/or rename the objects that will be created. For example, one could preface all index names with the IX .
      The Choose object listing option page of the wizard opens.