Operation Commands › FORMAT - Change SQL Format

FORMAT - Change SQL Format

Purpose

The FORMAT command, issued in SQL Mode, displays the first of a series of panels for viewing or defining a report definition for the output of a specific SQL query.

When to Use It

When you want to see the specifications for an SQL query report or when you want to change the specifications for the current execution.

Syntax

Example

 => FORMAT
 DQ471I - ROWS FOUND: 000034
01/15/2010       DATAQUERY SAMPLE             PAGE 1
15:01:06                    TO PRODUCE REPORT AAA                    DETAIL
 
 
      ID  EMP_NAME                DEPT  JOB    NUMYEARS     SALARY       COMM
  ------  --------------------  ------  -----  --------  ---------  ---------
  00010   SANDERS               00020   MGR      00009   17530.00          -
  00020   PERNAL                00020   SALES    00008   18171.25   00612.45
  00030   MARENGHI              00038   MGR      00005   17506.75          -
  00040   O'BRIEN               00038   SALES    00006   18006.00   00846.55
  00050   HANES                 00015   MGR      00010   20659.80          -
  00060   QUIGLEY               00038   SALES        -   16808.30   00650.25
  00070   ROTHMAN               00015   SALES    00007   16502.83   01152.00
  00080   JAMES                 00020   CLERK        -   13504.60   00128.20
  00090   KOONITZ               00042   SALES    00006   18001.75   01386.70
  00100   PLOTZ                 00042   MGR      00007   18352.80          -
  00110   NGAN                  00015   CLERK    00005   12508.20   00206.60
  00120   NAUGHTON              00038   CLERK        -   12954.75   00180.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

Output

 =>
 
 ------------------------------------------------------------------------DQF30
 DATAQUERY:  REPORT FORMAT - REPORT TITLE      QUERY NAME:    SQLREP1
 -----------------------------------------------------------------------------
 
 ENTER UP TO TWO LINES FOR A
 REPORT TITLE:      => TO PRODUCE REPORT AAA
                    =>
 
 SELECT THE DESIRED REPORT FORMAT:    X  COLUMNAR FORMAT: ONE ROW PER LINE.
                                      _  LIST FORMAT: ONE ROW PER PAGE.
 
 
 
 
 
 
 
 
 -----------------------------------------------------------------------------
 <PF1> HELP       <PF2> RETURN       <PF3> DELETE FORMAT      <PF4> CONTINUE