End User Code Objects

Object Customization Process

The following outlines the steps the end user must perform in order to implement customized SQL code objects:

1. On initial installation of build (including initial installation of a LeasePak release)
   1. Determine which custom code objects are to be customized
   2. Copy those code object files to the appropriate DBMS' cql subdirectory within $CSTDIR
   3. Perform desired customizations, including creation of user code objects and a load sequence file if necessary
   4. Unit test the customized code by
      1. Dropping the existing end user code objects from the targeted logical LeasePak database using db_drop_code
      2. Loading the customized code into the targeted logical LeasePak database using db_load_code
      3. Granting necessary privileges to the database users of the targeted logical LeasePak database using db_set_securitydb_set_security
      For more information, see Custom Code Options in LeasePak Server Scripts
   5. Execute the pertinent LeasePak functionality within the targeted LeasePak database (LLDB)
2. Once the code has been customized, new LeasePak databases may be built, existing LeasePak environments in prior releases may be upgraded, or existing environments in the current release may be updated as described above
3. On installation of a new build into an existing LeasePak release
   1. Determine if there have been any changes made to the interfaces (that is, parameter lists or contents of returned result sets) or functionality or implementation details of any of the custom procedures that the end user previously has customized
   2. Alter the customized copies of such code objects as have changed so that they are compatible with the new build
   3. Unit test the customized code by loading the current version of the custom and user code objects using db_load_code and then executing the pertinent LeasePak functionality