Lookup Example Scenarios

Scenario 1: Defining the uninstall properties for the lookup where the lookup is modified after it is installed in the target environment

Consider the following:

• A database lookup, TelematicsDBLookup

• The database lookup contains a query, Select * from SWExecute

• In the target environment, the query Select * from SWExecute is modified to Select * from SWExecute Where ID=1

To define the uninstall properties

1. Add the database lookup, TelematicsDBLookup to the package template, TelematicsDBKLookupPackage.

2. In the Package Template window, select TelematicsDBLookup, go to the Settings page, and then click the Uninstall tab.

3. Define the Uninstall properties as the following:

   Lookup is modified: Use this property to retain, rollback the database lookup to the original state, or delete the database lookup in the target environment after the package is uninstalled.

   • Retain: Select this option to retain TelematicsDBLookup along with the modifications, that is, retain the modified query Select * from SWExecute Where ID=1 in the target environment even after the package is uninstalled.

   • Rollback to original state: Select this option to rollback the database lookup to the original state, that is, revert the modifications and update the query as Select * from SWExecute, and retain the database lookup in the target environment even after the package is uninstalled.

   • Delete: Select this option to delete TelematicsDBLookup from the target environment while uninstalling the package.

Scenario 2:Defining the uninstall properties for a lookup where the lookup was already present in the target environment before installing the package

Consider the following:

• A database lookup, TelematicsDBLookup2, is already present in the target environment

• Description of TelematicsDBLookup2 is Lookup for Telematics2

• The same database lookup, TelematicsDBLookup, with description as Database Lookup for Telematics2 is being added the package template

4. Add the database lookup, TelematicsDBLookup2, with the description as Database Lookup for Telematics2 to the package template, TelematicsDBKLookupPackage2.

5. In the Package Template window, select TelematicsDBLookup2 and go to the Settings page, and then click the Uninstall tab.

6. Define the uninstall properties as following:

   • Retain: Select this option to retain TelematicsDBLookup with the updated description Database Lookup for Telematics2 in the target environment even after the package is uninstalled.

   • Rollback to original state: Select this option to rollback to the original state, that is, retain the original lookup TelematicsDBLookup2 with description as Lookup for Telematics2 which was present in the target environment before installing the package.

   • Delete: Select this option to delete TelematicsDBLookup from the target environment when uninstalling the package.