MX Release 3.1 (H06.23+, J06.12+)

purgedata course;

To run only the commands in section create, run the command :

SQL>obey /usr/home/course.sql (create)

SQL>?section create

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, run the command :

SQL>obey /usr/home/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.

The following command runs all files with .sql extension:

SQL>obey /usr/home/rmxci/*.sql;

SQL> obey /usr/home/rmxci

The following command runs all files beginning with the word script and contains one

character after the word script and ends with .sql extension. For example:

script1.sql,script2.sql,scriptZ.sql and so on:

SQL>obey /usr/home/rmxci/script?.sql

The following command runs all files that contain the word test. This includes the files that

do not end with .sql extension.

SQL>obey /usr/home/rmxci/*test*

This command runs all files that begin with the word script and contains one character after

the word script and ends with an extension prefixed by a dot. For example: script1.sql,

script2.bat, scriptZ.txt and so on.

SQL>obey /usr/home/rmxci/script?.*

The following command runs all files that have .txt extension in the current directory:

SQL>obey *.txt;

76 RMXCI commands