Browse Prior Art Database

SQL Calls From the Auditor

IP.com Disclosure Number: IPCOM000060215D
Original Publication Date: 1986-Mar-01
Included in the Prior Art Database: 2005-Mar-08
Document File: 1 page(s) / 12K

Publishing Venue

IBM

Related People

Bailey, CA: AUTHOR [+4]

Abstract

This article describes an interface between application generators and relational data bases. Information management system application development programs, such as IMSADF II, use an auditor routine to validate input data, perform application logic, and process application data. The auditor uses a symbol dictionary technique to decide which operations are to be performed on specified data. Fields in a user data base are always defined to the application development facility via an offline rules generator program, the purpose of which is to build "rules" which describe the data and transactions to be executed online. During conversational processing, these rules and fields are stored in a specified format in the area of random-access memory designated as the scratch pad area (SPA).

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 86% of the total text.

Page 1 of 1

SQL Calls From the Auditor

This article describes an interface between application generators and relational data bases. Information management system application development programs, such as IMSADF II, use an auditor routine to validate input data, perform application logic, and process application data. The auditor uses a symbol dictionary technique to decide which operations are to be performed on specified data. Fields in a user data base are always defined to the application development facility via an offline rules generator program, the purpose of which is to build "rules" which describe the data and transactions to be executed online. During conversational processing, these rules and fields are stored in a specified format in the area of random-access memory designated as the scratch pad area (SPA). In previous versions of IMSADF, only DL/I data bases could be accessed from ADF. Relational data bases, such as DB2, are needed for many applications. If the user needed to perform any application-unique processing upon data in a DB2 data base, ADF could not be used since there was no interface between the logic processing in the auditor and the DB2 data base, so data could not be retrieved or updated from the auditor. A new ADF auditor/DB2 data base interface was implemented by inventing a new auditor operation which causes a SQL call to be issued upon the user's request. The call may be a retrieval of data from a DB2 data base which is then stored in the SP...