Generating a Database Block

After all the required information is entered in the Block design editor, you can generate the Block in the Data Description Language (DDL).

Before you begin

You can first decide where the files are to be generated. Refer to the link about the target of the generated files for more explanations.

About this task

The DDL is generated according to the logical information that is pecified in the Block design, with the Data Elements and Segments that define the tables, views, and indexes. The generation also takes into account the physical information that is entered on the -GG Lines associated with the Block definition and description lines.
Note: For the instances that are imported from Pacbase, the skeleton language of the local generation is identical to the Pacbase skeleton language. This piece of information is retrieved from the extraction of the Pacbase models and from the import. It is stored on the Library.

Procedure

You can generate a Database Block in two different ways:

Results

A progress information message box is displayed until the generation is complete.

The generation produces a .dll file (for a relational Block) or a .txt file (for the other Blocks) file under the instance in the Design Explorer view. Right-click it and select Open with > SQL file editor to access the DDL.

The generation also produces the corresponding metadata files:.dllpdp (for a relational Block) or a .txtpdp file (for the other Blocks).


Feedback