i have a MATCH Problem. I want to match two files (AFTER MATCH HOLD OLD). The first has 106 rows and the other 560 rows. The by fields i use for the match have the same name and datatype. After the match i receive a table with 113 rows. 7 rows more than i expected. The first columns with the by fields are filled and the other are empty, until the print part begins from the second table. Strange behavior!!!!
Regards
ChristianThis message has been edited. Last edited by: Kerry,
WF Production Version: 7.7.02M WF Test Version: 7.7.02M Developer Studio: 7.7.02 HTML, EXL2K, FLEX, PDF,PPT
August 01, 2011, 10:31 AM
GamP
You must be using print iso sum, otherwise this would not happen. Read up on the MATCH behavior inthe manual.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
August 01, 2011, 01:09 PM
ChristianP
Hi GamP,
i use PRINT!!
Regards Christian
WF Production Version: 7.7.02M WF Test Version: 7.7.02M Developer Studio: 7.7.02 HTML, EXL2K, FLEX, PDF,PPT
August 01, 2011, 06:06 PM
Waz
The key to understaning MATCH is the verbs and sort fields on each table in the match.
Definitely check out the manual.
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!
August 02, 2011, 03:27 AM
Amar
Hi Christian,
It returned 113 rows because of the duplicate entries in either of the tables. So try using SUM instead of PRINT in either MATCH or RUN statements.
Hope it solves your problem.
WebFOCUS 7.6.4, Mainframe Focus Mainframe / Z/OS,MVS Managed Reporting / Windows All formats