Difference between revisions of "SQLCODE"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
|
(No difference)
|
Revision as of 04:17, 25 October 2011
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