Editing the template

If you selected the Edit template option on the Create panel, FM/Db2 displays the Column Selection/Edit panel when you press Enter.

To populate the columns for the Db2® table you have specified by editing the template:

  1. Enter E against the first column in the Column Selection/Edit panel. FM/Db2 displays one of five Column Attributes panels depending on the data type of the column:
    • Alphanumeric (for CHAR, VARCHAR, GRAPHIC, and VARGRAPHIC data types)
    • Numeric (for DECIMAL or NUMERIC, SMALLINT, INTEGER, REAL, and DOUBLE data types)
    • DATE
    • TIME
    • TIMESTAMP
  2. Use the Column Attributes panel to specify the create attributes for the column. The create attributes determine the value that FM/Db2 puts in the column when it creates data.

    For details about how to enter the create attributes, refer to the description for the relevant Column Attributes panel.

  3. Press the Exit function key (F3) to return to the Column Selection/Edit panel.
  4. Repeat from Step 1 for each of the remaining columns you want to populate.

Related references