Java DB

Apache Derby

Derby Tools and Utilities Guide

Derby Getting Started
Derby Reference Manual
Derby Developer's Guide
Derby Performance Tuning
Derby Server and Admin Guide
Derby Tools and Utilities
Derby Tools and Utilities
-Copyright
-License
-About this guide
-What are the Derby tools and utilities?
-Using ij
-ij properties reference
-ij commands and errors reference
-ij commands
-Absolute command
-After Last command
-Async command
-Autocommit command
-Before First command
-Close command
-Commit command
-Connect command
-Describe command
-Disconnect command
-Driver command
-Elapsedtime command
-Execute command
-Exit command
-First command
-Get Cursor command
-Get Scroll Insensitive Cursor command
-Help command
-Last command
-LocalizedDisplay command
-MaximumDisplayWidth command
-Next command
-Prepare command
-Previous command
-Protocol command
-Readonly command
-Relative command
-Remove command
-Rollback command
-Run command
-Set Connection command
-Show command
-Wait For command
-Syntax for comments in ij commands
-Syntax for identifiers in ij commands
-Syntax for strings in ij commands
-ij errors
-Using the bulk import and export procedures
-Storing jar files in a database
-sysinfo
-dblook
-SignatureChecker
-Trademarks

 

ij.showNoCountForSelect property

Function

The ij.showNoCountForSelect property specifies whether to display messages indicating the number of rows selected. 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 to true, then with the property set to false.

java -Dij.showNoCountForSelect=true org.apache.derby.tools.ij
ij version 10.6 
CONNECTION0*
* = current connection
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 10.6 
CONNECTION0*
* = current connection
ij> select * from t1;
C1
-----------
1
2
3

3 rows selected

ij>

 

javadb@jdbcurl.com