Creating or updating QMF catalog objects

The first step to enabling QMF catalog functionality is to choose whether the QMF catalog objects will be created or updated on the current data source.

About this task

To create or update QMF catalog database objects:

Procedure

  1. On the Enable data source plug-ins page of the Create Relational Data Source wizard, select QMF Catalog Plug-in Enable plug-in check box. The Create or update catalog objects page of the QMF Catalog Wizard opens. For more information on how to enable the data source plug-ins, see Enabling data source plug-ins.
  2. On the Create or update catalog objects page, you will specify whether a set of QMF catalog tables has ever been created on the data source 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 data source. A set of catalog tables would have been created for the data source 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 configuring a new data source that has never had the QMF catalog tables installed 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 data source, then they will be created. If you are upgrading to a new version, and a set of tables exist on the data source, 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 configuring a data source 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 data source that you are configuring must support long names.

      If no QMF catalog tables exist on the data source, 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 data source, 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 data source, they will be converted to support long names. The data source 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 data source 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.

    • If you do not want to create a set of QMF catalog tables for this data source, select Do not create catalog tables. You would select this option if the data source you are configuring will not host a QMF catalog; will use a set of QMF catalog tables that reside on a different data source; or a set of QMF catalog tables has already been created for this data source and you are just selecting a different QMF catalog.
  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. Select an option and click Next. The Creating objects page opens. On the page, type any changes that you want to make to the SQL statements and click Next. The Protect QMF Catalog tables page opens.
    • Create or update catalog tables to support short names or Create or update catalog tables to support long names option and you checked the Enable customization of database object names check box, the Choose object listing option page of the wizard opens. Select an option and click Next. The Enter Substitution Variable Values window opens. 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 . Enter your customized database object names in the Value column and click OK. The Creating objects page opens. On the page, type any changes that you want to make to the SQL statements and click Next. The Protect QMF Catalog tables page opens.
    • Do not create catalog tables option, the Protect QMF Catalog tables page of the wizard opens.