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.