Using the DB2 Catalog

Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.

Once you have added SQL DDL source to a data view, either directly or via a SQL Schema, you have the option to substitute the current mainframe versions of the SQL tables and views for the tables and views defined in the local SQL DDL. You can also use the copybooks in the DB2 catalog instead of local copybooks. The advantage of using DB2 catalog sources over local data sources is that the sources in the DB2 catalog are much more likely to be up to date than downloaded sources.

Enable DB2 catalog functionality

To enable DB2 catalog functionality for data views:

Install IBM DB2 JDBC drivers
As a prerequisite for accessing the mainframe DB2 catalog, you must install the IBM DB2 JDBC drivers.
Set DB2_LIB_LOCATION in the eclipse.ini file
Edit the eclipse.ini file to include the DB2_LIB_LOCATION environment variable, which points to the directory where the IBM DB2 JDBC driver .jar files are installed. Use the -D parameter. For example:
-DDB2_LIB_LOCATION=jdbc-driver-location

The eclipse.ini file is located by default in the C:\Users\Public\Micro Focus\Enterprise Developer\eclipse directory.

Define one or more DB2 connections
To use the mainframe DB2 catalog, you must first define at least one DB2 connection to your mainframe. See To create a DB2 connection for instructions.
Switch to SQL objects in the DB2 catalog
Once you have a working DB2 connection, switch out your defined SQL DDL files and SQL SCHEMA files on the Data View Explorer tree view for their corresponding SQL objects on the mainframe. See To switch to DB2 catalog objects for details.

Use the DB2 catalog from the Data View Explorer

Data view sources in the DB2 catalog are listed in the Data View Explorer tree view under an SQL Objects entry for each data view that contains them. From the Data View Explorer, you can:

  • Add tables and views from the DB2 catalog to a data view
  • View the DB2 CREATE TABLE statements in the DB2 catalog
  • Copy and paste DB2 CREATE TABLE statements into local SQL DDL to create a corresponding SQL table