What Is the Build Data Definition Language Utility?

The bldora11ddl / bldora12ddl (Build Oracle Data Definition Language) utility generates SQL statements for creating or deleting selected tables, indexes, and stored procedures. The utility can operate on specific tables, all tables in a system code, or all tables in a product line or data area. The utility creates Data Definition Language (DDL) text according to the highest possible version with the given compatibility. The definitions that generate the SQL statements reside in the Lawson dictionary and are maintained by Lawson utilities.

Note:  A PL/SQL block is generated after the creation of each table. For installations where the Oracle compatible parameter is set to 8.0.x, the PL/SQL block sets the table version stamp in law_dba_comments.

The bldora11ddl / bldora12ddl utility can be used to:

  • Generate DDL for the Lawson tables and indexes.

  • Repair problems that are identified by the verifyora11 / verifyora12 utility.

  • Drop and recreate tables or indexes that are out of sync with the Lawson data dictionary or are somehow missing, or to conserve space and enhance performance (-IR).

  • Generate DDL statements to a file for examination or tweaking.

  • Drop indexes before you load data, then rebuild the indexes after the data is loaded (-DI and -I).

  • Truncate a table by dropping and recreating it (-R).

  • Rebuild the additional index that allows you to use primary key constraints on descending columns (-K).

If a table or index needs rebuilding or modification without going through the reorganization process, or if you want to make changes to the definition statements issued by Lawson to Oracle, use the bldora11ddl / bldora12ddl utility supplied by Lawson.

To ensure that no one else uses the file containing the generated DDL, execute this utility from a secured directory or change the permissions on the file. After you have used the file, delete it.