Opening your Target DBMS Definition File in the Target Editor

You can consult or modify a DBMS definition file using the Resource Editor. When you select a category or an item in the left-hand pane, the name, value, and related comment appear in the right side of the dialog box.

Select Database > Edit current DBMS

The DBMS Properties dialog box is displayed.

Note:

You should never modify the DBMS files shipped with PowerDesigner. You should instead copy the DBMS to create a new one. To do so, create a new DBMS from the List of DBMS, define a name, and then select the original file in the Copy From list.

For more information on using the editor, see Working with the Resource Editor.

DBMS Definition File Structure
All DBMS definition files have the same structure made up of a number of categories, each of which may contain items or other categories. The items, and their values are different for each DBMS. Each item is present only if it is relevant to the DBMS. Each value is a SQL statement or other parameter to define how to model, generate and reverse engineer for the DBMS.

Parent topic: DBMS Resource File Reference

Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com