Executing a SELECT statement after you have built it using prototyping

When you have completed building an SQL SELECT statement, using either basic SELECT prototyping or advanced SELECT prototyping, you can run it by:
  • Entering the EXECUTE primary command, or
  • Pressing the Execute function key (F6)

FM/Db2 displays the results according to the Use edit (instead of browse) to display results option. If this option is selected, FM/Db2 displays the results using FM/Db2 Edit; otherwise, FM/Db2 displays the results using FM/Db2 Browse.

Sample results table displayed using Browse shows a results table using FM/Db2 Browse.
Figure 1. Sample results table displayed using Browse
  Process   Options   Utilities   Help
────────────────────────────────────────────────────────────────────────────────
FM/Db2 (DFG2)               Select Statement Browse
RESULTS FOR SELECT #1.FIRSTNME, #1.LASTNAME, #1.JOB FROM D...      Format TABL
FIRSTNME     LASTNAME        JOB
#2           #4              #8
VARCHAR(12)  VARCHAR(15)     CH(8)
<---+----1-> <---+----1----> <---+-->
****  Top of data  ****
MICHAEL<     THOMPSON<       MANAGER
IRVING<      STERN<          MANAGER
EVA<         PULASKI<        MANAGER
THEODORE<    SPENSER<        MANAGER
VINCENZO<    LUCCHESI<       SALESREP
SEAN<        O'CONNELL<      CLERK
DOLORES<     QUINTANA<       ANALYST
HEATHER<     NICHOLLS<       ANALYST
ELIZABETH<   PIANKA<         DESIGNER
MASATOSHI<   YOSHIMURA<      DESIGNER
MARILYN<     SCOUTTEN<       DESIGNER
JAMES<       WALKER<         DESIGNER
Command ===> _____________________________________________________ Scroll PAGE
 F1=Help      F2=Zoom      F3=Exit      F4=CRetriev  F5=RFind     F6=RChange
 F7=Up        F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel

If there is insufficient space on the panel to show all of the columns, use the LEFT primary command to scroll left, or the RIGHT primary commands to scroll right, to view the additional columns.

Related tasks

Related references