Exporting SQL to remote z/OS hosts

The DDL that you generate for your tables, views, and stored procedures is saved to the SQL Scripts folder of your project. You can export the files that contain those scripts to the z/OS® host where your data server is located.

Procedure

  1. Open the Export SQL window by right-clicking the file that you want to export and selecting Export SQL.
  2. Provide the connectivity information for connecting to the remote z/OS host, and provide the location in which you want to save the DDL scripts.

Results

Then, you can use the metadata utility to run the scripts and populate a metadata catalog.