Starting with V5R1, a stored procedure is shipped as part of the system that contains the DDL statements to create all of the tables that are part of the DB2 for i sample database. In addition, this procedure also populates the table with sample data. The procedure will create the schema specified on the call to the procedure. The procedure can be invoked from any SQL interface as follows:
CALL QSYS.CREATE_SQL_SAMPLE('SAMPLE')
where SAMPLE is the name of the schema that you wish to create.
More detailed descriptions of the sample tables can be found in an appendix of the DB2 UDB for IBM i SQL Programming Concepts guide. Earlier versions of the IBM i & AS/400e SQL documentation included an older and smaller sample database. If you are interested in using this older version of the sample database, then you can use the following SQL script.
--/*******************************************************************/
--/* */
--/* SCRIPT TO CREATE OLDER VERSION OF THE IBM i SAMPLE DATABASE */
--/* */
--/* RUNSQLSTM member-name lib/source-file COMMIT(*NONE) NAMING(*SQL)*/
--/* */
--/*******************************************************************/
CREATE COLLECTION CORPDATA;
CREATE TABLE CORPDATA.CL_SCHED
(CLASS_CODE CHAR(7),
"DAY" SMALLINT,
STARTING TIME,
ENDING TIME);
CREATE TABLE CORPDATA.DEPARTMENT
(DEPTNO CHAR(3) NOT NULL,
DEPTNAME VARCHAR(29) NOT NULL,
MGRNO CHAR(6),
ADMRDEPT CHAR(3) NOT NULL);
CREATE TABLE CORPDATA.EMPLOYEE
(EMPNO CHAR(6) NOT NULL,
FIRSTNME VARCHAR(12) NOT NULL,
MIDINIT CHAR(1) NOT NULL,
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));
CREATE TABLE CORPDATA.IN_TRAY
(RECEIVED TIMESTAMP,
SOURCE CHAR(8),
SUBJECT CHAR(64),
NOTE_TEXT VARCHAR(3000));
CREATE TABLE CORPDATA.PROJECT
(PROJNO CHAR(6) NOT NULL,
PROJNAME VARCHAR(24) NOT NULL,
DEPTNO CHAR(3) NOT NULL,
RESPEMP CHAR(6) NOT NULL,
PRSTAFF DECIMAL(5,2),
PRSTDATE DATE,
PRENDATE DATE,
MAJPROJ CHAR(6));
CREATE TABLE CORPDATA.EMP_ACT
(EMPNO CHAR(6) NOT NULL,
PROJNO CHAR(6) NOT NULL,
ACTNO SMALLINT NOT NULL,
EMPTIME DEC(5,2),
EMSTDATE DATE,
EMENDATE DATE);
-- /**************************************************************/
-- /* */
-- /* POPULATE TABLE DEPARTMENT */
-- /* */
-- /**************************************************************/
INSERT INTO CORPDATA.DEPARTMENT VALUES(
'A00' ,'SPIFFY COMPUTER SERVICE DIV.' , '000010', 'A00');
INSERT INTO CORPDATA.DEPARTMENT VALUES(
'B01', 'PLANNING', '000020', 'A00');
INSERT INTO CORPDATA.DEPARTMENT VALUES(
'C01', 'INFORMATION CENTER', '000030', 'A00');
INSERT INTO CORPDATA.DEPARTMENT VALUES(
'D01', 'DEVELOPMENT CENTER', NULL, 'A00');
INSERT INTO CORPDATA.DEPARTMENT VALUES(
'D11', 'MANUFACTURING SYSTEMS', '000060', 'D01');
INSERT INTO CORPDATA.DEPARTMENT VALUES(
'D21', 'ADMINISTRATION SYSTEMS', '000070', 'D01');
INSERT INTO CORPDATA.DEPARTMENT VALUES(
'E01', 'SUPPORT SERVICES', '000050', 'A00');
INSERT INTO CORPDATA.DEPARTMENT VALUES(
'E11', 'OPERATIONS', '000090', 'E01');
INSERT INTO CORPDATA.DEPARTMENT VALUES(
'E21', 'SOFTWARE SUPPORT', '000100', 'E01');
INSERT INTO CORPDATA.EMPLOYEE
VALUES(
-- /**************************************************************/
-- /* */
-- /* POPULATE TABLE EMPLOYEE */
-- /* */
-- /**************************************************************/
'000010','CHRISTINE', 'I', 'HAAS', 'A00', '3978',
'1965-01-01','PRES' , 18 , 'F', '1933-08-24', 52750.00,
1000,4220);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000020','MICHAEL', 'L', 'THOMPSON', 'B01', '3476',
'1973-10-10','MANAGER', 18 , 'M', '1948-02-02', 41250.00,
800,3300);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000030','SALLY', 'A', 'KWAN', 'C01', '4738',
'1975-04-05', 'MANAGER', 20, 'F', '1941-05-11', 38250.00,
800,3060);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000050','JOHN', 'B', 'GEYER', 'E01', '6789',
'1949-08-17','MANAGER', 16, 'M', '1925-09-15', 40175.00,
800,3214);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000060','IRVING', 'F', 'STERN', 'D11', '6423',
'1973-09-14','MANAGER', 16, 'M', '1945-07-07', 32250.00,
500,2580);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000070','EVA', 'D', 'PULASKI', 'D21', '7831',
'1980-09-30','MANAGER', 16, 'F', '1953-05-26', 36170.00,
700,2893);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000090','EILEEN', 'W', 'HENDERSON', 'E11', '5498',
'1970-08-15','MANAGER', 16, 'F', '1941-05-15', 29750.00,
600,2380);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000100','THEODORE', 'Q', 'SPENSER', 'E21', '0972',
'1980-06-19','MANAGER', 14 , 'M', '1956-12-18', 26150.00,
500,2092);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000110','VICENZO', 'G', 'LUCCHESSI', 'A00', '3490',
'1958-05-16','SALESREP', 19, 'M', '1929-11-05', 46500.00,
900,3720);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000120','SEAN', ' ', 'O''CONNELL', 'A00', '2167',
'1963-12-05','CLERK', 14, 'M', '1942-10-18', 29250.00,
600,2340);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000130','DELORES', 'M', 'QUINTANA', 'C01', '4578',
'1971-07-28','ANALYST', 16, 'F', '1925-09-15', 23800.00,
500,1904);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000140','HEATHER', 'A', 'NICHOLLS', 'C01', '1793',
'1976-12-15','ANALYST', 18, 'F', '1946-01-19', 28420.00,
600,2274);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000150','BRUCE', ' ', 'ADAMSON', 'D11', '4510',
'1972-02-12','DESIGNER', 16, 'M', '1947-05-17', 25280.00,
500,2022);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000160','ELIZABETH', 'R', 'PIANKA', 'D11', '3782',
'1977-10-11','DESIGNER', 17, 'F', '1955-04-12', 22250.00,
400,1780);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000170','MASATOSHI', 'J', 'YOSHIMURA', 'D11', '2890',
'1978-09-15','DESIGNER', 16, 'M', '1951-01-05', 24680.00,
500,1974);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000180','MARILYN', 'S', 'SCOUTTEN', 'D11', '1682',
'1973-07-07','DESIGNER', 17, 'F', '1949-02-21', 21340.00,
500,1707);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000190','JAMES', 'H', 'WALKER', 'D11', '2986',
'1974-07-26','DESIGNER', 16, 'M', '1952-06-25', 20450.00,
400,1636);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000200','DAVID', ' ', 'BROWN', 'D11', '4501',
'1966-03-03','DESIGNER', 16, 'M', '1941-05-29', 27740.00,
600,2217);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000210','WILLIAM', 'T', 'JONES', 'D11', '0942',
'1979-04-11','DESIGNER', 17, 'M', '1953-02-23', 18270.00,
400,1462);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000220','JENNIFER', 'K', 'LUTZ', 'D11', '0672',
'1968-08-29','DESIGNER', 18, 'F', '1948-03-19', 29840.00,
600,2387);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000230','JAMES', 'J', 'JEFFERSON', 'D21', '2094',
'1966-11-21','CLERK', 14, 'M', '1935-05-30', 22180.00,
400,1774);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000240', 'SALVATORE', 'M', 'MARINO', 'D21', '3780',
'1979-12-05','CLERK', 17, 'M', '1954-03-31', 28760.00,
600,2301);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000250', 'DANIEL', 'S', 'SMITH', 'D21', '0961',
'1969-10-30','CLERK', 15, 'M', '1939-11-12', 19180.00,
400,1534);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000260', 'SYBIL', 'P', 'JOHNSON', 'D21', '8953',
'1975-09-11','CLERK', 16, 'F', '1936-10-05', 17250.00,
300,1380);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000270', 'MARIA', 'L', 'PEREZ', 'D21', '9001',
'1980-09-30','CLERK', 15, 'F', '1953-05-26', 27380.00,
500,2190);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000280', 'ETHEL', 'R', 'SCHNEIDER', 'E11', '8997',
'1967-03-24','OPERATOR', 17, 'F', '1936-03-28', 26250.00,
500,2100);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000290', 'JOHN', 'R', 'PARKER', 'E11', '4502',
'1980-05-30','OPERATOR', 12, 'M', '1946-07-09', 15340.00,
300,1227);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000300', 'PHILIP', 'X', 'SMITH', 'E11', '2095',
'1972-06-19','OPERATOR', 14, 'M', '1936-10-27', 17750.00,
400,1420);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000310', 'MAUDE', 'F', 'SETRIGHT', 'E11', '3332',
'1964-09-12','OPERATOR', 12, 'F', '1931-04-21', 15900.00,
300,1272);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000320', 'RAMLAL', 'V', 'MEHTA', 'E21', '9990',
'1965-07-07','FILEREP', 16, 'M', '1932-08-11', 19950.00,
400,1596);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000330', 'WING', ' ', 'LEE', 'E21', '2103',
'1976-02-23','FILEREP', 14, 'M', '1941-07-18', 25370.00,
500,2030);
INSERT INTO CORPDATA.EMPLOYEE VALUES(
'000340', 'JASON', 'R', 'GOUNOT', 'E21', '5698',
'1947-05-05','FILEREP', 16, 'M', '1926-05-17', 23840.00,
500,1907);
-- /**************************************************************/
-- /* */
-- /* POPULATE TABLE PROJECT */
-- /* */
-- /**************************************************************/
INSERT INTO CORPDATA.PROJECT VALUES(
'AD3100', 'ADMIN SERVICES', 'D01', '000010',
6.50, '1982-01-01', '1983-02-01',NULL);
INSERT INTO CORPDATA.PROJECT VALUES(
'AD3110', 'GENERAL ADMIN SYSTEMS', 'D21', '000070',
6.00, '1982-01-01', '1983-02-01','AD3100');
INSERT INTO CORPDATA.PROJECT VALUES(
'AD3111', 'PAYROLL PROGRAMMING', 'D21', '000230',
2.00, '1982-01-01', '1983-02-01','AD3110');
INSERT INTO CORPDATA.PROJECT VALUES(
'AD3112', 'PERSONNEL PROGRAMMING', 'D21', '000250',
1.00, '1982-01-01', '1983-02-01','AD3110');
INSERT INTO CORPDATA.PROJECT VALUES(
'AD3113', 'ACCOUNT PROGRAMMING', 'D21', '000270',
2.00, '1982-01-01', '1983-02-01','AD3110');
INSERT INTO CORPDATA.PROJECT VALUES(
'IF1000', 'QUERY SERVICES', 'C01', '000030',
2.00, '1982-01-01', '1983-02-01',NULL);
INSERT INTO CORPDATA.PROJECT VALUES(
'IF2000', 'USER EDUCATION', 'C01', '000030',
1.00, '1982-01-01', '1983-02-01',NULL );
INSERT INTO CORPDATA.PROJECT VALUES(
'MA2100', 'WELD LINE AUTOMATION', 'D01', '000010',
12.00, '1982-01-01', '1983-02-01',NULL );
INSERT INTO CORPDATA.PROJECT VALUES(
'MA2110', 'W L PROGRAMMING', 'D11', '000060',
9.00, '1982-01-01', '1983-02-01','MA2100');
INSERT INTO CORPDATA.PROJECT VALUES(
'MA2111', 'W L PROGRAM DESIGN', 'D11', '000220',
2.00, '1982-01-01', '1982-12-01','MA2110');
INSERT INTO CORPDATA.PROJECT VALUES(
'MA2112', 'W L ROBOT DESIGN', 'D11', '000150',
3.00, '1982-01-01', '1982-12-01','MA2110');
INSERT INTO CORPDATA.PROJECT VALUES(
'MA2113', 'W L PROD CONT PROGS', 'D11', '000160',
3.00, '1982-02-15', '1982-12-01','MA2110');
INSERT INTO CORPDATA.PROJECT VALUES(
'OP1000', 'OPERATION SUPPORT', 'E01', '000050',
6.00, '1982-01-01', '1983-02-01',NULL );
INSERT INTO CORPDATA.PROJECT VALUES(
'OP1010', 'OPERATION', 'E11', '000090',
5.00, '1982-01-01', '1983-02-01','OP1000');
INSERT INTO CORPDATA.PROJECT VALUES(
'OP2000', 'GEN SYSTEMS SERVICES', 'E01', '000050',
5.00, '1982-01-01', '1983-02-01',NULL );
INSERT INTO CORPDATA.PROJECT VALUES(
'OP2010', 'SYSTEMS SUPPORT', 'E21', '000100',
4.00, '1982-01-01', '1983-02-01','OP2000');
INSERT INTO CORPDATA.PROJECT VALUES(
'OP2011', 'SCP SYSTEMS SUPPORT', 'E21', '000320',
1.00, '1982-01-01', '1983-02-01','OP2010');
INSERT INTO CORPDATA.PROJECT VALUES(
'OP2012', 'APPLICATIONS SUPPORT', 'E21', '000330',
1.00, '1982-01-01', '1983-02-01','OP2010');
INSERT INTO CORPDATA.PROJECT VALUES(
'OP2013', 'DB/DC SUPPORT', 'E21', '000340',
1.00, '1982-01-01', '1983-02-01','OP2010');
INSERT INTO CORPDATA.PROJECT VALUES(
'PL2100', 'WELD LINE PLANNING', 'B01', '000020',
1.00, '1982-01-01', '1982-09-15','MA2100');
-- /**************************************************************/
-- /* */
-- /* POPULATE TABLE EMP_ACT */
-- /* */
-- /**************************************************************/
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000010', 'AD3100', 10, 0.5,'1982-01-01', '1982-07-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000070', 'AD3110', 10, 1.0,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000230', 'AD3111', 60, 1.0,'1982-01-01', '1982-03-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000230', 'AD3111', 60, 0.5,'1982-03-15', '1982-04-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000230', 'AD3111', 70, 0.5,'1982-03-15', '1982-10-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000230', 'AD3111', 80, 0.5,'1982-04-15', '1982-10-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000230', 'AD3111', 180, 0.5,'1982-10-15', '1983-01-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000240', 'AD3111', 70, 1.0,'1982-02-15', '1982-09-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000240', 'AD3111', 80, 1.0,'1982-09-15', '1983-01-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000250', 'AD3112', 60, 1.0,'1982-01-01', '1982-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000250', 'AD3112', 60, 0.5,'1982-02-01', '1982-03-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000250', 'AD3112', 60, 1.0,'1983-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000250', 'AD3112', 70, 0.5,'1982-02-01', '1982-03-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000250', 'AD3112', 70, 1.0,'1982-03-15', '1982-08-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000250', 'AD3112', 70,0.25,'1982-08-15', '1982-10-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000250', 'AD3112', 80,0.25,'1982-08-15', '1982-10-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000250', 'AD3112', 80,0.50,'1982-10-15', '1982-12-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000250', 'AD3112', 180,0.50,'1982-08-15', '1983-01-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000260', 'AD3113', 70,0.50,'1982-06-15', '1982-07-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000260', 'AD3113', 70,1.00,'1982-07-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000260', 'AD3113', 80,1.00,'1982-01-01', '1982-03-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000260', 'AD3113', 80,0.50,'1982-03-01', '1982-04-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000260', 'AD3113', 180,0.50,'1982-03-01', '1982-04-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000260', 'AD3113', 180,1.00,'1982-04-15', '1982-06-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000260', 'AD3113', 180,1.00,'1982-06-01', '1982-07-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000270', 'AD3113', 60,0.50,'1982-03-01', '1982-04-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000270', 'AD3113', 60,1.00,'1982-04-01', '1982-09-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000270', 'AD3113', 60,0.25,'1982-09-01', '1982-10-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000270', 'AD3113', 70,0.75,'1982-09-01', '1982-10-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000270', 'AD3113', 70,1.00,'1982-10-15', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000270', 'AD3113', 80,1.00,'1982-01-01', '1982-03-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000270', 'AD3113', 80,0.50,'1982-03-01', '1982-04-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000030', 'IF1000', 10,0.50,'1982-06-01', '1983-01-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000130', 'IF1000', 90,1.00,'1982-01-01', '1982-10-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000130', 'IF1000', 100,0.50,'1982-10-01', '1983-01-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000140', 'IF1000', 90,0.50,'1982-10-01', '1983-01-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000030', 'IF2000', 10,0.50,'1982-01-01', '1983-01-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000140', 'IF2000', 100,1.00,'1982-01-01', '1982-03-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000140', 'IF2000', 100,0.50,'1982-03-01', '1982-07-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000140', 'IF2000', 110,0.50,'1982-03-01', '1982-07-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000140', 'IF2000', 110,0.50,'1982-10-01', '1983-01-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000010', 'MA2100', 10,0.50,'1982-01-01', '1982-11-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000110', 'MA2100', 20,1.00,'1982-01-01', '1983-03-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000010', 'MA2110', 10,1.00,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000200', 'MA2111', 50,1.00,'1982-01-01', '1982-06-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000200', 'MA2111', 60,1.00,'1982-06-15', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000220', 'MA2111', 40,1.00,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000150', 'MA2112', 60,1.00,'1982-01-01', '1982-07-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000150', 'MA2112', 180,1.00,'1982-07-15', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000170', 'MA2112', 60,1.00,'1982-01-01', '1983-06-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000170', 'MA2112', 70,1.00,'1982-06-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000190', 'MA2112', 70,1.00,'1982-01-01', '1982-10-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000190', 'MA2112', 80,1.00,'1982-10-01', '1983-10-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000160', 'MA2113', 60,1.00,'1982-07-15', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000170', 'MA2113', 80,1.00,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000180', 'MA2113', 70,1.00,'1982-04-01', '1982-06-15');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000210', 'MA2113', 80,0.50,'1982-10-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000210', 'MA2113', 180,0.50,'1982-10-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000050', 'OP1000', 10,0.25,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000090', 'OP1010', 10,1.00,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000280', 'OP1010', 130,1.00,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000290', 'OP1010', 130,1.00,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000300', 'OP1010', 130,1.00,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000310', 'OP1010', 130,1.00,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000050', 'OP2010', 10,0.75,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000100', 'OP2010', 10,1.00,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000320', 'OP2011', 140,0.75,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000320', 'OP2011', 150,0.25,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000330', 'OP2012', 140,0.25,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000330', 'OP2012', 160,0.75,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000340', 'OP2013', 140,0.50,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000340', 'OP2013', 170,0.50,'1982-01-01', '1983-02-01');
INSERT INTO CORPDATA.EMP_ACT VALUES(
'000020', 'PL2100', 30,1.00,'1982-01-01', '1982-09-15');