DEFINE FILE CAR
profit/D12.2=CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST;
END
JOIN
FILE CAR AT CAR.ORIGIN.COUNTRY 
TO MULTIPLE 
FILE CAR AT CAR.ORIGIN.COUNTRY TAG J0 AS J0
-*
WHERE J0.ORIGIN.COUNTRY EQ J0.ORIGIN.COUNTRY;
WHERE J0.BODY.profit GT 5000;
END

1.	WHERE's
2.	DEFINE's
3.	WHERE on DEFINE's
4.	SORT
5.	VERB (=PRINT or SUM)
6.	PREFIX OPERATORS (FST. LST. MAX. etc)
  	… internal matrix is ready at this point …
7.	COMPUTES
8.	WHERE TOTAL
9.	BY TOTAL
10.	GENERATE TOTALS / SUBTOTALS etc.
11.	RECAP's (based on subtotals)
12.	STYLING + OUTPUT

In general:
	WebFOCUS will offload as much as possible to the RDBMS
	If 1 step cannot be offloaded to the RDBMS
		that step will be solved by WebFOCUS
		all following steps from that point will be solved by WebFOCUS
	All steps after generating the Internal Matrix are always solved by WebFOCUS

quote:

The-12-Steps-Of-Table

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!

quote:

KEEPDEFINES = ON
DEFINE FILE CAR
profit/D12.2=CAR.BODY.RETAIL_COST - CAR.BODY.DEALER_COST;
END
JOIN
FILE CAR AT CAR.ORIGIN.COUNTRY
TO MULTIPLE
FILE CAR AT CAR.ORIGIN.COUNTRY TAG J0 AS J0
-*
WHERE J0.ORIGIN.COUNTRY EQ J0.ORIGIN.COUNTRY;
WHERE J0.BODY.profit GT 5000;
END

quote:

Originally posted by Waz:

quote:

The-12-Steps-Of-Table

Isn't this part of the training ?