Extended Query Facility (EQF)

This section describes how to use the Extended Query Facility (EQF) to enhance your ability to perform queries.
This section describes how to use the Extended Query Facility (EQF) to enhance your ability to perform queries.
The process steps are provided to help you perform basic tasks associated with EQF:
  • Access EQF
  • Create and execute a selection query
  • Create and execute a data query
  • Execute an existing query
  • Edit a query
  • Delete a query
Selection and data queries are grouped under the category, extended queries. The type of query you enter depends on the product and function you are using:
  • Product functions or components that produce fixed format reports or selection lists let you enter selection queries. The selection queries are tied to a specific function in the product.
  • Functions or components that dynamically change the display or processing based on your select statement let you create data queries. For example, the data migration facility of 
     supports data queries.
Both types of queries are supported. For example, RC/Edit provides selection lists for selecting tables to edit. The RC/Edit Table Selection function supports the use of a selection query to control the tables that appear. Once a table is selected, you can control the actual data retrieved for edit with a data query.
The Extended Query Facility (EQF) lets you:
  • Extend an existing internal query to include additional WHERE and ORDER BY clauses. The queries you extend are internal queries used to produce reports or selection lists. EQF lets you control the rows selected, but not the content (columns).
    Use the SQL Selection component to extend existing internal queries. The queries produced are called Selection Queries because they control the selection of data, but not the actual data.
  • Enter a new query for retrieving data from a table. You control all aspects of the select statement including the actual data columns selected.
    Use the Data Query component to enter these kinds of queries. These queries are called Data Queries because they control the actual data retrieved.
  • Enter extended queries using a menu driven system. The queries can be saved for later execution and editing.
  • Request a list of available stored queries. You can then edit, execute, or delete a stored query by selecting it from the list.
  • Enter “place holders” for values in the WHERE clause when entering an extended query. When the query is executed, you are prompted for the unknown values. This facility lets you easily reuse the same query with different values for the WHERE clause.
  • Create default queries that automatically execute the next time a particular function or table is accessed.