Use this utility to generate DDL (Data Definition Language) files from your DFD files. DDL files consist of the SQL statements that create your tables and views. This is helpful if you have an RDBMS database where an administrator is required to create tables and indexes and users are not typically granted those privileges.
DFD2DDLW /I /O /D /T /S /P /L
|
Parameter |
Description |
|
/I |
Enter the name of the DFD file. Include the full or relative path. |
|
/O |
Enter the name you want the utility to assign to the DDL file it will create. The default is the DDLFile root plus the extension .SQL. |
|
/D |
Enter the name of the target database. You can choose from: MSSQL, DB2, Oracle, MySQL. The default is MSSQL. |
|
/T |
Enter the name of the target table. The default is the DFD root name. |
|
/S |
(Optional) Enter the name of the target schema. This is typically used for Oracle schema, DB2 schema, and MSSQL DBowner. |
|
/P |
(Optional) Enter the name of the primary table index. This allows for unique constraints on key fields. |
|
/L |
(Optional) Enter the name of the target location. This is used for DB2 (location) and MySQL (database name). |
Avoid the following ExtTypes because they are not supported as external data types in Documaker’s database handlers:
© Copyright 2012, Oracle and/or its affiliates. All rights reserved. Legal notices.