Validate SQL Scripts

The Validate SQL Scripts option allows you to validate the SQL scripts for SDL-related keywords in the package. This validation can be performed before the package is installed or updated. This option is available in the Additional Settings pane in the Add to Package Template and/or Edit Package Template pages.

For example: If you want to install a Package that has multiple SQL scripts, then all the SQL scripts are validated before the package is installed.

To validate SQL scripts

1. Select and right-click the artifact that you want to package, and then click Add to Package Template on the shortcut menu. The Select Package Template page appears.

2. Select the Package Template.

3. Select Package Template Version, Include Associated Artifacts, Include Child Artifacts, Include Security Artifacts, and Include the automatically generated SQL Script.

4. Click Next. The Add to Package Template page appears.

5. In the Configuration section, click Additional Settings.

   The Settings page appears on the right pane.

6. For the Validate SQL scripts property, select one of the following:

   • Yes: Select this option if all the SQL scripts in the package must be validated before the package is installed or updated. The default value is Yes.

     If this option is selected, then the Validate SQL Scripts button is enabled in the Settings form of each of the following artifacts, and the SQL scripts for these artifacts can be validated.

     • Database Connection

     • Database Activity

     • Custom Queue

     • Database Query Lookup

     • Procedure Lookup

     • Custom List

     If you edit the settings for an artifact and click any other tree node, the SQL script is validated. If there are no restricted keywords, settings will be cached and the focus will be moved to the newly selected tree node.

     However, if there are no restricted keywords, then the settings will not be cached. Also, you will neither be allowed to select another tree node nor save the package template.

   • No: Select this option if all the SQL scripts in the package need not be validated before the package is installed or updated. Select this option only when all the SQL scripts in the package are valid.

     If this option is selected, then the Validate SQL Scripts button is disabled in the Settings form of each of the above-mentioned artifacts, and the SQL scripts for these artifacts are not validated.

     If you edit the settings for an artifact and click any other tree node, the settings will be cached. The SQL script is not validated.

     Note: If you do not want to validate SQL scripts, then it is recommended to set the value of the Validate SQL scripts property to No while creating a package template, and then add the required artifacts to the package template.

7. In the Settings page, click Save Settings and then click Save Template.

   The package template settings are saved.