Create a Column Map Procedure

This section explains how to create a Column Map Procedure from the main window or the Column Map Procedure Editor.

From the Main Window

To create a Column Map Procedure:

  1. In the main window, select New from the File menu.
  2. Select Column Map Proc from the Definitions submenu to open Column Map Procedure Editor.
  3. In the Description box, optionally type a description that indicates the purpose of the Column Map Procedure.
  4. In the code window, edit code in the sample Column Map Procedure provided with Optim to carry out your purpose.
  5. In the File menu, select Compile to validate the code. If the code generates an error, an arrow is placed on a line to indicate an error. Correct the code, as necessary.
  6. Select Save from the File menu to open the Save a Column Map Proc dialog.
  7. In the Pattern box, specify a unique Column Map Procedure name and click Save.

From the Column Map Procedure Editor

To create a Column Map Procedure:

  1. In the main window, select Column Map Proc from the Definitions menu to open the Column Map Procedure Editor and most recently edited Column Map Procedure.
  2. Your next step depends on your purpose:
    • To create a new Column Map Procedure, select New from the File menu to display the sample Column Map Procedure provided with Optim™.
    • To create a new Column Map Procedure modeled on an existing one, open the desired Column Map Procedure and select Save As from the File menu.
    • To create and store a copy of the active Column Map Procedure and continue editing, select Save Copy As from the File menu.

These steps are the minimum required to create a Column Map Procedure. The steps to edit a new Column Map Procedure or existing Column Map Procedure are similar. See Using the Editor for details.

Note: You can also open the Column Map Proc Editor while editing a Column Map by right-clicking a Source Column grid cell and selecting List Procedures or Open Procedure from the short-cut menu.