Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Managing a Program's Set of SQL Statements in a Database Environment

IP.com Disclosure Number: IPCOM000121369D
Original Publication Date: 1991-Aug-01
Included in the Prior Art Database: 2005-Apr-03
Document File: 1 page(s) / 38K

Publishing Venue

IBM

Related People

Haderle, DJ: AUTHOR [+3]

Abstract

A process is disclosed for managing versions of a program's SQL statements and the program's access to databases using these statements in a database management system (DBMS). This process makes use of a versioning value assigned to a program during the precompilation of the program, a DBMS construct called a Package, and another DBMS construct called a plan. A package contains the DBMS operational constructs of a program's SQL statements used to access databases. It is created for each version of a program containing SQL statements. The package is assigned the same versioning value as the program. A plan is created which list the set of packages an application can use to access databases. Multiple versions of a package can be listed. A user must be authorized to use a plan.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 86% of the total text.

Managing a Program's Set of SQL Statements in a Database Environment

      A process is disclosed for managing versions of a
program's SQL statements and the program's access to databases using
these statements in a database management system (DBMS). This process
makes use of a versioning value assigned to a program during the
precompilation of the program, a DBMS construct called a Package, and
another DBMS construct called a plan.  A package contains the DBMS
operational constructs of a program's SQL statements used to access
databases.  It is created for each version of a program containing
SQL statements.  The package is assigned the same versioning value as
the program.  A plan is created which list the set of packages an
application can use to access databases.  Multiple versions of a
package can be listed.  A user must be authorized to use a plan.

      When an application is used to access a database, it must
select a Plan to use.  Once a plan is selected, and the DBMS has
checked for proper authorization to use the plan, the application may
execute any version of a program that has its package listed in the
plan.  When a program makes a request to the DBMS to access a
database, the program passes to the DBMS the program name, the
versioning value, plus an unique value identifying which one of its
SQL statements is to be processed.  The DBMS uses these parameters to
find the operational construct previously created to process the
request.  Any req...