Browse Prior Art Database

Support of Multiple Like SQL Statements in REXX

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

Publishing Venue

IBM

Related People

Boykin, JR: AUTHOR

Abstract

Disclosed is a method of supporting multiple dynamic SQL statements in a single application in the OS/2* Extended Edition Database Manager with one each of PREPARE, DESCRIBE, EXECUTE, OPEN, FETCH and CLOSE statements.

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

Support of Multiple Like SQL Statements in REXX

      Disclosed is a method of supporting multiple dynamic SQL
statements in a single application in the OS/2* Extended Edition
Database Manager with one each of PREPARE, DESCRIBE, EXECUTE, OPEN,
FETCH and CLOSE statements.

      The Database Manager Precompilers require a set of SQL
statements per unique section of an application.  This is because the
statements are uniquely identified by the identifiers contained
within the statements (e.g., FETCH C1 INTO ...).  Access sections are
assigned to dynamic statements per each DECLARE CURSOR statement,
each PREPARE statement which does not reference a previous DECLARE
CURSOR statement and one per all EXECUTE IMMEDIATE statements.  In
order to fetch rows from 100 cursors, 100 differing FETCH statements
are typically needed.

      To simplify implementation of the REXX support for the Database
Manager, there is only one each of PREPARE, DESCRIBE, EXECUTE, OPEN,
FETCH and CLOSE statements. However, there are 100 unique DECLARE
CURSOR statements.

      Precompilation of the SQL statements above, with the exception
of the DECLARE CURSOR statement are transformed into several run-time
calls.  One of these run-time calls in the C language is a call to
function sqlacall. Sqlacall is documented in the Precompiler
Customization section of the "Operating System/2 Extended Edition
Version 1.2 Database Manager Programming Guide and Reference Volume
2: Reference."  The t...