No-optional access to secondary file (Quick)

[Regan, John]

have you tried the "Select if not record <filename> exists" option
or if record exists option? of the select statements.

-----Original Message-----
From: Markus Grossrieder [mailto:markus.grossrieder@alba-systems.com]
Sent: Wednesday, March 22, 2000 8:41 AM
To: powerh-l@lists.swau.edu
Subject: No-optional access to secondary file (Quick)


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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.