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

--- SQL Operation complete.
To run only the commands in the insert section, execute the following :
SQL>obey C:\Command Interfaces\course.sql (insert)
SQL>?section insert
SQL>INSERT INTO COURSE VALUES
+> ('C11', 'INTRO TO CS','FOR ROOKIES',3, 100, 'CIS');
--- 1 row(s) inserted.
SQL>INSERT INTO COURSE VALUES
+> ('C22', 'DATA STRUCTURES','VERY USEFUL',3, 50, 'CIS');
--- 1 row(s) inserted.
SQL>INSERT INTO COURSE VALUES
+> ('C33', 'DISCRETE MATHEMATICS',
'ABSOLUTELY NECESSARY',3, 0, 'CIS');
--- 1 row(s) inserted.
This command executes all files with .sql extension:
SQL> OBEY c:\nci\*.sql;
SQL> OBEY c:\nci
This command executes all files beginning with the word “script” and contains one character
after the word script and ends with .sql extenstion. For example:
script1.sql,script2.sql,scriptZ.sqland so on:
SQL> OBEY C:\nci\script?.sql
This command executes all files that contain the word “test”. This includes the files that do
not end with .sql extension
SQL> OBEY C:\nci\*test*
This command executes all files that begin with the word “script” and contains one character
after the word “script” and ends with an extenstion prefixed by a dot. For example:
script1.sql, script2.bat, scriptZ.txtand so on.
SQL> OBEY C:\nci\script?.*
This command executes all files that have .txt extension in the current directory, the directory
in which the command interface was launched.
SQL> OBEY *.txt;
This command prompts the user to enter the script filename or a pattern. The default value
*.sql
SQL> OBEY;
Enter the script filename [*.sql]:
PRUN Command
The PRUN command runs script files in parallel.
Syntax
PRUN [-d | -defaults] | PRUN [-sd | -scriptsdir directoryName]
[-e | -extension extension]
[-ld | -logsdir logDirectory]
[-o | -overwrite {y | n}]
[-c | -connections num]
PRUN Command 111