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


Export SQL wizard

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 File > Export 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.


Feedback

Update icon Last updated: 2006-12-15