Chapter 3 DBMS Reference Guide
The Script category is used for the Script generation and reverse engineering, and ODBC reverse engineering.
The ODBC category is used for the ODBC generation queries when the DBMS does not support standard statements for generation. Note that some DBMS will not display an ODBC category as it is not necessary to their definition.
When a command value or its category is missing during the ODBC generation, PowerDesigner searches for it in the Script category. As a consequence, an entry is redefined in the ODBC category only if it is different from the Script value.
Both Script and ODBC categories contain the following categories:
| Categories | Description |
|---|---|
| SQL | Contains categories Syntax, Format, File, and Keywords. Each category contains entries whose values define general syntax for the database |
| Objects | Contains categories for each type of object in the database. Each category contains entries whose values define database commands and object-related characteristics |
| Data Type | Contains data type translation entries. These entries list the correspondence between PowerDesigner internal data types and the target database data types |
| Customize | Retrieves information from PowerDesigner Version 6 DBMS definition files. It is not used in later versions |
In the definition file of Sybase Adaptive Server Anywhere 6, the Script category is expanded to show the category Objects where Index is also expanded. The Create
entry is selected and the Value box associated with this command defines how the index is created.
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |