NOTFOUND
NOTFOUND
is a predefined constant used
to check if an SQL statement returns rows.
Syntax
NOTFOUND
Usage
The NOTFOUND
constant
is used to test the execution status of an SQL statement returning
a result, to check whether rows have been found.
The NOTFOUND
constant
is equal to 100.
You typically compare SQLCA.SQLCODE
to NOTFOUND
,
after a SELECT
statement execution.
Example
MAIN
DATABASE stores
SELECT tabid FROM systables WHERE tabid = 1
IF SQLCA.SQLCODE = NOTFOUND THEN
DISPLAY "No row was found"
END IF
END MAIN