Result Set Values Display. In the Result Set tab you must specify the result name and the variable that you want to map to. Set the grid color.
In a real world scenario we have a legacy stored procedure which shows a result set with one column CustomerName. Following is the example which makes use of the ResultSetCONCUR_UPDATABLE and ResultSetTYPE_SCROLL_INSENSITIVE described in the Result Set tutorial. The text about queries shows how the result of a query is returned as a javasqlResultSetThis ResultSet is then iterated to inspect the result.
A JDBC ResultSet contains records.
In this special case variable value is set to the value of the last row. This example would explain INSERT UPDATE and DELETE operation on a table. 3 Use the Select Value to select the attribute that you wish to apply the condition to in this example WOPRIORITY. In the Result Set tab you must specify the result name and the variable that you want to map to.