Result Set Port Mapping

The Result Set Port Mapping tab is used to expose the elements of result set of the stored procedure on result set ports. The result set can be exposed as scalars, vectors or matrices depending on the setting of the Result port dimension property.

This parameter tab is based on the parameter matrix concept. Use the Add button to add a new row and the remove button to remove a selected row. The columns of the matrix are described below.

The layout of the parameter matrix depends on the Result port dimension property. The column layout for the different settings are explained below.

Scalar result dimension

This column layout is used to map elements of the result set to scalar result set ports. Each row in the parameter matrix will correspond to one scalar result port. The columns are:

  • Column name. Type in the column of the result set from which to pick the scalar result port value.
  • Row number. Type in the row (starting at 1) of the result set from which to pick the scalar result port value.
  • Port type. Select the desired scalar result port type. The type may be Analog, String or Digital. The actual elements of the result set will be casted to the selected port type if possible.
  • Port name. Type in the desired scalar result port name.

Vector result dimension

This column layout is used to map elements of the result set to vector result set ports. Each row in the parameter matrix will correspond to one vector result port. The columns are:

  • Column name. Type in the column of the result set from which to pick the vector result port value.
  • Port type. Select the desired vector result port type. The type may be Analog or String. The actual elements of the result set will be casted to the selected port type if possible.
  • Port name. Type in the desired vector result port name.

Matrix result dimension

This layout is used to specify the name of the matrix result set port when the Result port dimension is matrix. Matrix result dimension can only be used for numeric result sets, and the dimension of the matrix port reflects the dimension of the result set.