Browse Prior Art Database

Determination of Db2/Sql Null Fields Disclosure Number: IPCOM000060896D
Original Publication Date: 1986-May-01
Included in the Prior Art Database: 2005-Mar-09

Publishing Venue


Related People

Weber, O [+details]


IMSADF II (Information Management System Application Development Facility Version 2) uses an auditor 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. There exists a user requirement for the application program to be able to check fields to see whether they are null. These fields are stored in a DB2 user data base, and are always defined to IMSADF II 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 IMS Scratch Pad Area (SPA).