A DB2 control structure used to retrieve rows from a result set.
A database object used to traverse the results of an SQL query.
A database control structure used by the Data Access Builder to point to a specific row within some ordered set of rows and to retrieve rows from a set, possibly making updates or deletions.
a database query and its result set
a feature we have not met so far, because they are normally only applicable either when using SQL embedded in an external program, or within procedural language function stored in the database, often referred to as 'stored procedures'
a handle or name for a private SQL area--an area in memory in which a parsed statement and other information for processing the statement are kept
a means for accessing the individual rows in a table or result set
a mechanism that allows the individual rows resulting from a query to be processed one at a time
a mechanism used to fetch more than one row in a Pl/SQl block
a mechanism you can use to fetch rows one at a time
a moveable pointer to a row in the result table of an active query statement
a named control structure used by an application program to point to a row of interest within some set of rows and to retrieve rows from the set, possibly making updates and deletions
a named SQL statement
an identifier that you associate with a group of rows
a PL/SQL construct used to process a SQL statement one row at a time
a pointer that identifies a specific working row within a set a
a private SQL Work area
a query that can only return a single row
a result set that you can loop over one row at a time - similar to using CFOUTPUT with a query
a row-at-a-time processing feature
a set of records that represent the results of a query
a special kind of advanced SQL query which is executed one row at a time
a SQL result set that allows you to perform row-oriented operations on the result set (this differs from standard SQL result sets, which return all the rows in the result set)
a temporary location like buffer in the memory where the result of a query is stored for further processing
a tool that allows you to step through a result set row-by-row
a variable that runs sql through the tuples of some relation
a variable that runs through the tuples of hosting server sql web
a vehicle for keeping track of position as a program traverses through query result sets
a work area for a SQL statement that returns one or more rows
An intermediate table that exists for more than one SQL statement.
A named control stucture used by an application program to point and select to a row of data in a table or view. It holds the results of a SQL query. ADO recordsets are sometimes called cursors.
A named linkage to a result set, used to access and update rows from a programming interface. In Adaptive Server Anywhere, cursors support forward and backward movement through the query results. Cursors consist of two parts: the cursor result set, typically defined by a SELECT statement; and the cursor position. See also: cursor result set, cursor position.
A construct used to reference the current position in a result. SQL defines a cursor mechanism that can be used through JDBC to do positioned updates and deletes.
A method of accessing rows of data. Jet supports dynaset and snapshot cursors.
An SQL object that points to a row in the results table returned by a SELECT statement. A cursor enables an application to process data from multiple data sets simultaneously rather than sequentially.
Cursors are pointers used to fetch rows from a result set. One can think of a cursor as a data structure that describes the results returned from a SQL SELECT statement. One of the variables in this structure is a pointer to the next record to be fetched from the query results.
A named control structure used by an application program to point to a specific row within some ordered set of rows. The cursor is used to retrieve rows from a set. See also unambiguous cursor, ambiguous cursor.
In database packages, the term cursor refers to a control structure for the successive (and potential processing) of records in a result set as returned by a query.
