scott.sql |
-- generated by Jailer at Tue Jun 05 10:50:03 CEST 2019
from wisser@u19 -- -- 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) |