Purpose
If a query in DQL Mode contains one or more WHEN/DO statements, you can issue this command during online output display to show only the results of WHEN/DO statements.
When to Use It
Use this command during online DQL Mode report display.
Syntax
|
Enter |
With |
When You Want to: |
|---|---|---|
|
WHEN-ONLY |
No operand |
See only the results of a DQL Mode WHEN/DO query statement. |
Example
=> WHEN-ONLY 01/19/2010 DATAQUERY SAMPLE PAGE 1 11:10:12 DETAIL DEPT NAME SALARY COMM WAGES ------ -------------------- ------------- ------------- ------------- 00015 ROTHMAN 1,152.00 16,502.83 17,654.83 HANES 22,659.80 .00 22,659.80 TOTAL DEPT 00015 * 23,811.80 * 16,502.83 SUM WAGES 40,314.63 00020 WILSON 16,111.00 219.00 16,330.00 PERNAL 1,234.56 612.45 1,847.01 SEPULVEDA 29,100.00 - - SANDERS 18,357.50 .00 18,357.50 GRAY 18,199.00 750.00 18,949.00 -------------------------------- 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
Result
=> 01/19/2010 DATAQUERY SAMPLE PAGE 1 11:10:12 WHENS-ONLY SUM WAGES 40,314.63 SUM WAGES 55,483.51 SUM WAGES 95,362.30 SUM WAGES 99,748.96 SUM WAGES - -------------------------------- 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
|
Copyright © 2014 CA.
All rights reserved.
|
|