You can create or modify customized SQL accesses for your
current instance.
Before you begin
you must be familiar with the SQL syntax before customizing
SQL accesses.
About this task
To add or modify generation elements, you must:
- Open the Design explorer view of the Design perspective and select an instance.
- On an open location (represented by a
), click on an instance line and right-click to display the
popup menu. In this menu, select Open to open
the instance, or double-click on it.
- Then access its -G Lines tab from
the Overview tab or directly select the -G Lines tab in the editor.
- Click on the arrow in front of the '-GG Lines' section. A table displays the list of customized SQL accesses already
specified on this Segment, if any, otherwise it is empty.
Note: You can also associate -GG lines with the entities called onto
the Segments from the -CE lines tab in the Segment
editor.
- Click on the T column to enter the
generation element type. Then, enter the description in the dedicated
column Description.
- Press the Enter key to complete another line.
What to do next
You can change the order of the lines displayed by clicking

or

. To
delete a line, click the line and press

.