Try OpenEdge Now
skip to main content
Java Open Clients
Passing Temp-tables as SQL ResultSet Parameters : Passing a TABLE or TABLE-HANDLE as an OUTPUT parameter : Getting meta data for OUTPUT TABLE and TABLE-HANDLE parameters
 

Getting meta data for OUTPUT TABLE and TABLE-HANDLE parameters

You can obtain schema information for a standard ResultSet object by accessing the java.sql.ResultSetMetaData object returned by the getMetaData() method on the ResultSet. This ResultSetMetaData object allows you to access the schema information for each column in the ResultSet.
The com.progress.open4gl.ProResultSetMetaData interface is an OpenEdge extension of the java.sql.ResultSetMetaData interface. The extensions in ProResultSetMetaData access the schema information for the ProResultSet object viewed as temp-table fields, using the array model. To use these extensions, you must cast the ResultSetMetaData object returned from getMetaData() as a ProResultSetMetaData object. For example:
// In this code, resultOut is a ProResultSet obtained as an output parameter.

java.sql.ResultSetMetaData metaData = resultOut.getMetaData();

// To access the extended set of methods the application does:
com.progress.open4gl.ProResultSetMetaData proMetaData =
   (com.progress.open4gl.ProResultSetMetaData)metaData;

// Now we use proMetaData to access the ProResultSetMetaData extensions
The rest of this section describes the ProResultSetMetaData methods and how they allow you to view a ProResultSet object both as standard ResultSet columns, using the flat model, and as temp-table fields, using the array model.
* Standard methods in the ProResultSetMetaData class
* ProResultSetMetaData class extension to java.sql.ResultSetMetaData