# Shell script to create and load the emps table for a user into a
# DB2 UDB database running on a UNIX system, for Example 3.11.6.
# Note that db2 needs at least "x" permission to the current directory 
# and its higher directories for the loads.
# Usage: loademps <database-name>

db2 << MARK
connect to $1

--create table for Example 3.11.6
--first drop old, if any
drop table employees
create table employees (eid char(5) not null, ename varchar(15), mgrid char(5), primary key (eid))
load from emps.dat of del insert into employees
MARK