ij.showNoCountForSelect property The ij.showNoCountForSelect property specifies whether to display messages indicating the number of rows selected. ij.showNoCountForSelect property

The default is false; that is, if the property is not set, select count messages are displayed.

Syntax ij.showNoCountForSelect={ false | true } Example

In the following example, ij is first started with the ij.showNoCountForSelect property set to true, then with the property set to false.

java -Dij.showNoCountForSelect=true org.apache.derby.tools.ij ij version ij> connect 'jdbc:derby:sample'; ij> create table t1 (c1 int); 0 rows inserted/updated/deleted ij> insert into t1 values 1, 2, 3; 3 rows inserted/updated/deleted ij> select * from t1; C1 ----------- 1 2 3 ij> disconnect; ij> exit; java -Dij.showNoCountForSelect=false org.apache.derby.tools.ij ij version connect 'jdbc:derby:sample'; ij> select * from t1; C1 ----------- 1 2 3 3 rows selected ij>