Difference between revisions of "SQLCODE"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
=SQLCODE=
 
 
 
==Class==
 
Pseudo Columns
 
 
 
 
==Purpose==
 
==Purpose==
 
Return a number indicating the result of the last SQL statement
 
Return a number indicating the result of the last SQL statement
Line 19: Line 12:
  
 
==Description==
 
==Description==
A Pseudo Column behaves like a table column, but is not actually stored in the table. You can select from Pseudo Columns, but they cannot be updated.  Pseudo Columns provide extra information about a SELECT row set.
+
SQLCODE will return a number indicating the result of the last SQL statement.  SQLCODE return values:
 
+
The SQLCODE Pseudo Column will return a number indicating the result of the last SQL statement.  SQLCODE return values:
+
  
  
Line 39: Line 30:
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
// Display all overdue accounts with 15% commission in
+
set gateway to "rec@server1:user1/pass1-southind"
// Sorted "name" and "paid date" order with the row number.
+
SELECT * FROM example WHERE state = "MA"
EXEC SQL
+
? sqlcode
SELECT ROWNUM, name, address, balance, cost*1.15
+
        0
FROM accounts
+
WHERE paid_date < date()
+
ORDER BY name, paid_date;
+
// Check return code and number of rows returned
+
EXEC SQL
+
SELECT DISTINCT sqlcode, sqlcnt from accounts;
+
 
</code>
 
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:Pseudo Columns]]
 
[[Category:Pseudo Columns]]

Latest revision as of 15:03, 5 July 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