Try OpenEdge Now
skip to main content
Java Open Clients
Passing Temp-tables as SQL ResultSet Parameters : SQL ResultSet streaming and call-back sequence : OUTPUT ResultSet objects : Order of access for OUTPUT ResultSet objects
 
Order of access for OUTPUT ResultSet objects
The stream of data in an OUTPUT ResultSet can be thought of as a one-directional tape. It must be read in sequence, and there is no way to get the same data more than once or go backwards. When getting the data from a single TABLE or TABLE-HANDLE, the data for each row and each field in that row must be requested in sequence, and no request can be repeated. Also, if there is more than one OUTPUT TABLE or TABLE-HANDLE parameter for a method, they must be perused in sequence. Data from the first TABLE or TABLE-HANDLE parameter must be completely fetched or the ResultSet closed before any data can be retrieved from the second, and so on. It is possible, however, to skip data. For example, you can fetch the value of field 1 and then the value of field 10; however, you cannot then reverse and obtain the values for fields 2 through 9.