The SQL ResultSet provides a data streaming model for accessing temp-tables only and was the only mechanism for accessing complex data in the Java Open Client prior to OpenEdge Release 10.1A. This model functions much like a one-way tape reader or writer. It allows you to access the records (rows) of a temp-table parameter in a single forward direction, from beginning to end. To revisit earlier rows, you must restart the retrieval process from the beginning. This mechanism is retained mainly for backward compatibility.

Beginning with OpenEdge 10.1A, the ProDataGraph mechanism was introduced and is now the recommended approach for passing temp-tables and ProDataSets to a Java Open Client.

For more information on passing and managing a temp-table as an SQL ResultSet, see Pass Temp-tables as SQL ResultSet Parameters. For guidance on using the preferred mechanism, see Pass temp-tables as ProDataGraph parameters and related topics.