WebSphere logo Classic Federation Server for z/OS, Version 9.1
WebSphere logo Classic Replication Server for z/OS, Version 9.1
WebSphere logo Classic Data Event Publisher for z/OS, Version 9.1
WebSphere logo Data Integration Classic Connector for z/OS, Version 9.1


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.

To export the files that contain your DDL scripts:

  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.

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

Related concepts
Populating metadata catalogs
Creating views on existing tables
Related tasks
Generating DDL


Feedback

Update icon Last updated: 2007-07-11