home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
visdb2tk.zip
/
DEMODB.SQL
< prev
next >
Wrap
Text File
|
1995-10-02
|
928b
|
17 lines
drop database demo
connect reset
-- ** Comment out the following line if you wish to specify a path for the database
create database demo
-- ** Include one of the lines below to specify a drive for the database. Amend as neccessary. (Ist line for DB2/2, second for DB2/6000)
-- create database demo on c
-- create database demo on /home/db2
connect to demo
import from dept.ixf of ixf modified by forcein create into department
import from emp.ixf of ixf modified by forcein create into employee
alter table department primary key (deptno)
-- ** Amend the 3 lines that follow to change the location of your tablespace. You must change these for DB2/6000.
create tablespace regular managed by database using (file 'c:\demoreg' 500)
create long tablespace longspace managed by database using (file 'c:\demolong' 500)
create tablespace indexspace managed by database using (file 'c:\demoind' 500)
connect reset