The Update/Add Rule dialog box provides a method of adding or updating the object rules that affect an object. All available options are specifically generated to be appropriate to the type of DDL object being modified. The example above shows one section of the Update/Add Rule dialog box for table type DDL code.

Using the Update/Add Rule Dialog Box

To add or change an object rule locate the component you wish to modify and check the box beside it. This will cause the specific options for that component to enable. Select the option you wish, fill in any required information and press one of the Apply buttons in the lower right hand corner. The Apply buttons will only become active when there are unsaved changes.

What the Apply buttons do

Apply These Changes to This Object Only

If this button is pressed, the changes made will only affect the one specific object being edited. This means that the object rule will be created with specific user, object type and object name fields. Use this button when the changes just made are intended to apply to a single object.

Apply These Changes to all Appropriate Objects

If this button is pressed, the changes made will be applied in the most general sense possible. This means that the object rule will be created specifying all users, all relevant object types and a wild card of * for the name. Use this button to apply the changes just made to all relevant types of objects. Note: Rules created with this button really are as global as possible. For example: if you create a rule that removes storage clauses and press this button then the newly created object rule would affect every object type that uses storage clauses (tables, indexes etc.).

Custom Rule Apply

This button launches the Custom Rule Apply dialog box which allows the target user, object type and object name fields to be specified exactly. Use this button if you need to apply the object rule changes to a targeted group of DDL objects.

Remember: Any DDL object can be targeted by multiple rules. If there is more than one object rule affecting a specific component (PCTFREE for example), then the most specific applicable object rule will be used.

---

[Net 2000 Ltd. Home][DDL Wizard Home][DDL Wizard Manual][DDL Wizard FAQ]