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

• To run the connectivity commands in SQL mode, you must run the CMDOPEN command
first. If you do not run CMDOPEN and try to run one of the connectivity commands, NCI
returns a syntax error.
• After you run CMDOPEN, NCI recognizes only connectivity commands. To issue SQL
statements, you must run CMDCLOSE. Otherwise, an SQL statement returns an error or
does not display results.
Example
This CMDOPEN command enables you to run connectivity commands in SQL mode:
SQL>cmdopen;
--- SQL operation complete.
SQL>add ds DDLTestDS, maxserver 10, availserver 2, initserver 2,
+>srvridletimeout "15", conntimeout system_default;
CMDCLOSE Command
The CMDCLOSE command ends CMDOPEN's effect on the NCI session and enables you to run
SQL statements.
Syntax
CMDCLOSE
Considerations
• This command runs in SQL mode only.
• The command requires an SQL terminator.
• Users associated with roles that have USER and OPERATOR privileges can execute this
command. For more information, see the “ADD USER Command” (page 158) or “ALTER
USER Command” (page 167).
• After you run CMDOPEN, NCI recognizes only connectivity commands. To issue SQL
statements, you must run CMDCLOSE. Otherwise, an SQL statement returns an error or
does not display results.
Example
The CMDCLOSE command ends CMDOPEN's effect on the NCI session and enables you to run
SQL statements again in SQL mode:
SQL>cmdopen;
--- SQL operation complete.
SQL>add ds DDLTestDS, maxserver 10, availserver 2, initserver 2,
+>srvridletimeout "15", conntimeout system_default;
--- SQL operation complete.
SQL>cmdclose;
--- SQL operation complete.
SQL>select * from sch.tab1;
168 Connectivity Commands