The following example shows how output from the sample query looks on the terminal screen when execution is complete. No format definition has been done.
Query Output Panel
07/20/00 PAGE 1 18:23:59 DETAIL ITEM QUANTITY UNIT ID SHIPPED PRICE EXPRESSION 01 ---------- ---------- ---------- ------------------- A10002 4 19.99 0000000079.96000 A20000 1 149.99 0000000149.99000 A30000 2 39.99 0000000079.98000 A40000 5 5.99 0000000029.95000 A60000 4 49.99 0000000199.96000 H10003 100 12.99 0000001299.00000 H20005 200 17.99 0000003598.00000 H30001 102 14.99 0000001528.98000 H40000 900 15.99 0000014391.00000 -------------------------------- 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
Facts
The following tells you the facts you need to understand the output of the sample query.
Since no report format was defined, CA Dataquery's first choice for column headings of database columns is always the CA Datacom Datadictionary alternate heading. Also, CA Dataquery uses the automatically assigned Expression 01 for the result column heading. All of these headings can be overridden in the report format definition.
Since leading zeros appear in the numeric columns in the database, they also appear here. They can be eliminated by selecting a different edit pattern on a panel in the report format definition.
Options
Display the execution panel and make entries on the report format definition panels that you can access.
Press <PF6> STATS to see a display of execution statistics for this query. See Viewing Query Statistics for information.
Additional Information
The following provides additional information you might want to know about the output display of the sample query.
Since no report definition was defined, totals are not available for these columns.
|
Copyright © 2014 CA.
All rights reserved.
|
|