Rational Programming Patterns

The Database Block generation wizard

In this wizard, you indicate where the output file (.txt) must be saved after the selected Block has been generated.

To open the Database Block generation wizard, right-click the Database Block instance that you want to generate in the Design Explorer view, and select Generate > Database Block generation. A generation wizard opens, with the following fields to complete:
To the Folder
When the Database Block instance has been selected, this field is automatically completed with the path to the location where the instance is saved. You can enter the path to any Folder or use the Browse button.
File name
Enter the name of the output file, with the .txt extension.
Option choice
This field is available for relational databases only. You must select the generation option:
Table 1. list of the available options
Option Generation content
C1 Generation of Creation DDL (CREATE DATABASE and CREATE of all the objects of the Block)
C2 Generation of the DDL according to the value selected in the Generation transaction type field (in the -DR Lines tab).
C3 Generation of the LABEL command for DB2, SQL/DS, and SQL400 databases.
C4 Generation of the COMMENT command for DB2, SQL/DS, SQL400, ORACLE, and NONSTOP/SQL databases.

The date, time and session number will be displayed on the first line of the generated program.


Terms of use | Feedback

This information center is powered by Eclipse technology. (http://www.eclipse.org)