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)
ZDT/Db2 displays the results according to the Use edit (instead of browse) to display results option. If this option is selected, ZDT/Db2 displays the results using ZDT/Db2 Edit; otherwise, ZDT/Db2 displays the results using ZDT/Db2 Browse.
Sample results
table displayed using Browse shows a results table using
ZDT/Db2 Browse.
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