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

Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• The SHOW PROCEDURES command can be executed in SQL mode only.
• If you do not specify a wild-card pattern, NCI displays all procedures that exist in the current
schema.
• If you specify a wild-card pattern, NCI displays only the procedure names that match the
wild-card pattern.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Examples
This command shows all the procedures, by default:
SQL>show procedures;
PROCEDURES NAMES
-------------------------------------------------------------------------------------------
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 previous executed SQL
statement. If the previous executed command was an interface command, then 0 is returned,
else the count of the previously executed SQL statement is returned. For a few interfaces that
invoke the catalog API's (SHOW TABLES/VIEWS/SYNONYMS/MVS etc.) then 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 SCHEMA Command
The SHOW SCHEMA command displays the current schema of the NCI session.
Syntax
SHOW SCHEMA
144 NCI Commands