Once ETK 5.0 is connected to the database (refer to the section, Connection Manager in the chapter Creating a Process), right-click the source tree node and select Add/Insert???Add Select/Add Cursor as shown below. A new select/ cursor node is added. Name the select/cursor node. On selecting Add Select option, query returns one row where as on selecting Add Cursor option, query returns multiple rows.
Nodes Configuration_Figure 8: Adding Select or Cursor
On selecting Add/Insert from the menu, a sub-menu is displayed as shown in Nodes Configuration_Figure 7 with the following options:
Add Select
This menu item by default creates a child select group to the current select group.
Add Cursor
This menu item by default creates a child cursor to the current cursor
Insert Above
This menu item is used to create and insert a select or cursor above a particular select or cursor which is selected at that time. This menu item is disabled for the first select or cursor.
Configure Procedure
This menu item is used to configure a procedure based on the database connection, package, procedure and parameters selected.