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

SQL>CREATE TABLE COURSE
+>(
+> CNO VARCHAR(3) NOT NULL,
+> CNAME VARCHAR(22) NOT NULL,
+> CDESCP VARCHAR(25) NOT NULL,
+> CRED INT,
+> CLABFEE NUMERIC(5,2),
+> CDEPT VARCHAR(4) NOT NULL,
+> primary key (cno)
+>) ;
--- 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]:
OBEY Command 99