scott.sql
-- generated by Jailer
--
-- extraction model:  EMPLOYEE where NAME='SCOTT' (extractionmodel/scott-without-subordinates.csv)
-- database URL:      jdbc:db2://localhost:50001/wisser
-- database user:     scott
-- exported entities: 9
--     DEPARTMENT                     2
--     EMPLOYEE                       4
--     SALARYGRADE                    3



Insert into DEPARTMENT(DEPTNO, NAME, LOCATION) values (20, 'RESEARCH', 'DALLAS'), (10, 'ACCOUNTING', 'NEW YORK');
Insert into SALARYGRADE(GRADE, LOSAL, HISAL) values (1, 700, 1200), (4, 2001, 3000), (5, 3001, 9999);
Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO) values (7839, 'KING', 'PRESIDENT', null, '1981-11-17', 5000.00, null, 10);
Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO) values (7566, 'JONES', 'MANAGER', 7839, '1981-04-02', 2975.00, null, 20);
Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO) values (7788, 'SCOTT', 'ANALYST', 7566, '1982-12-09', 3000.00, null, 20);
Insert into EMPLOYEE(EMPNO, NAME, JOB, BOSS, HIREDATE, SALARY, COMM, DEPTNO) values (7876, 'ADAMS', 'CLERK', 7788, '1983-01-12', 1100.00, null, 20);
scott.sql (END)