Share this page

# Updating the Database Table

This section details how to copy the modified SQL to the validation in the database table.

Note: Updating the database requires privileges a DBA might not want to grant to the application administrator.

To update the database table:

1. Connect to the database containing the database schema.

2. Update the database table as follows, where the modified SQL you copy from the editor is designated in the following bullets as `<`new validation sql`>:`

   - For projects, add the following:

         Update Knta_validations set validations_sql
         = '<new validation sql>' where
         validations_id=3079

   - For tasks, add the following:

         Update Knta_validations set validations_sql
         = '<new validation sql>
         ' where validations_id=2693

   - For requests or packages, add the following:

         Update Knta_validations set validations_sql
         = '<new validation sql>' where
         validations_id=826

3. Stop, then restart the PPM Server so that the changes take effect.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: