Creating dataItem parts from an SQL record part

After you declare structure items in an SQL record part, you can use a special mechanism in the EGL editor to create dataItem parts that are equivalent to the structure items. For general information, see Overview on creating dataItem parts from an SQL record part.

If the Outline view is not displayed, open that view by selecting Show View > Outline from the Window menu.

Do as follows in the Outline view:
  1. For a given SQL record part, hold down Ctrl while clicking on each of the structure items of interest. To select all the structure items in a given record, click the topmost structure item, then hold down Shift while clicking on the bottommost structure item.
  2. Right-click on the selected structure items.
  3. In the context menu, click Create DataItem part.

The dataItem parts are written at the bottom of the EGL source file, and each structure item is changed to refer to the equivalent part.

Related concepts
Creating dataItem parts from an SQL record part (overview)
SQL support

Related tasks
Retrieving SQL table data

Related reference
SQL record part in EGL source format

Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.