Browse Prior Art Database

Multi Query Cursor

IP.com Disclosure Number: IPCOM000013940D
Original Publication Date: 2001-Apr-22
Included in the Prior Art Database: 2003-Jun-19

Publishing Venue

IBM

Abstract

For the purposes of this publication, a query is a select statement against a relational database to retrieve a result set consisting of zero or more rows of data. A cursor is a positional pointer into the result set. A primary key is a unique identifier for a row of data within a table. A multi query uses one or more queries to return one logical result set. A single cursor is used to position into each of the result sets sequentially. As one result set is completed, the next query is executed and the cursor continues to the first row of the next physical result set. The logical result set, which is what the user sees, can be implemented as an ordered set or an ordered collection based on the ordering of the individual queries. ADVANTAGES Supports queries that are too complex to code or run with a single dynamic SQL statement