Difference between revisions of "SQLCNT"

Revision as of 17:41, 8 December 2009

Purpose

Return the number of rows affected by the last SQL statement

Syntax

SQLCNT

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 SQLCNT Pseudo Column will return the number of rows affected by the last SQL statement. For example, after a SELECT statement, SQLCNT will contain the number of rows selected.

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, Recital Server