Difference between revisions of "SQLCODE"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
| Line 11: | Line 11: | ||
SQLCODE will return a number indicating the result of the last SQL statement. SQLCODE return values: | SQLCODE will return a number indicating the result of the last SQL statement. SQLCODE return values: | ||
| − | {| class="wikitable" width=100% | + | {| class="wikitable" width="100%" |
!SQLCODE||Description | !SQLCODE||Description | ||
|- | |- | ||
Revision as of 10:12, 31 January 2013
Contents
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
