Using Parameter Hints for visual queries

If you are using QMF for Workstation, Parameter Hints provide a summary of a function's parameters as it is being typed in SQL statements.

About this task

To use Parameter Hints while typing parameterized functions into SQL text:

Procedure

  1. Select File > New > Other and expand the QMF Objects folder. Select Visual Query from the list of QMF Objects.
  2. Specify the name of the query in the Name field and where the query will be saved in the Data Source field. Click Finish.
  3. Click the SQL tab.
  4. Type the first part of a parameterized function, which includes the name of the function and the left parenthesis.
    For example, SUM(.
  5. Press Ctrl+Shift+Spacebar. A ToolTip opens that displays an example of how to complete the function.
    For example, if SUM( is displayed, the ToolTip will display SUM(<numeric-expression>).
  6. Use the displayed hint as a reference when completing the parameterized function.