Browse Prior Art Database

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

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

Publishing Venue

IBM

Related People

Boykin, JR: AUTHOR [+2]

Abstract

A method is described which will provide an SQL facility to create SQLDA (SQL Descriptor Area) data areas from 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 52% of the total text.

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

      A method is described which will provide an SQL facility
to create SQLDA (SQL Descriptor Area) data areas from 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 with the PREPARE,  OPEN,
FETCH, and EXECUTE statements.  The SQLDA is also used as input  and
output to and from server procedures for the OS/2 EE Database Manager
Database Application Remote Interface (DARI).

      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 generation and
manipulation the CONSTRUCT DESCRIPTOR AREA SQL statement will be
provided.  The syntax information for the statement is as follows:
CONSTRUCT DESCRIPTOR AREA

      The CONSTRUCT DESCRIPTOR AREA builds an SQLDA from a group of
host variables.  The interface is as follows:
CONSTRUCT DESCRIPTOR AREA
   descriptor-name
     Identifies an SQLDA which is to be filled with the information
which is held in the list of host variables identified in the USING
clause.  These must be described in the program in ac     cordance
with the rules of declaring host variables.
USING
   host-variable
     Identifies a list of host variables which are used in the con
struction of the SQLDA.  These must be described in the program in
accordance with the rules of declaring host variables.
FOR
   APPEND
     This option will add sqlvars to the existing SQLDA without dis
turbing any existing sqlvars.  Input will be from the host vari
able list identified in the USING clause.  This option will cause the
reallocation/copy of the existing SQLDA elements along with the
addition of the new elements identified by the host variable list.
Additionally, the sqln and sqld fields will be updated accordingly.
It is only valid with SQLDA generated by a CONSTRUCT statement.
FILL

      This option will use an existing SQLDA.  The contents of the
sqldata and the sqlind fields of the sqlvars will be filled with the
data from the host variable list identifie...