Previous Topic

Next Topic

Book Contents

Book Index

Adding Select or Cursor

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.

See Also

Configuring R2O

Creating a Query

Adding Conditions

Virtual Columns

Renaming a Select /Cursor

Mapping the Destination

Container Classes

Naming Select or Cursor

Reusing Select or Cursor

Find Option

Executing a Query

Delete Node Option

Exception Tab

R2O Menu Options