bldibmddl - Build Data Definition Language
bldibmddl [-UqaoRDTIGECKBWXSV] [-u DbLoginName] [-p Password] DataArea [SystemCode] [FileName ...]
The bldibmddl
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. It 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.
The bldibmddl
utility can be run to create an output file containing the SQL statements, or it can be run in update mode to implement changes to the SQL database objects.
This utility is securable and if a security violation is encountered, access must be granted to the token through LSA. To grant a user access, see the Resources and Security Administration Guide.
Program Option | Description |
---|---|
U |
Update; create objects in the database. If you use the |
q |
Quiet mode. Do not echo DDL to stdout. |
a |
Positioning mode. Start at dataarea [systemcode] filename. If you use the |
o |
Offline Mode. Do not connect to the database |
R |
Rebuild mode. Drop objects before creating. If you do not specify either the |
D |
Drop objects only. If you do not specify either the |
T |
Affect table objects only. If you do not specify the |
I |
Affect index objects only. If you do not specify the |
G |
Affect trigger objects only. |
B |
Affect non-native objects only. Cannot be used with |
E |
Affect text indexes only. Requires the |
C |
Rebuild the conditional indexes. |
K |
Create an additional index without a descending column for the primary key constraint. Use this option if you need to replicate an IBM DB2 table that has a descending column. Requires the Running The |
W |
Affect native view objects only. Cannot be used with |
X |
Affect non-native view objects only. Cannot be used with |
S |
Generate DDL into files by system codes: dbname . systemcode .ddl . |
V |
Print the utility version. |