Packages and application plans

A package contains control structures that DB2 uses when it runs SQL statements. Packages are produced during program preparation. You can think of the control structures as the bound or operational form of SQL statements. All control structures in a package are derived from the SQL statements that are embedded in a single source program.

An application plan relates an application process to a local instance of DB2, specifies processing options, and contains one or both of the following elements:

  • A list of package names

  • The bound form of SQL statements

Most DB2 applications require an application plan. Packages make application programs more flexible and easier to maintain. For example, when you use packages, you ...

Get Official Introduction to DB2® for z/OS®, The, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.