Notes

--Antonio John C. Pangilinan II
--Lab Quiz
--1.
drop table Emp;
drop table Dept;
drop view viewEmpSal;
drop synonym vSal;
--db2 dbm cfg;
--db2 update db cfg for sample using LOG52 512;

--A.
--a)

--b)

--B.
--1.
--a)
connect to sample;
--b)
CREATE TABLE Dept(Deptno Integer NOT NULL, Dname Varchar(30) NOT NULL, Loc Varchar(40));
CREATE TABLE Emp(Empno Integer NOT NULL, Ename Varchar(30), Job Varchar(15), Salary Decimal(8,2) NOT NULL);
--c)
describe Dept;
describe Emp;
--d)
insert into Dept (Deptno,Dname,Loc) values (1,'Marketing','Manila'),(2,'Sales','Quezon City'),(3,'HR','Makati');
insert into Emp (Empno,Ename,Job,Salary) values (100,'DELA CRUZ, JUAN','Manager', 20000.00),(101,'SANTOS, MARY','Secretary',12000.00),(102,'Yu,SAM','Programmer',18000.00);
--e)
select * from Dept;
select * from Emp;
--f)
create view viewEmpsal as select Empno, Salary from Emp;
--g)
create synonym vSal for viewEmpsal;
--h
select * from viewEmpSal;
select * from vSal;
--i)
drop table Emp;
drop table Dept;
drop view viewEmpSal;
drop synonym vSal;