Browse Prior Art Database

Generalized SQL Support for Client Applications

IP.com Disclosure Number: IPCOM000102698D
Original Publication Date: 1990-Dec-01
Included in the Prior Art Database: 2005-Mar-17
Document File: 2 page(s) / 49K

Publishing Venue

IBM

Related People

Burns, NA: AUTHOR [+3]

Abstract

Disclosed is a method for providing SQL support to client applications that need to work in an interpretive environment or want to support an interface to the Structured Query Language (SQL) without requiring precompilation. This method allows client applications which would normally operate in a command level interface to utilize embedded SQL with an interface more consistent with the remainder of the application.

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

Generalized SQL Support for Client Applications

       Disclosed is a method for providing SQL support to client
applications that need to work in an interpretive environment or want
to support an interface to the Structured Query Language (SQL)
without requiring precompilation.  This method allows client
applications which would normally operate in a command level
interface to utilize embedded SQL with an interface more consistent
with the remainder of the application.

      If a database management system has a set of Interpreter
Services, such as SQLDBS and SQLEXEC available for the OS/2*
Procedures Language/2 by the OS/2 Database Manager, a routine can be
provided which will allow the client application to replace the
default variable handler routine used by Interpreter Services.  This
replacement routine must be functionally equivalent to the default
routine (RxVar) used by the Interpreter Services to manage data and
variables in the client application's variable pool.
      The basic component structure is shown in the figure.

      The ability to replace the variable handler routine provides a
client application with OS/2 Database Manager support and SQL
functionality with a minimum or effort.  The client application does
not even have to understand how SQL works, because all of the support
is handled by the Interpreter Services.  There are various potential
client applications other than OS/2 Procedures Language/2 that may be
able to take adv...