In the same way, install a SQL requestor on st1, and click on the "configure" button.
Parameterize a connection by default, as illustrated below.
Select "step by step" in the "Application simulation" combo box.
Select "SQL requestor" in st1’s pop-up menu.
The SQL requestor’s interface is displayed: click on the "connect" button and watch the simulation.
Note: if you click on the IP and TCP labels in the windows' toolbar, a balloon help indicates the IP addresses and the port numbers which are used for the exchange.
Input the table’s name (product), as illustrated below:
Click on the "send" button.
The request is sent to the DBMS that executes it, before sending back the result. It is a scalar value (only one value actually).
Select "projection" in the "SQL query" combo box, and input "*" in the "select" textbox.
Click on "send". This time, it is not a scalar value any more, but a set of rows.
The DBMS opens a cursor, and the rows are sent to the requestor one after the other.
Click on the "disconnect" button: the DBMS releases the resources linked to the connection.
