3-09:Query Process Rules Option

Chapter 3-9: Query Processes

Query Process Rules Option

Selecting the rules option accesses the query process frame Event Points For Rules overlay which allows you to select from a variety of options that access the ILF Editor for APPX event points. If statements were defined in the event point, the text on the overlay is highlighted. Upon completion, you are returned to the query Event Points For Rules overlay. The query Event Points overlay contains the following options:

Start of Process (Query Setup)

start of process (query setup) accesses the ILF editor for the Start of Process event point. Statements in this event point execute during query setup. Upon completion, you are returned to the query Event Points overlay.

End of Process (Query Setup)

end of process (query setup) accesses the ILF editor for the End of Process event point. Statements in this event point execute during query setup. Upon completion, you are returned to the process Event Points overlay.

Start of Query Execution

start of query execution accesses the ILF editor for the Start of Query Execution event point. Statements in this event point execute just before the query starts. Upon completion, you are returned to the query Event Points overlay.

Establish PCF Range

This event point provides explicit control for the designer to establish the range (or ranges) of records from the PCF file which are read by the query. This can significantly increase query performance by utilizing available key fields.

establish pcf range can be coded by the designer. Otherwise, it will be generated at runtime based on any Record Selection Beg At and End At questions. To explicitly limit customer records to those for a given state, code in the Establish PCF Range event point would consist of a simple BEG AT/END AT loop. These loops can be repeated multiple times to establish multiple ranges for the query to process.

Pre-User Selection

pre-user selection accesses the ILF editor for the Pre- User Selection event point. Upon completion, you are returned to the query Event Points overlay.

Post User Selection

post user selection accesses the ILF editor for the Post User Selection event point. Upon completion, you are returned to the query Event Points overlay.

End of Query Execution

end of query execution accesses the ILF editor for the End of Query Execution event point. Statements in this event point execute when the query is finished. Upon completion, you are returned to the query Event Points overlay.

PCF Level EPs

pcf level eps provides access to the File Level Event Points for the PCF file. This overlay is shown in Figure 3-9-3. These Event Points are not directly associated with the process but with the PCF file. See the Rules Option section of Chapter 2-4, Files and Fields for more information on using PCF Level Event Points.

Figure 3-9-3. Event Points For Rules Overlay

APPX Application Design Manual (01/13/03)