Try OpenEdge Now
skip to main content
Java Open Clients
Passing Parameters : Passing temp-tables and ProDataSets : Java mechanisms for passing temp-tables and ProDataSets : SQL ResultSets mechanism
 
SQL ResultSets mechanism
The SQL ResultSet provides a data streaming model for accessing temp-tables only and is the only mechanism for accessing complex data in the Java Open Client prior to OpenEdge Release 10.1A. This model works similar to a one-way tape reader or writer. It allows you to access the records (rows) of a temp-table parameter in only one direction, from beginning to end. To access previous rows, you must re-start the retrieval from the beginning. It is provided mainly for backward compatibility.
For more information on passing and managing a temp-table as an SQL ResultSet, see Passing Temp-tables as SQL ResultSet Parameters.