Editing the DDL

In the Change Record Indexes dialog box, you can view the DDL for the index and override DDL parameters that are defined in the DDL model for this index.

To edit the DDL:

1. In the Change Record Indexes dialog box, select the index that you want to edit.

2. Click the Edit DDL button to access the Maintain Index DDL dialog box.

   The upper list box in this dialog box lists the platform and DDL parameter, and the lower list box shows the DDL templates for the various platforms. Your database might have fewer platforms enabled. The sizing set enables different collections of tables to have different model statements and parameters.

3. Select the platform and sizing set.

4. Click View DDL.

   The dialog box that appears shows the index DDL for the platform and sizing set that you selected. Review this DDL statement.

5. Click the Close button when you are finished.

6. Select the parameter that you want to edit in the upper list box.

   The default value is set in the DDL Model Defaults dialog box. You can change this setting by selecting Go, and then PeopleTools, and then Utilities, and then Use, and then DDL Model Defaults in PeopleSoft Application Designer, or by selecting PeopleTools, and then Utilities, and then Use, and then DDL Model Defaults in the browser.

7. Click the Edit Parm (edit parameter) button to access the Edit Override Parm Value (edit override parameter value) dialog box.

8. Enter the override value for the parameter that you selected.

9. Select OK for both open dialog boxes.