CDM model in PD, FAQs

In PD, the CDM model is created. A digoal has two tables, and the fields cannot be repeated?

Tool-model options-model settings remove the unique code under data item

There is also a "allow reuse" check box. We recommend that you remove this check box. In the future, don't worry about the problem of field dynamic modification in the model. I just tried it, even if you copy a field from one table to another, the two fields are not modified!

We recommend that you remove both hooks and click "set as default" to set this to the default setting.

When a table creation script is generated by PDM, an error occurs when the field exceeds 15 characters (Oracle)
Unknown cause. The solution is to open the PDM, And the menu bar of the database appears. Go to database-edit current DBMS-script-objects-column-maxlen and increase the value (Originally 30 ), for example, change to 60. If the length of a table or other objects is incorrect, you can select the corresponding objects!

3. How do I remove the double quotation marks of an object from the generated table creation script?
When CDM is enabled, go to tools-model options-naming convention and set the charcter case option of the name and code labels to uppercase or lowercase, as long as it is not a mixed case!
Alternatively, choose database-> edit current database-> script-> SQL-> Format. There is a casesensitivityusingquote, its comment is "determines if the case sensitivity for identifiers is managed using double quotes", which indicates whether double quotation marks are used to specify the case sensitivity of the identifier. You can see that the default value of values on the right is "yes ", change to "no!
Alternatively, when PDM is enabled, go to tools-model options-naming convention and set the charcter case option of the name and code labels to uppercase!
----------------------------------------------------
5. Remove the double quotation marks of the generated SQL Script: Oracle 8i2: script \ SQL \ format \ casesensitivityusingquote to No. The default value is yes, so there will be double quotation marks.

When changing the name, the code value will change, which is inconvenient. Modification Method: Modify the Options menu in powerdesign. In [Tool] --> [General options]-> [Dialog]-> [operating modes]-> [name to code signing ing], by default, the name and code are synchronized. just remove the check box above.

CDM model in PD, FAQs