Adding a Table I/O

Overview

Use the Table I/O option in the logic statements panel to create instructions that perform table input and output. The Table I/O feature enables you to access a table or a business view and perform the following tasks:

  • Retrieve records.
  • Update or delete records.
  • Add records.

To add a Table I/O:

  1. On the design page, hover over the location where you want to add Table IO and then click the + icon. Select Table I/O from the Action menu. The Table I/O panel is displayed on the right.
  2. In the Table I/O panel, change the label and description of the Table I/O.

    For Table I/O, by default, the Label field displays the selected operation (such as Fetch Single, Insert, Update, and so on) and the Description field displays the object name. You can override the automatically updated values in the Label and Description fields. But, if you change the values in the Operation and Object Name fields after overriding the values in the Label and Description fields, the system will not automatically replace the new values in the Label and Description fields unless the overridden values are blank. If you change the Object Type from Table to View or vice versa, the Description field will be automatically populated with the value in the Object Name field even if it was previously overridden.

  3. From the Object Type field, select Table or View.
    Note: If you select the View option, the system displays the Get View from Form icon. Click this icon and from the Get View from Form window, you can search and select the required application, form, and business view.
  4. Click the Search icon and then find and select the required object name.
  5. Select the required value from the Operation drop-down list. For more information, see Available Operations.
  6. Click the Launch Column Mapping Builder icon. The system displays the Column Mapping window containing two panels:
    • Column Mapping Panel (left panel): Displays the table with the Column, Filer, Return, and Mapped Object information.
    • Object Selector Panel (right panel): Filter and select the value for the Mapped Object field using this panel. You can click the Close or Open icons to hide or view this panel. See Valid Mapping Operators.
  7. Click the Close button.

    Your mappings are displayed in the Table I/O panel.

  8. Click Save.

(Release 9.2.6.3)You can add the Table I/O parameters to the Data Structure or to the Variables tab from the Column Mapping window. Click the drop-down icon next to the Column field and select the Add to Data Structure or Add to Variables or Add to Array (Release 9.2.7) options as required.