SQLCODE

From Recital Documentation Wiki
Revision as of 12:36, 13 March 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

SQLCODE

Class

Pseudo Columns


Purpose

Return a number indicating the result of the last SQL statement


Syntax

SQLCODE


See Also

PSEUDO COLUMNS, INSERT, SELECT, UPDATE


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.

The SQLCODE Pseudo Column 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

// Display all overdue accounts with 15% commission in
// Sorted "name" and "paid date" order with the row number.
EXEC SQL
SELECT ROWNUM, name, address, balance, cost*1.15
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;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer