IBM DB2 for i: Code example

Create older version of the IBM i sample database

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');

Contact IBM

Browse Power Systems

Next generation applications for big data and analytics and cognitive computing are providing unprecedented insights into opportunities, threats and efficiencies. IBM Power Systems is at the forefront of delivering solutions to gain faster insights from analyzing both structured information and unstructured big data. With the secure, flexible and open platform of IBM Power Systems plus solutions and software, organizations can outpace their competitors by delivering faster services, providing differentiated offerings and turning operational cost into investment opportunity.

To draw insights and make better decisions, businesses rely on the secure, flexible and open platform of IBM Power Systems. Built with the first processor designed for big data workloads, the design of Power Systems combines the computing power, memory bandwidth and I/O in ways that are easier to consume and manage, building on strong resiliency, availability and security.

IBM Power Systems deliver flexibility and choice of operating systems to enable your business to support the next generation applications for big data and analytics and cognitive computing that are transforming how organizations work today. Whether running 1, 2, or all 3 - coupled with PowerVM, they maximize the benefit of Power Systems in your business.

Transform your business with Systems Software that enables virtualization, high availability, flexibility, security and compliance on Power Systems™. IBM’s integrated approach to developing Systems and Systems Software together delivers optimized results with Power Systems.

IBM and IBM Business Partner solutions exploit key benefits in IBM Power Systems’ unique design combined with systems software to provide support for next generation applications for big data and analytics and cognitive computing to providing unprecedented insights into opportunities, threats and efficiencies to your organization.

Over the last five years thousands of clients have migrated to IBM Power Systems. Learn how Power Systems has helped them support next generation applications for big data and analytics and cognitive computing on an open platform for choice while improving business performance, reducing risk, and establishing a platform for growth.

Additional information