Le source de l'exemple fournis par IBM que vous pouvez adapter à votre environnement
c'est ce qu'il y a derrière
le CALL QSYS.CREATE_SQL_SAMPLE('SAMPLE') à partir de la version 5.1
--/*******************************************************************/
--/* */
--/* SCRIPT TO CREATE OLDER VERSION OF THE iSeries 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);
-- /**************************************************************/
-- /* &nbp; */
-- /* 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');
-- /**************************************************************/
-- /* */
-- /* POPULATE TABLE EMPLOYEE */
-- /* */
-- /**************************************************************/
INSERT INTO CORPDATA.EMPLOYEE
&nbs; VALUES(
'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', '', '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', &nbs; '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 */
-- /* &nbp; */
-- /**************************************************************/
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 VLUES(
'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',&nbs; 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');
&nbp; 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');
comme indiquer pour l'exécuter runsqlstm