Universal Database (netDB2) Introductory Guide
Using the Script Feature
Scripting
The scripting option allows the user to type a series of SQL commands and
then execute the set of commands at one go. These commands can either be
copied from a file or typed onto the Script Center Window. Visiting the script
center can use this option. At the Script center one types in the commands
at the Script center panel and run the commands by hitting the Run button.
The results are available at the adjoining window.
Commands
INSERT INTO test VALUES( 21, 'ellen' );
INSERT INTO test VALUES( 22, 'debra' );
INSERT INTO test VALUES( 10, 'debra');
INSERT INTO test VALUES( 20, 'albert');
select * from test;
select * from test where i > 20;
select count (*) from test ;
select count (distinct s) from test
|
NetUDB responses
INSERT INTO test VALUES( 21, 'ellen' ) DB20000I The SQL command completed successfully
select * from test
21 ellen
22 debra
10 debra
20 albert
select * from test where i >20
21 ellen
22 debra
select count (*) from test
6
select count (distinct s) from test
5
|
Note :
1) Currently each SQL query must begin at a new line.
2) Save your script in a local file and paste into the script window. This will allow you to have a record
of your work. You will probably need to save your script into files to submit them as part of your assignments at any cost.
|