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 . 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
optionsOption |
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.
|