No-optional access to secondary file (Quick)

Markus Grossrieder markus.grossrieder@alba-systems.com
Wed, 22 Mar 2000 14:41:17 +0100


Hi all,

I want to select a primary file, depending if a secondary file exist (with a
given selection criteria).
The only way to do this I found: cut the OPTIONAL option in the FIND
procedure.
Is therer an option/technique in the FILE statement which do this, without
the need to have the explicit PATH/FIND procedures in my source ? (I'm using
PH 7.10G3 on OpenVMS)

tia, Markus

(Example:)
FILE A PRIM OCCURS 15

FILE B SECOND OCCURS WITH A
ACCESS VIA KEY1 USING KEY1 OF A
SELECT IF ITEMX = "X"

PROCEDURE PATH
  ...

PROCEDURE FIND
  BEGIN
    FOR MISSING A
      BEGIN
       ...
      ;GET B OPTIONAL
      GET B                ;<- removed OPTIONAL for selection of A
      END
  END



= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.