21 Overview to Subfile Inquiry Programs

This chapter contains these topics:

You can create subfile inquiry programs that allow a user to process data and run programs using an inquiry screen that you create. A subfile inquiry screen presents a subfile with information, allowing a user to view several records at one time.

The use and values you enter to create a typical Interactive subfile inquiry program follow.

21.1 Program Type Description

Use the Program Type Description to create an interactive subfile program that is for inquiry purposes only. This program type processes a single master file by key. You do not use Lockout Action Codes fields. Create a display file prior to generating this program type.

21.2 Display File Definition

The Display File Definition program type validates and changes, where necessary, the data a user enters (scrubs) the key fields in the control format of the display file prior to processing the master file. You denote the key fields by enter K in the Edited Field in the Field Definition screen of Screen Design Aid (SDA). If you are using the Data Base Field Selection feature in SDA, the system updates the key fields.

You do not need to define the Action Code, it is an optional field. Define a default cursor location if there is no action code.

21.3 CL Program Definition

Using the CL Program Definition, you can copy and revise the J98MODEL1 model CL Program and create a CL program for use with program type A0010. You can also use the Quick Start CL Generator to create your CL programs.

21.4 File Specifications

The File Specifications program type requires that you define a single master file and a display file. The master file contains a value of M or 1 in the Input column. The display file begins with V and the selection columns are blank. You can add files to retrieve descriptions, if necessary.

21.5 Detailed Programming Facility

The Detailed Programming Facility allows you to use a key list for record retrieval from the master file. If you are not using the complete key list, update the Key Sequence field on the Detailed Programming Facility to include only those data items which are necessary. This key list should match your key field definition from the control format of the display file.

21.6 Special Considerations

Add special logic if you want to process the master file by using the key as a restrictive key. The default logic performs a SETLL, which positions the records from the file by using the key and then reading without a key until the subfile loads.

21.7 Quick Start Generation

You can generate this program type using Quick Start.