Extract Value from JDBC Result Set

The Extract Value from JDBC Result Set filter lets you store the text of a specific JDBC result set value in a property. You can create this filter either manually from the filter list or by using the embedded filter commands on a result set response.
dts
The Extract Value from JDBC Result Set filter lets you store the text of a specific JDBC result set value in a property. You can create this filter either manually from the filter list or by using the embedded filter commands on a result set response.
 
To create the filter manually:
 
Complete the following fields:
  • Filter in
    The name of the property to consider as the last response for the step. If the property is not in the pull-down menu, you can enter it. The property must exist.
  • Column (1-based or name)
    The index or name of the column (field).
  • Row (0-based)
    The row to retrieve the value. This field is a zero-based index.
  • Property
    The name of the property where the value in the cell at the row/column intersection is stored.
  • Filter Run Results
    Displays the property and values that result from running the filter.
  • Run Filter
    To run and execute the filter, click 
    Run Filter
    . The results appear in the 
    Filter Run Results
     section.
 
To create a filter from a result set response:
 
 
Follow these steps:
 
  1. Display the step response that contains the result set.
  2. From the result set, select the cell of the value to store in the filter.
    Creating a filter from a result set response example  
  3. Click 
    Generate Filter
      LISA--icon_image_threebluearrows , as the arrow in the previous graphic shows.
  4. In the dialog, enter the property key:
    Enter the property key dialog  
  5. Click 
    OK
    .
The filter to store the value 
sbellum
 in the property 
theLogin
 is created.