Hi,

I have come across a report written some years ago, that has a match done in a strange way. I've never seen it done this way and am unsure if it is correct or not, as I have to rewrite it using DB2 SQL. Normally, when I write a match, and from what I see in my wfs book one should have a statement like the following at the end:

AFTER MATCH HOLD OLD-OR-NEW (depending on that you want)  

Could someone possibly tell me why a match would be done like this:

 
MATCH FILE TABLE1
PRINT DATE
      AMOUNT
   BY NUMBER
RUN
FILE TABLE1
SUM AMOUNT2
   BY NUMBER
RUN
FILE TABLE1
SUM CODE
   BY PINNUMB
   ON TABLE HOLD AS HOLD1 MISSING OFF
END
-RUN 

I'm baffled!

Thanks,

Jinx.

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

Well, there are actually two things wrong here.
The last BY is on a completely different field which will defenitely produce undesired results (if not an error message nowadays).
The AFTER MATCH is also not present, as you noticed. But that is not too bad, it will revert to the default which is OLD-OR-NEW.

Oh, thanks for that. I didn't know it defaults to OLD-OR-NEW.
As for the by mistake - that's my bad, I simplified the code and forgot to change that one field when adding my post ^^.

Thanks again.