Enabling or disabling pluggable SQL at runtime

You can enable or disable pluggable SQL support for a specific domain or inquiry level.

Procedure

  1. Open the properties file tcrm_extension.properties.
  2. Add the optimized.sql property as required. The following values are valid:
    • true: enables the pluggable SQL feature with inquiry levels. This is the default setting.
    • false: disables the pluggable SQL feature with inquiry levels.
  3. To disable or later re-enable pluggable SQL support for a specific domain or inquiry level:
    • To disable pluggable SQL support, locate the record in the INQLVLQUERY table that corresponds to the inquiry level you wish to remove and set the value in its END_DT column to the current time stamp. This will expire the record.
      Note: Ensure that you keep the optimized.sql property in the tcrm_extension.properties file set to true. This value is required to ensure continued support of the pluggable SQL feature for other domains.
    • To re-enable pluggable SQL support for a domain or inquiry level that has been expired, locate the record in the INQLVLQUERY table that corresponds to the inquiry level you want to enable and set the value in its END_DT column to either a future date or null.