Browse Prior Art Database

SQL Package Creation and Distribution

IP.com Disclosure Number: IPCOM000122367D
Original Publication Date: 1991-Dec-01
Included in the Prior Art Database: 2005-Apr-04
Document File: 2 page(s) / 73K

Publishing Venue

IBM

Related People

Anderson, MJ: AUTHOR [+4]

Abstract

A method is described for distributing SQL packages to multiple distributed systems. This is used in the implementation of Distributed Relational Database Architecture (DRDA).

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

SQL Package Creation and Distribution

      A method is described for distributing SQL packages to
multiple distributed systems.  This is used in the implementation of
Distributed Relational Database Architecture (DRDA).

      INTRODUCTION:  Three methods were implemented to allow
distribution of packages to multiple application servers:
-  Create an SQL package from an existing distributed SQL program
instead of the source.
-  Create multiple SQL packages from the same program.
-  Allow SQL packages to be saved and then restored to other AS/400*
Systems.

      PACKAGE CREATION:  During SQL distributed program creation, all
information needed to create the package is stored in the SQL area of
the associated space of the program.  Package creation is implemented
on the AS/400 by processing this area.

      A parameter on the SQL preprocessor command indicates if the
program is a distributed program.  If the program is a distributed
program, the SQL preprocessor will generate a consistency token that
is used at runtime to ensure the package and the program were created
from the same source with the same options.  It should be noted that
if the precompile step is repeated, a new consistency token will be
generated.

      After the distributed program has been compiled, an SQL package
can be created at a specified application server. The AS/400
application requester retrieves the consistency token and information
about each SQL statement from the SQL area of the associated space of
the program and generates the appropriate DRDA bind flows.  Since the
consistency token and the information about each SQL statement is
stored in the SQL ar...