Generate DDL utility

The Generate DDL Utility screen shown in the following figure is displayed when you select Option 4, Generate DDL, from the Utilities Menu.

Beginning with File-AID/RDX Release 4.6, the extract files no longer contained readable DDL that described the source environment.

Use this screen to initiate the utility that converts the masked Db2 DDL statements from a File-AID/RDX extract file and places them into an output file in a readable format.

Generate DDL Utility

On this screen you specify the input extract file or extract summary file, the output DDL file and whether to process the request in online or batch mode.

Enter GEN to execute the utility in online mode. After you enter GEN and successful conversion, File-AID/RDX displays the message: Generate process complete.

Or, enter JCL to view the generated JCL or GO to submit the job in batch mode.

Specify Input Extract File or Summary File:

If the extract file is on tape, specify the summary file you created for it (see also Summary File in section Request-File-Member-List-panel-in-the-Load-function).

INPUT File name

Specify the name of the input extract file or extract summary file. An asterisk (*) or pattern displays a selection list.

Member

Specify the member name of the input extract file, if the extract file is a PDS. Specifying a pattern allows you to select a member.

VOLSER

Specify the volume serial of the direct access device that contains the file.

Specify Output File

This section provides information about the following fields:

OUTPUT File name

Specify the name of the output file that will contain the DDL statements from the above specified input extract file.

Member

Specify the member name of the output DDL file, if it is a PDS. Specifying a pattern allows you to select a member.

VOLSER

Specify the volume serial of the direct access device that contains the file.

Disposition

Specify the disposition of the output DDL file. You can save to existing files with a disposition of OLD. Specify a disposition of NEW to create a new PDS or sequential file.

If you specify NEW in the Disposition field, you must specify the allocation parameters in the Create New File screen.

Remember to allocate an adequate amount of space for the output DDL file to avoid out of space conditions (SB37).

Primary Commands

The following File-AID/RDX-specific primary commands are valid on this screen:

GEN

Processes the Generate DDL utility request in online mode. Before issuing the GEN command, make sure you have specified the desired input and output files. File-AID/RDX will issue a message upon completion.

GO (G)

Submits this Generate DDL job request without displaying the JCL. Before issuing the GO command, make sure you have specified the input and output files.

JCL

View the JCL for the Generate DDL utility in batch mode. File-AID/RDX shows the Generated JCL panel (ISPF/PDF EDIT Screen—File-AID/RDX-generated JCL) where you review and modify the JCL. Enter the SUBMIT command to submit the job.

View JCL

The ISPF/PDF Edit screen shown in the following figure is displayed when you enter the JCL command in the Generate DDL Utility panel.

ISPF/PDF EDIT Screen—File-AID/RDX-generated JCL - Generate DDL

Use this screen to view or edit the JCL generated by File-AID/RDX to convert the masked Db2 DDL statements from a File-AID/RDX extract file and place them into an output file in a readable format. Use the SUBMIT command to submit the job for execution. If you want to save this JCL, use the ISPF/PDF CREATE or REPLACE command before you exit the panel.

Report

A report (see the following figure) will be produced at the end of the batch  Generate DDL Utility processing.

Generate DDL Utility Report