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