Use the Export SQL wizard to export SQL files
from a data design project to a remote z/OS® server.
You can export SQL files that were created in the SQL Builder
or SQL Editor and SQL files that were created by the Generate DDL wizard.
You
do not need to export the SQL DDL files before you run the DDL to populate
a metadata catalog.
Open the wizard by using either of these two options:
- Select and select Classic Integration Export SQL from
the Export window.
- Right-click a .sql file in the SQL Scripts folder
and select Export SQL.
Select Files and Destination
Use
this page to choose the SQL files that you want to export and to choose the
location that you want to export the files to.
- Select files to export
- Use these controls to select the files that you want to export.
- SQL files
- Displays the name of the SQL files to export.
If you opened the wizard from the File menu, click Browse to
select the SQL files to export. If you opened the wizard by right-clicking
a .sql file, verify that the correct file is named.
- Overwrite existing files without warning
- Select to overwrite any files at the destination
that have the same names as the .sql files that you export.
- Destination
- Use these controls to give the location to which you want to export the
files.
- Host
- Type the host name or IP address of the z/OS server on
which the destination is located.
- User ID
- Specify the user ID that is needed to connect
to the remote host.
- Password
- Specify the password that is needed to connect
to the remote host.
- Save password
- Select to tell Classic Data Architect to save
the password that is associated with the user ID. When you export files to
the same z/OS server
in the future and use the same ID to make the connection, Classic Data Architect
automatically populates this field with the password.
- Data set name
- Type the name of the data set to which you want
to export the files, or click Browse to browse for
the destination data set.
- Member name
- Type the name that you want to give to the member that will contain the
SQL scripts.