We are upgrading from WF7.1.6 to WF7.7 and so have several years worth of enhancements to absorb.

I've noticed that TABLE requests that would have given me a (FOC030) ALL VERB OBJECTS MUST BE IN THE SAME PATH AS THEIR SORT FIELDS error are now deftly handled by means of a MATCH that is done internally. Unfortunately the MATCH can take considerable time, and a hold file is left lying around. Is this behaviour controllable by means of a switch?

Here's a code example using the CAR file:

-* Setup "DEMO" file for JOINing.
TABLE FILE CAR
SUM
 SALES
BY COUNTRY

SUM
 WEIGHT
BY COUNTRY
BY CAR
ON TABLE HOLD AS DEMO FORMAT FOCUS INDEX CAR
END
-RUN

-* Join to DEMO. Sort verb objects not all on same path.
-* WF7.1.6 gives FOC030. WF7.7 automatically does MATCH.
JOIN CLEAR
JOIN CAR IN CAR TO ALL CAR IN DEMO TAG A AS A
TABLE FILE CAR
SUM
 SALES
BY CAR
BY A.COUNTRY
BY A.WEIGHT

ON TABLE HOLD AS HOLD01 FORMAT ALPHA
END
-RUN

-UNIX ls -lF hold*

WF7.1.6 gives:

0 ERROR AT OR NEAR LINE     31  IN PROCEDURE match   FOCEXEC *
 (FOC030) ALL VERB OBJECTS MUST BE IN THE SAME PATH AS THEIR SORT FIELDS
 hold*: No such file or directory

WF7.7 gives:

0 NUMBER OF RECORDS IN TABLE=       18  LINES=     10

0 NUMBER OF RECORDS SELECTED=       18  LINES=     10
0 NUMBER OF RECORDS SELECTED=       10  LINES=     10
0 LINES OF MATCH OUTPUT     =       10
0 NUMBER OF RECORDS IN TABLE=       10  LINES=     10


 -rw-r--r--   1 muirj    hdrstaff     480 Aug 23 13:34 hold.ftm
 -rw-r--r--   1 muirj    hdrstaff     788 Aug 23 13:34 hold.mas
 -rw-r--r--   1 muirj    hdrstaff     390 Aug 23 13:34 hold01.ftm
 -rw-r--r--   1 muirj    hdrstaff     729 Aug 23 13:34 hold01.mas

This message has been edited. Last edited by: Kerry,

Are you using APP HOLD apppath?

quote:

... a hold file is left lying around ...

You may want to NOT do that anymore.

What is is that you are attempting to do? What is you desireed end-result?