Browse Prior Art Database

Reduce Descriptor Area SQL Statement for the OS/2 Database Manager

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

Publishing Venue

IBM

Related People

Boykin, JR: AUTHOR [+2]

Abstract

A method is described which will provide a facility to break down SQLDA (SQL Descriptor Area) data areas into a list of host variables. The invention is being proposed to the SQL Language Council as an SQL extension to the SAA (System Application Architecture) Database CPI (Common Programming Interface).

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

Reduce Descriptor Area SQL Statement for the OS/2 Database Manager

      A method is described which will provide a facility to
break down SQLDA (SQL Descriptor Area) data areas into a list of host
variables.  The invention is being proposed to the SQL Language
Council as an SQL extension to the SAA (System Application
Architecture) Database CPI (Common Programming Interface).

      The SQLDA is a data area which is required for execution on the
DESCRIBE SQL statement and is optional on the PREPARE, OPEN, FETCH,
and EXECUTE statements.  The SQLDA is also used as input and output
to and from server procedures when used with the OS/2* EE Database
Manager Database Application Remote Interface.

      The SQLDA data structure is a very awkward and cumbersome data
structure to use.  In FORTRAN, due to an innate language restriction,
its proper use is precluded due to its inability to support more than
one level of indirection for data structures.  During all levels of
test for OS/2 EE 1.2 dealing with DARI, one of the major obstacles
was SQLDA "handling".

      To insulate the user from troublesome SQLDA decomposition and
manipulation the REDUCE DESCRIPTOR AREA SQL statement will be
provided.  The syntax information for the statement is as follows:
REDUCE DESCRIPTOR AREA

      The REDUCE DESCRIPTOR AREA would decompose an SQLDA into host
variables.  The interface is as follows:
REDUCE DESCRIPTOR AREA
  descriptor-name
 Identifies an SQLDA which is...