The following query illustrates multiple DO statements for a single WHEN statement. The multiple DO statements perform mathematical functions and a page break when a control break is encountered during execution.
Sample
FIND 10 CAI-SLSHST-REC ROWS
WITH SHIP-QTY > 0
RELATED BY SLMN-ID TO CAI-ORDERS-REC
SET NET-COST (8.2) = CAI-SLSHST-REC SHIP-QTY * UNIT-PRICE
SET DISCOUNT (5.2) = NET-COST * DISC-PCT
SORT CAI-SLSHST-REC BY (ORD-ID) AND CAI-ORDERS-REC SHIP-ID
PRINT FROM CAI-ORDERS-REC ORD-ID
SHIP-ID
FROM CAI-SLSHST-REC ITM-ID
SHIP-QTY
UNIT-PRICE
(NET-COST)
DISCOUNT
WHEN CAI-SLSHST-REC ORD-ID BREAKS
DO MAX UNIT-PRICE
DO SUM CAI-SLSHST-REC SHIP-QTY
DO PAGE-BREAK
Output
This screen is the first page of sample output generated from executing this query.
Sample (Continued)
=> 01/02/2010 CA Dataquery PAGE 1 18:21:32 DETAIL ORD-ID SHIP-ID ITM-ID SHIP-QTY UNIT-PRICE NET-COST DISCOUNT ------ ------- ---------- -------- ---------- ------------- --------- 07333 00001 O10001 0000006 00998.50 00005991.00 00010.00 00002 O30012 0000001 01000.00 00001000.00 00003.00 TOTAL ORD-ID 07333 * 00006991.00 MAXIMUM UNIT-PRICE 01000.00 SUM SHIP-QTY 0000007 -------------------------------- MORE .... --------------------------------- <PF1> HELP <PF2> RETURN <PF3> TOTALS ONLY <PF4> DETAIL <PF5> NO TOTALS <PF6> STATS <PF7> BACKWARD <PF8> FORWARD <PF9> NOT USED <PF10> NOT USED <PF11> LEFT <PF12> RIGHT
Sample (Continued)
This screen is a later page of sample output for the preceding example.
=> 01/02/2010 CA Dataquery PAGE 3A 18:21:32 DETAIL ORD-ID SHIP-ID ITM-ID SHIP-QTY UNIT-PRICE NET-COST DISCOUNT ------ ------- ---------- -------- ---------- ------------- --------- 09311 00001 C10001 0000023 00021.00 00000483.00 00032.00 TOTAL ORD-ID 09311 * 00000483.00 MAXIMUM UNIT-PRICE 00021.00 SUM SHIP-QTY 0000023 -------------------------------- MORE .... --------------------------------- <PF1> HELP <PF2> RETURN <PF3> TOTALS ONLY <PF4> DETAIL <PF5> NO TOTALS <PF6> STATS <PF7> BACKWARD <PF8> FORWARD <PF9> NOT USED <PF10> NOT USED <PF11> LEFT <PF12> RIGHT
Sample (Continued)
This screen is the last page of output for the preceding example.
=> 01/02/2010 CA Dataquery PAGE 5A 18:21:32 DETAIL ORD-ID SHIP-ID ITM-ID SHIP-QTY UNIT-PRICE NET-COST DISCOUNT ------ ------- ---------- -------- ---------- ------------- -------- * GRAND TOTAL * 00056053.40 -------------------------------- LAST PAGE --------------------------------- <PF1> HELP <PF2> RETURN <PF3> TOTALS ONLY <PF4> DETAIL <PF5> NO TOTALS <PF6> STATS <PF7> BACKWARD <PF8> FORWARD <PF9> NOT USED <PF10> NOT USED <PF11> LEFT <PF12> RIGHT
|
Copyright © 2014 CA.
All rights reserved.
|
|