SQL/MP Reference Manual

ManualsBrandsHP ManualsServerHP NonStop G-Series

HP NonStop SQL/MP Reference Manual—523352-013

R-23

ROWCOUNT Option

ROWCOUNT Option

ROWCOUNT is an option of the SQLCI SET STYLE report writer command that

causes SQLCI to generate or suppress a line that reports the number of rows returned

as the result of a SELECT.

ON generates the row-count line.

OFF suppresses the row-count line.

The default is ON.

Example—ROWCOUNT

This example shows a simple SELECT with ROWCOUNT ON (the default) and with

ROWCOUNT OFF:

>> SELECT * FROM MYTABLE;

aaa 122345

bbb 333333

ccc 987653

--- 3 row(s) selected.

>> SET ROWCOUNT OFF;

>> SELECT * FROM MYTABLE;

aaa 122345

bbb 333333

ccc 987653

>>

ROWCOUNT { ON }

{ OFF }