1. Applications Upgrade Guide for IBM i with DB2 for IBM i
  2. Dropping SQL Packages

Dropping SQL Packages

When upgrading with IBM i data sources, the SQL packages must be dropped before starting the planner. The IBM i caches the table layout in the SQL package and does not look at what the current table layout is. If the SQL packages are not dropped, errors may occur in tables with changed formats.

To drop SQL packages:

  1. Ensure that JD Edwards EnterpriseOne is shut down (or make sure that you have not attached to the IBM i yet).

  2. On the IBM i, for each Business Data and Control Tables library, enter the following:

    WRKOBJ OBJ(xx\*ALL) OBJTYPE(*SQLPKG) , where xx is your library

    or

    WRKOBJ OBJ(*ALLUSR\*ALL) OBJTYPE(*SQLPKG) and choose your business data and control table libraries from the list.

  3. Type a 4 next to each of the packages, and press Enter.