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