Browse Prior Art Database

Support of User-Specified SQL Cursor Options in a Dynamic SQL Environment

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

Publishing Venue

IBM

Related People

Boykin, JR: AUTHOR

Abstract

Disclosed is the method for supporting user-specified cursor options in a situation where precompilation and static SQL are not supported. This method is implemented in the REXX support for the OS/2* Extended Edition Database Manager.

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

Support of User-Specified SQL Cursor Options in a Dynamic SQL Environment

      Disclosed is the method for supporting user-specified
cursor options in a situation where precompilation and static SQL are
not supported.  This method is implemented in the REXX support for
the OS/2* Extended Edition Database Manager.

      In the Database Manager, cursors and their options must be
predefined via embedded SQL in an application program and the
application program must be precompiled, compiled and linked prior to
use of the cursors at run-time.  A cursor's options may include the
WITH HOLD specification which allows the definition of a cursor to
span multiple transactions and possible future additional cursor
options.  In the Database Manager support in the REXX language,
precompilation is not required for the REXX programmer, nor is it
consistent with the nature of the REXX language. However, SQL cursors
are still needed in order to fully support SQL.

      In the REXX support in the Database Manager, combinations of
predefined cursors and available options are specified in the
underlying applications which support the REXX interface.  These
cursors are used to support the REXX programmer's cursors specified
at run-time of the REXX program.  The support of the REXX
programmer's cursors is internally mapped in the Database Manager
supporting code to the actual cursors predefined in the supporting
applications with the user's required cursor options.  Additionally,
the REXX programmer does not need to realize this action is t...