Browse Prior Art Database

Check SQLWARN From the Auditor

IP.com Disclosure Number: IPCOM000060219D
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, C: AUTHOR [+3]

Abstract

This article describes a decision-making interface for application generators based upon success or failure of DB2 data base calls. 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 52% of the total text.

Page 1 of 1

Check SQLWARN From the Auditor

This article describes a decision-making interface for application generators based upon success or failure of DB2 data base calls. 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). The user may use the auditor to perform all application programming. IMSADF II provides a method of data retrieval or update for DB2 relational data bases by executing SQL calls against SQL data bases. The application program must be able to check the status of the last SQL call issued. Without this capability in the auditor, logic based upon the status of data base calls is impossible. A new set of auditor operations is available which allows access and testing of the SQLWARN passed from DB2 to the application program. Without this capability in the auditor, logic based upon the status of SQL data base calls is not possible. Unlike DL/I, DB2 re...