SQLCODE

From Recital Documentation Wiki
Revision as of 15:03, 5 July 2011 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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