Filter
Top Products
+> 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:\Scripts\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.
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]
scriptsdir
In this directory, PRUN processes every file with the specified extension. If
you do not specify a directory or if you specify an invalid directory, an error
message occurs and you are prompted to reenter the directory. Note: Verify
that this directory contains valid script files.
extension The default is .sql.
logsdir
In this directory, PRUN creates a log file for each script file by appending the
.log extension to the name of the script file. If you do not specify a log file
directory, PRUN places the log files in the same directory as the script files.
Note: PRUN puts the prun.err.log summary file in the error subdirectory.
overwrite
If you specify (y), PRUN overwrites the contents of existing log files. By default,
PRUN keep the original information in the log files and appends new
information at the end of each file.
connections
Enter a number for the maximum number of connections for the data sources.
The data source should support this number of connections.
PRUN Command 95