Defining 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 Passing 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.