Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Difference between PRINT AND SUM
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Difference between PRINT AND SUM
 Login/Join
 
Silver Member
posted
Hello, What is the exact difference between SUM and PRINT in a MATCH statement?

For example:
  
MATCH FILE FILE1                                                             
SUM FIELD_1                                                          
BY CODE AS KEY                                           
RUN                                                                             
FILE FILE2                                                             
SUM FIELD_2                                                            
BY CODE AS KEY
AFTER MATCH HOLD AS HOLDF OLD-OR-NEW    


Assumming the data contained in the two files is:

FILE_1 FILE_2
------------ ------------
code field_1 code field_2
1 10 1 50
2 20 2 30
4 30 3 40

What would my final result be? What would be the difference if I put PRINT instead of SUM?

Thank you

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


WebFOCUS 7.1.4
Windows, All Outputs
 
Posts: 35 | Registered: December 21, 2011Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I would suggest you read the section "Fine-Tuning MATCH Processing" in chapter 16 of the Creating Reports with WebFOCUS Language book.

Copy & pasting of about 4 pages iof information is frowned upon by our illustrious admin :-)


Robert F. Bowley Jr.
Owner
TaRa Solutions, LLC

In WebFOCUS since 2001
 
Posts: 132 | Location: Gadsden, Al | Registered: July 22, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
When you write SUM at the 'NEW' level, Match is informed that there will be, at most, One Record for a given KEY Value.
So OLD is O,1 for a KEY Value
And Same is NEW
You Use OLD-OR_NEW, so if any KEY value being in the OLD And / Or in the New will give birth
to One single Record in HOLDF File

When You Use PRINT instead of SUM at the New Level, Match Knows that he doesn't know ( and he won't check for each KEY value at the New Level)
What he knows is that (0,n) is the cardinality of New for any Code Value.

When the cardinality is 0,1 (SUM) Match won't hesitate to replicate the values found on the OLD level onto All the instances Brought on the NEW level
Other he won't do that
In the old Days he Wrote Max (Nb Old, Nb New) records. The ith record contained the ith instance Old Level juxtaposed to the ith instance New Level
Now, When You Set CARTESIAN = ON you get closer of SQL Inner Join : Nb Old * Nb New instances out. Each Old Instance being being juxtaposed by All New instances.

Match, often, surprises IT guys.
But it does exactly what the Focus Bible says it does ( and not one fancy it does )

Now I bet for :
Code Field1 Field2
1 10 50
2 20 30
3 40
4 30

I Guess that, with a Sum there won't be Missing Values, like a SegType = DKU son

And with a Print
Code Field1 Field2
4 30 .
Field2 Would be a Missing Value like a SegType = DKM Value

I know that I Know nothing, but that I know.
Focus is real great when he handles cardinality. But for me, it's not a subject for writing on a corner of a table. You've got to have your brains rather intensely concentrated .

Just wait for Tony A and/or Waz to fix your question in two brilliant and funny lines ...
Cordially and Focusely


Focus Mainframe 7.6.11
Dev Studio 7.6.11 and !!!
PC Focus, Focus for OS/2, FFW Six, MSO
 
Posts: 134 | Registered: November 06, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Should know that Spaces are brought to one by HTML. I bet For :
  
Code Field1 Field2
1 10 50
2 20 30
3    40
4 30 


Focus Mainframe 7.6.11
Dev Studio 7.6.11 and !!!
PC Focus, Focus for OS/2, FFW Six, MSO
 
Posts: 134 | Registered: November 06, 2007Reply With QuoteReport This Post
Silver Member
posted Hide Post
quote:

You've got to have your brains rather intensely concentrated .

Nothing but the truth

Thank you so much for your help and your time.


WebFOCUS 7.1.4
Windows, All Outputs
 
Posts: 35 | Registered: December 21, 2011Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Difference between PRINT AND SUM

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.