HP 3000 Manuals HP 3000 Manuals
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.