SQLCODE

Purpose

Return a number indicating the result of the last SQL statement

Syntax

SQLCODE

See Also

PSEUDO COLUMNS, INSERT, SELECT, UPDATE

Description

SQLCODE will return a number indicating the result of the last SQL statement. SQLCODE return values:

SQLCODE	Description
0	The SQL statement completed successfully
+100	No rows were found or the end of the set reached
<0	An error occurred

Example

set gateway to "rec@server1:user1/pass1-southind"
SELECT * FROM example WHERE state = "MA"
? sqlcode
         0

Products

Recital, Recital Server