SQL Prototyping, Execution and Analysis panel

You use the SQL Prototyping, Execution and Analysis panel to select the FM/Db2 SQL function you want to use.

Panel and field definitions

  Process   Options   Utilities   Help
 ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)      SQL Prototyping, Execution and Analysis

 1  Basic         Prototype SELECT statements (basic)
 2  Advanced      Prototype SELECT statements (advanced)
 3  Enter         Enter, execute and explain SQL statements
 4  Edit          Edit and execute SQL statements from a data set
 5  Utility       Manage tables used by SQL explain










 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F12=Cancel
1 (Basic)
Use this option to build and execute a basic SELECT statement.
2 (Advanced)
Use this option to build and execute a complex SELECT statement.
3 (Enter)
Use this option to enter, execute, and explain SQL statements.
4 (Edit)
Use this option to edit and execute SQL statements from a data set.
5 (Utility)
Use this option to select utilities to support the use of the Db2® EXPLAIN statement.

Parent panels

Child panels

To display this panel… Use/do this
Basic SELECT Prototyping panel Option 1
Advanced SELECT Prototyping panel Option 2
Enter, Execute and Explain SQL Statements panel Option 3
Edit/Execute SQL (Data Set) panel Option 4
Explain Utilities panel Option 5

Related tasks