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

--- 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 88) and
the “OBEY Command” (page 109).
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 71).
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.
NOTE: The PRUN command can be run in non-interactive mode. The PRUN command allows
options to be specified on the command line, which enables PRUN to be run in script and/or
obey files.
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 statements in the same script file.
For more information on running scripts in parallel using the PRUN command, see the “PRUN
Command” (page 111).
Logging Output 77