Difference between revisions of "FETCH"

From Recital Documentation Wiki
Jump to: navigation, search
Line 49: Line 49:
 
|INTO data variable||Specifies a list of data variables to receive the extracted row values. The list may contain fewer variables than there are table columns, but may not contain more variables than there are table columns.
 
|INTO data variable||Specifies a list of data variables to receive the extracted row values. The list may contain fewer variables than there are table columns, but may not contain more variables than there are table columns.
 
|-
 
|-
|INTO XML
+
|INTO XML <xml filename>||Specify the name of an XML file that will be created and populated with all the rows from the open cursor.
<xml filename>||Specify the name of an XML file that will be created and populated with all the rows from the open cursor.
+
 
|-
 
|-
 
|}
 
|}

Revision as of 16:06, 19 March 2009

FETCH

Class

SQL Applications


Purpose

Fetches rows returned by the SELECT statement defined in a CURSOR


Syntax

FETCH

[NEXT | PREVIOUS | FIRST | LAST | ABSOLUTE <row position> | CURRENT | RELATIVE <row position>] <cursor>

INTO [ [, ...] | XML <xml filename>]


See Also

DECLARE CURSOR, DROP CURSOR, OPEN, SELECT


Description

The FETCH command fetches rows returned by the SELECT statement defined in a CURSOR. It reads the values in the specified row from the open cursor and places them in the bound data variables. If the variables do not exist, they are created. If they do exist, they are updated. The cursor must have already been opened with the OPEN statement.


Keywords Description
NEXT Retrieves the next row from the open cursor. This is the default if no direction is specified.
PREVIOUS Retrieves the previous row from the open cursor.
FIRST Retrieves the first row from the open cursor.
LAST Retrieves the last row from the open cursor.
ABSOLUTE row position Retrieves the absolute row position. Row positions start at 1 in the open cursor.
CURRENT Retrieves the current row from the open cursor.
RELATIVE row position Retrieves the row position relative to the current cursor position. The row position can be negative to move to previous rows, positive to move to next rows and zero to retrieve the current row.
cursor The cursor that has been declared with the DECLARE CURSOR statement.
INTO data variable Specifies a list of data variables to receive the extracted row values. The list may contain fewer variables than there are table columns, but may not contain more variables than there are table columns.
INTO XML <xml filename> Specify the name of an XML file that will be created and populated with all the rows from the open cursor.


Example

// Declare the cursor to retrieve records from the accounts table
EXEC SQL
DECLARE accounts CURSOR FOR
SELECT name, address, ord_value, balance
FROM accounts
ORDER BY name; 
 
// Open the cursor and establish a temporary set of records
EXEC SQL
OPEN accounts;
 
// Retrieve each row from open cursor
DO WHILE sqlcode = 0
EXEC SQL
FETCH NEXT accounts
INTO m_name, m_address, m_ord_value, m_balance;
ENDDO 
 
// Close the cursor
EXEC SQL
CLOSE accounts;
 
// Free up any resources used for the cursor
EXEC SQL
DROP CURSOR accounts;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer