Generating the SQL

Generated files

On a work product, the "SQL Designer/Generate SQL files" command produces a relational diagram. By default, two files are produced. They are located in the directory indicated in the generation work product's dialog box, and are called:

unit_name_create.sql

and

unit_name_delete.sql

For attributes that have been annotated {alterTable}, a third file is generated:

unit_name_alter.sql

The file suffix can be parameterized at GUI configuration level.

Figure 71. The generation work product dialog box

Selection

If generation is activated from a parent physical model or a package, then it is linked to all the tables belonging to it. Generation cannot be launched from a table.

Figure 72. Generating the SQL files for the "MPD_Library" package

Steps:

1. Right-click on the SQL generation work product belonging to the "MPD_Library" package.

2. Run the "MDACs/SQL Designer/Generate SQL files" command from the context menu that appears.

Alternatively, right-click on the package and then run the "MDACs/SQL Designer/Generate SQL" commands

Note: Double-clicking on the generation work product runs the "Propagate" command for this work product.