Using Assist

For example, if you select a Db2 table name, Assist displays the columns belonging to that table. If you select a QMF keyword, Assist displays the QMF help data for that keyword.

If you position the cursor on the character immediately ahead of the target word and invoke Assist, a list of alternatives to the target word are displayed. For example, if you select a table name, Assist displays other tables belonging to that owner. If you select a QMF or SQL keyword, Assist displays other keywords of a similar type.

Assist will display data on a table or browse panel depending on the data type.The target word you select is always shown in context at the top of the Assist panel. The edit data from the edit line that contains the target word is shown along with the preceding and following edit lines. The target word is shown in reverse green unless you have selected ahead of the word (in which case, the target word is shown in reverse red to indicate that the word can be replaced by any of the items from the first column in the list by using the R replace line command.

To setup the method by which you invoke Assist, enter the EESET command or select the Enhanced Editor settings option from the Settings menu. Assist is invoked by positioning the cursor on or just ahead of a target word in the edit data and pressing the key you have indicated in the Settings dialog. Available options are:

• The Enter key (alternatively, you can click the target word)
• The Help function key (alternatively, you can enter the HELP command)
• Inhibit (turns the Assist feature off)

In a query, the target word can be an SQL identifier such as a Db2 table owner, table name, column name, column value or an SQL keyword or function. In a procedure it can only be a QMF command.