INSERT INTO copy_employee_038 (EMPNO, FIRSTNME, LASTNAME, EDLEVEL, salary)
values (68093, 'Alisa', 'Aulia', 0, 1000);
values (11039, 'Bayu', 'Setiawan', 0, 2000);
values (11093, 'Willy', 'Wonka', 0, 500);
values (11033, 'Jessica', 'Alba', 0, 2500);
values (11099, 'Morgan', 'Kuffman', 0, 1200);






select * from act;

SELECT DEPTNO, DEPTNAME FROM DEPARTMENT WHERE DEPTNO = 'A00' OR DEPTNO = 'B01';

SELECT SALES_PERSON, REGION, SALES FROM SALES;
SELECT EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT FROM EMPLOYEE;

select * from staff;

INSERT INTO STAFF (id, name, job, dept, years, salary)
values (173, 'Andru','Mgr', 20, 20, 10000)


Select * from COPY_employee_038;
UPDATE STAFF
SET salary = 50000.00
WHERE ID = '123';


CREATE TABLE copy_employee_038 LIKE employee;



INSERT INTO copy_employee_038 (EMPNO, FIRSTNME, LASTNAME, EDLEVEL, salary)
values (68093, 'Alisa', 'Aulia', 0, 1000);
INSERT INTO copy_employee_038 (EMPNO, FIRSTNME, LASTNAME, EDLEVEL, salary)
values (11039, 'Bayu', 'Setiawan', 0, 2000);
INSERT INTO copy_employee_038 (EMPNO, FIRSTNME, LASTNAME, EDLEVEL, salary)
values (11093, 'Willy', 'Wonka', 0, 500);
INSERT INTO copy_employee_038 (EMPNO, FIRSTNME, LASTNAME, EDLEVEL, salary)
values (11033, 'Jessica', 'Alba', 0, 2500);
INSERT INTO copy_employee_038 (EMPNO, FIRSTNME, LASTNAME, EDLEVEL, salary)
values (11099, 'Morgan', 'Kuffman', 0, 1200);





--<ScriptOptions statementTerminator=";"/>

CREATE TABLE "DB2ADMIN"."COPY_EMPLOYEE_038" (
		"EMPNO" CHAR(6) NOT NULL,
		"FIRSTNME" VARCHAR(12) NOT NULL,
		"MIDINIT" CHAR(1),
		"LASTNAME" VARCHAR(15) NOT NULL,
		"WORKDEPT" CHAR(3),
		"PHONENO" CHAR(4),
		"HIREDATE" DATE,
		"JOB" CHAR(8),
		"EDLEVEL" SMALLINT NOT NULL,
		"SEX" CHAR(1),
		"BIRTHDATE" DATE,
		"SALARY" DECIMAL(9 , 2),
		"BONUS" DECIMAL(9 , 2),
		"COMM" DECIMAL(9 , 2)
	)
	DATA CAPTURE NONE
	IN "IBMDB2SAMPLEREL"
	COMPRESS NO;