Common Set Syntax:
READ
[(limit)] RESULT SET
result-set
INTO
|
FROM
ddm-name
|
|||
[GIVING
[:] sql-code] |
||||
END-RESULT |
(structured mode only) | |||
LOOP |
(reporting mode only) |
Extended Set Syntax:
READ
[(limit)] RESULT SET
result-set
INTO
|
FROM
ddm-name
|
|||
[WITH
INSENSITIVE SCROLL [:]
scroll-hv] |
||||
[GIVING
[:] sql-code] |
||||
[WITH
ROWSET POSITIONING FOR
|
[:] row_hv |
ROWS ]
|
||
END-RESULT |
(structured mode only) | |||
LOOP |
(reporting mode only) |
This document covers the following topics:
For an explanation of the symbols used in the syntax diagram, see Syntax Symbols.
Belongs to Function Group: Database Access and Update
See also READ RESULT SET - SQL in the Natural for Db2 part of the Database Management System Interfaces documentation.
The SQL statement READ RESULT SET
can only be used in conjunction with a
CALLDBPROC
statement. It is
used to read a result set which was created by a stored procedure that was invoked by a
previous CALLDBPROC
statement.
This statement is available only with Natural for Db2.
Syntax Element | Description |
---|---|
limit
|
Limit Option:
You can limit the number of rows to be read. You can specify the limit either
as a numeric constant ( |
result-set
|
Result Set:
As Note: |
INTO
|
INTO Clause:
The The |
VIEW
view-name |
VIEW Clause:
The number of columns of the result set must correspond to the number of fields defined in the view (not counting group fields, redefining fields and indicator fields). |
parameter |
Parameter:
Each |
FROM ddm-name
|
DDM Name:
As For further information, see |
WITH INSENSITIVE
SCROLL
[:] scroll_hv |
WITH INSENSITIVE SCROLL Clause:
This clause belongs to the SQL Extended Set. It is available only with Natural for Db2. Using this clause causes the application to use an insensitive
scrollable cursor to access the result set created by the previously invoked
stored procedure. In order to use this clause, the stored procedure must have
created the result set with a scrollable cursor.
If the The processing will be terminated, if the application issues an
If the |
GIVING
sqlcode
|
GIVING sqlcode Clause:
This clause may be used to obtain the SQLCODE of the SQL "fetch" operation used to process the result set. If this clause is specified and the SQLCODE of the SQL operation is not
The If the |
WITH ROWSET POSITIONING
FOR ... ROWS |
WITH ROWSET POSITIONING FOR ... ROWS Clause:
This clause belongs to the SQL Extended Set. It is available only with Natural for Db2. Using this clause causes the application to read multiple rows of data from the
result set by the previously invoked stored procedure. The
If the The processing will be terminated, if the application issues an
If the |
END-RESULT
|
End of READ RESULT SET Statement:
In structured mode, the Natural reserved keyword In reporting mode, the Natural statement |
LOOP |
See Example of CALLDBPROC/READ RESULT SET in the section CALLDBPROC - SQL of the Natural for Db2 documentation.