Using the advanced SELECT prototyping panels to build a SELECT statement

If you use advanced SELECT prototyping, you place the cursor on the part of the syntax you want and press Enter. To specify a value for a variable, you type the name in a panel. As you proceed to build the SELECT statement, FM/Db2 shows the partly-built statement within the panel you are viewing. You repeat this process until you have built the complete SELECT statement.