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