Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Statements : SHOW ROWCOUNT
 

SHOW ROWCOUNT

Displays the current value of the row count.

Syntax

SET ROWCOUNT rowcount_number;SHOW ROWCOUNT;

Example

The following example demonstrates the SHOW ROWCOUNT statement:
SET ROWCOUNT 10;
SHOW ROWCOUNT;
The above query returns the row count value as 10.
* Related Statement