Define the schema for a temp-table parameter mapped to a java.sql.ResultSet

Defining the schema for an ABL TABLE or TABLE-HANDLE parameter passed as a java.sql.ResultSet is a multi-step process.
Note: If you pass a temp-table as an java.sql.ResultSet parameter you must access the parameter as a data stream. For more information on accessing temp-tables as java.sqlResultSet parameters, see Pass Temp-tables as SQL ResultSet Parameters

To define the schema for a temp-table parameter passed as a java.sql.ResultSet:

  1. Define a com.progress.open4gl.ProResultSetMetaDataImpl object.
  2. Add field descriptions to the ProResultSetMetaDataImpl object.
  3. If the parameter is for input or input-output, define a java.sql.ResultSet to hold the parameter value.
  4. Add the ProResultSetMetaDataImpl object as a temp-table parameter to your ParamArray object using the appropriate set parameter method.
Note: You can also pass a temp-table parameter as a ProDataGraph. For more information, see Define the schema for a temp-table parameter mapped to a ProDataGraph.