Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Dynamic DB2 Secondary Key Selection

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

Publishing Venue

IBM

Related People

Bailey, C: 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 (RAM) designated as the scratch pad area (SPA).

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

Page 1 of 2

Dynamic DB2 Secondary Key Selection

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 (RAM) designated as the scratch pad area (SPA). The user may use the auditor to perform all application programming. IMSADF II provides a process called Secondary Key Selection which aids the user in determining which row of a table is desired for processing. This process includes displaying certain data from rows within tables in the data base. The particular rows displayed are primarily user- controlled through key selection. For the DB2 user, the user-control of secondary key selection can be greatly expanded because of the capabilities given the user through SQL calls and their various options. With the DB2 support of IMSADF II Version 2, the rules for guiding the DB2 transaction are created offline by the Rule Generator, similar to the method used for DL/I transactions in previous versions of IMSADF II. Once the appropriate rules have been created, the user may key a '>' or '<' in a KEY=YES column for a DBPATH table in order to automatically execute the predefined KSELECT1 SQL function which will perform a SQL retrieve using the '>' or '<' relation operators as appropriate. Alternatively, the user may enter '%string%' or '__string' in order to automatically execute the predefined KSELECT2 SQL function which will perform a SQL retr...