Creating the table on VM and VSE

After you decide which function keys you want to customize, follow these steps to create a table that links your customized function key definitions with the appropriate panels:

1. Use an SQL CREATE TABLE statement similar to the one shown in Figure 149 to create the table. Substitute your own name for MY__PFKEYS. Substitute your own dbspace name for SPACE1.
   Figure 149. Creating a function key table on VM and VSE

   CREATE TABLE MY_PFKEYS
     (PANEL                CHAR(18)       NOT NULL,
      ENTRY__TYPE           CHAR(1)        NOT NULL,
      NUMBER               SMALLINT       NOT NULL,
      PF__SETTING           VARCHAR(254),
      REMARKS              VARCHAR(254))
      IN DBSPACE1

2. Add comments to the SYSTEM.SYSCATALOG table using an SQL statement similar to the following:

   COMMENT ON TABLE MY__PFKEYS IS 'PF KEYS RESERVED FOR FINANCIAL ANALYSTS'

   The phrase PF KEYS RESERVED FOR FINANCIAL ANALYSTS appears in the REMARKS column of the SYSTEM.SYSCATALOG table.
3. Create an index using an SQL statement similar to the following:

   CREATE UNIQUE INDEX MY__PFKEYSX
     ON MY__PFKEYS (PANEL, ENTRY__TYPE, NUMBER)

   Use the UNIQUE keyword to index the PANEL, ENTRY__TYPE, and NUMBER columns to ensure that no two rows of the table can be identical.

   If you choose not to use the UNIQUE keyword, QMF allows duplicate key definitions. QMF displays warning messages on the Home panel if it finds more than one key definition for the same key, and writes information about the warning messages to the user's trace data. Multiple key definitions for window panels cause no messages; QMF uses the last definition it finds.