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

Publishing Venue

IBM

Related People

Authors:
Bailey, CA Dodge, G Filip, J Weber, O [+details]

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).