Browse Prior Art Database

Call-type Api to Sql/Ds With Externally Described Operations

IP.com Disclosure Number: IPCOM000099754D
Original Publication Date: 1990-Feb-01
Included in the Prior Art Database: 2005-Mar-15
Document File: 5 page(s) / 188K

Publishing Venue

IBM

Related People

Ritland, SR: AUTHOR

Abstract

A method is described which specifies and names structured-query- language data-manipulation-language (SQL DML) operations independently from any of the programs that use them, a generalized SQL statement processor for generating access modules and other data structures used at run-time, and the run-time support itself.

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

Call-type Api to Sql/Ds With Externally Described Operations

       A method is described which specifies and names
structured-query- language data-manipulation-language (SQL DML)
operations independently from any of the programs that use them, a
generalized SQL statement processor for generating access modules and
other data structures used at run-time, and the run-time support
itself.

      This method comprises:
-    A method of specifying and processing SQL DML statements in a
form external to the application programs that use them.  A set of
SQL statements is stored in a CMS file called a 'template'.  An
SQL/DS table description is optionally placed in a template file, in
which case a set of basic SQL statements to access data in that table
are automatically generated and appended to the template file.
-    A data structure called an SQL Operation Descriptor (SOD)
produced by the processing of a template.  The SQL SOD contains
information required at run-time.
-    Two programs for processing the template files.
-    An application programming interface (API) consisting of control
functions and a set of data access functions referencing the SQL
statements predefined in template files.
-    A run-time module which uses the SODs and parameters passed on
calls to perform the data control and access functions.
-    The environment and a program to initialize it.

      Template files contain one or multiple SQL statements, each of
which is referenced by a name.  A special type of template is used as
input to a table-creation process. These are called 'table templates'
and contain, possibly in addition to SQL DML statements, the
description of an SQL table to be created.  Besides creating the SQL
table, the table template processor also generates SQL statements
which are appended to the template to do basic operations on the
associated table.

      Each SQL statement in a template is prefixed by a name
delimited by a ':'.  The SQL statements are coded in a form very
similar to that of the extended dynamic form of SQL/DS DML, in which
?'s are used as place holders for host program input variables.

      In a table template, a table description is placed at the
beginning of the file, just following the header record which
indicates the template name and type.  Each table column (field) is
represented by a row in the table definition section.  That row
specifies the column name, its data type, its length, whether it is a
part of the table's unique index, and whether it can have a NULL
value.

      THE SQL SOD STRUCTURE.  The SOD data structure is used at run-
time along with information stored in an SQL/DS access module to
inform a data base management system (DBMS) how to carry out a
particular operation.

      Information about the operands participating in any SQL DML
operation is passed to the DBMS in a data structure called SQLDA.
The SOD and process for generating it provide cer...