SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-363
Example of SELECT ROW COUNT
•
Records have been added, deleted, or moved from one or more partitions of the
target table by a MODIFY operation (in this case, only the affected partitions are
marked with an invalid row count).
If partitions of a table are marked with an invalid row count, the row count can be reset
by deleting all the rows from the affected partition(s) using either a DELETE or
PURGEDATA statement.
Example of SELECT ROW COUNT
•
This example selects the row count from the persnl.employee table:
SELECT ROW COUNT FROM persnl.employee;
(EXPR)
---------------------------------------
11487
Note. An invalid row count on one or more partitions only affects the ability of the SELECT
ROW COUNT statement to return a valid count. An invalid row count does not affect any other
SQL/MX operations and can be safely ignored. In such cases, a SELECT statement with
COUNT(*) can be used instead of returning a row count.