Neoview Command Interface (NCI) Guide (R2.5)

-------------------------------------------------------------------------
ADJUSTSALARY DAILYORDERS EMPLOYEEJOB HELLO
HELLOSTRING LOWERPRICE MONTHLYORDERS MYPROC
N0101 N0122 N0124 N0200
N0202 N0209 N0210 N0211
N0212 N0213 N0216 N0226A
N0302 N4210 N4260 N4261
N4264 N4267
SHOW RECCOUNT Command
The SHOW RECCOUNT command displays the record count of the previously executed SQL
statement. If the previously executed command was an interface command, NCI returns zero.
Otherwise, NCI returns the count of the previously executed SQL statement. For commands that
invoke the catalog APIs—SHOW TABLES, VIEWS, SYNONYMS, MVS, and so on—SHOW
RECCOUNT returns the count of the database objects.
Syntax
SHOW RECCOUNT
Considerations
• You must enter the command on one line. The command does not need an SQL terminator.
• The command works in all modes.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Examples
This command displays the record count of the SQL statement that was executed last:
SQL> select * From employee;
SQL>show reccount
RECCOUNT 3
SHOW ROLE Command
The SHOW ROLE command displays the role in which you are currently logged on during an
NCI session.
Syntax
SHOW ROLE
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• You can execute this command in any NCI mode.
Example
This SHOW ROLE command displays the current role for the NCI session:
SQL>set connectopt role ROLE.MGR
SQL>connect [e-mail], mydsn
Password:
SQL>show role
ROLE ROLE.MGR
For more information, see the “CONNECT Command” (page 78).
136 NCI Commands