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] |
||||
END-RESULT |
(structured mode only) | |||
LOOP |
(reporting mode only) |
This document covers the following topics:
For explanations of the symbols used in the syntax diagram, see Syntax Symbols.
Belongs to Function Group: Database Access and Update
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.
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. This clause is not currently supported. When used, it will cause a compiler error. |
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 |
END-RESULT
|
End of READ RESULT SET Statement:
In structured mode, the Natural reserved keyword
In reporting mode, the Natural statement |
LOOP |