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

NOTE: If the script file is outside the directory of the hpnci.cmd or hpnci.sh file (by default,
the NCI bin directory), you must specify the full path of the script file in the @ or OBEY
command.
SQL>@C:\ddl_scripts\sch_invent.sql
SQL>-- CREATE SCHEMA
SQL>CREATE SCHEMA INVENT;
--- SQL operation complete.
SQL>-- CREATE TABLES/VIEWS in SCHEMA INVENT
SQL>SET SCHEMA INVENT;
--- SQL operation complete.
SQL>CREATE TABLE INVENT.supplier (
+> suppnum NUMERIC (4) UNSIGNED
+> NO DEFAULT
+> NOT NULL
+> ,suppname CHARACTER (18)
+> NO DEFAULT
+> NOT NULL
+> ,street CHARACTER (22)
+> NO DEFAULT
+> NOT NULL
+> ,city CHARACTER (14)
+> NO DEFAULT
+> NOT NULL
+> ,state CHARACTER (12)
+> NO DEFAULT
+> NOT NULL
+> ,postcode CHARACTER (10)
+> NO DEFAULT
+> NOT NULL
+> ,PRIMARY KEY (suppnum)
+> );
--- SQL operation complete.
For more information about the @ and OBEY commands, see the “@ Command” (page 75) and
the “OBEY Command” (page 97).
Logging Output
To log output of an NCI session while running one script file at a time, use the SPOOL or LOG
command. When you run an OBEY or @ command, NCI displays each command in the script
file, the output for each command, and diagnostic messages in the Neoview Command Interface.
The SPOOL or LOG command captures this output as it appears in the Neoview Command
Interface and logs it in a log file.
For more information, see “Logging Output” (page 58).
Running Scripts in Parallel
In NCI, the @ and OBEY commands allow you to run only one script file at a time. However, the
PRUN command allows you to run multiple script files simultaneously. The PRUN command
is most useful for running sets of data definition language (DDL) statements simultaneously,
which speeds up the process of creating large databases. Put all dependent or related DDL
Logging Output 63