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.