FIND procedure

Executes a FIND procedure stored in the current Proc-file.

Syntax

   F[IND] procedure name [,character]

For example:

   >FIND ACCTS

Where procedure name = ACCTS

   >F USERS,X

Where procedure name = USERS, and character = X

Parameters

procedure name: is the name of a FIND command previously stored as a procedure using the CREATE command. The procedure must exist in the current Proc-file specified with the PROC-FILE = command, or in response to the PROC-FILE prompt of the DEFINE or MULTIDB command.
character: is any printable ASCII character. If character is included in the command, the FIND procedure is listed.

Discussion

QUERY searches the current Proc-file and executes the procedure named in the command. If the Proc-file has not been declared, or the procedure does not exist in the Proc-file, or the procedure is incorrect in some way, you are informed by an error message. If character is included in the command, QUERY prints the procedure on the standard list device before executing it.

If null data values appear in the procedure, QUERY prompts you for the necessary values. If the retrieval requires a serial search of a data set, the following message is returned:

   USING SERIAL READ

For more information about storing and using FIND procedures, refer to the CREATE command.

Example

      >FIND FINDACCT

      WHAT IS THE VALUE OF - ACCOUNT

      >>54283545

      2 ENTRIES QUALIFIED

      >R ALL,Z





      54283545

      MAYFIELD

      WILLIAM



      37 41ST AVE.

      PETALUMA

      CA

      10101

       8.50000





      54283545

      4397D13P

      1

      4590

      276

      0

      121585

      122085

The FINDACCT procedure contains:

      FIND CHAIN

      CUSTOMER.ACCOUNT,SALES

      ACCOUNT

      IS "" END

In this example, QUERY prompts for the value of ACCOUNT. The REPORT ALL command prints the entry data. The first entry is from the CUSTOMER master data set. The second entry is from the SALES detail data set.

FIND procedure

Technical documentation

» Table of Contents

Syntax

Parameters

Discussion

Example