And the join is: JOIN TESTHF2.TESTHF2.DISCHGDATE IN TESTHF2 TO MULTIPLE CALENDAR.CALENDAR.KEYDATE IN CALENDAR AS J3 END
I've tried a focus hold file with index as in: ON TABLE HOLD AS DDAD FORMAT FOCUS INDEX 'DISCHGDATE' then I get 'description cannot be found for file DDAD
If I dont use a hold file, I get (FOC1101) THIS INTERFACE DOES NOT SUPPORT THE GLOBAL JOIN
See code: TABLE FILE TESTHF2 PRINT DISCHGDATE MEDREC ADMDATE FNAME LNAME FIELD_6 HF1 DSINSTADMD DSINSTADAC DSINSTADDI DSINSTADFU DSINSTADSW DSINSTADWT UNIT HF1_FORM ON TABLE HOLD END JOIN DISCHGDATE IN TESTHF2 TO UNIQUE CALENDAR.CALENDAR.KEYDATE IN CALENDAR AS J3 END TABLE FILE TESTHF2 PRINT YEAR WEEKOF HEADING "" FOOTING "" [end]
Thank you GmThis message has been edited. Last edited by: Kerry,
WebFocus 762,7611, 7.7.02 XP for Dev/test; Linux Prod 7.6.2; MRE
October 14, 2009, 05:17 PM
Waz
I would suggest TABLEing each COM file and HOLDing, as different names, then joining them.
Your code above HOLDs the TESTHF2, but your join does not use it.
TABLE FILE CALENDAR
PRINT ...
ON TABLE HOLD AS HLD_CALN
END
JOIN
DISCHGDATE IN TESTHF2 TO UNIQUE KEYDATE
IN HLD_CA AS J3
END
TABLE FILE TESTHF2
PRINT
YEAR
WEEKOF
HEADING
""
FOOTING
""
[end]
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 14, 2009, 05:22 PM
gmal
Yes, you are correct. HOLDing both as Format FOCUS with index, allowed the join to work. thank you
WebFocus 762,7611, 7.7.02 XP for Dev/test; Linux Prod 7.6.2; MRE
October 14, 2009, 05:59 PM
Waz
Both don't need to be FOCUS, only the join to file, making sure that the field you are joining to is indexed.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 15, 2009, 08:27 AM
GamP
You could also try to use the MATCH FILE command. No need for joins. No need for converting to focus format. The result of the MATCH FILE is a hold file that has all data in it. Sometimes I find this easier to use than JOIN.