[USflag] The American Programmer [USflag]


Home
Books on Mainframe Programming
Mainframe Manuals and Tutorials
System Abend codes, Sqlcodes, VSAM/QSAM codes
Everything about the IBM AS/400 Midrange Computer
Everything about CICS
Everything about COBOL
Everything about DB2 and SQL
  DB2/SQL Singleton Select embedded in a COBOL program
  DB2/SQL Add Change Delete program
  DB2/SQL program to read table with cursor
  DB2/SQL load table program
  DB2/SQL program to read a table randomly
  DB2/SQL bare bones skeleton program
  DB2/SQL program to insert a row into a table
  DB2/SQL program to update a row
  DB2/SQL program for handling variable length column
  DB2/SQL program for handling column with null indicator
  Embedded SQL. Short tutorial.
  Examples of DCLGEN. Short tutorial.
  Examples of SQL Joins. Short tutorial.
  Examples of DB2 View. Short tutorial.
  Just Enough SQL/QMF/SPUFI To Be Dangerous
  Sample tables STAFF, ORG, EMP and DEPT
  QMF Procedures Written in REXX
  Using REXX Subroutines with the QMF Calc panel
  Using QMF to Execute Your SQL
  QMF Cheat Sheet. Edit codes. QMF Commands, Text Variables, Usage Codes
  Executing SQL in a batch job
  Using Spufi to Execute Your SQL
  Books on DB2 and SQL
  DB2 and SQL, Structured Query Language manuals
  SQLCODES and Their Causes
Everything about IMS
Everything about Java and JavaScript
Everything about JCL and JES
Everything about REXX
Everything about zOS, VSAM, Tivoli, Assembler
Everything about TSO, ISPF, Spufi
Site Map and Site Search

           Home   > DB2   > Sample Workshop Tables ORG STAFF EMP DEPT

Sample DB2/SQL Workshop Tables ORG STAFF EMP DEPT

The STAFF Table

ID NAME DEPT JOB YEARS SALARY COMM 10 SANDERS 20 MGR 7 18357.50 --------- 20 PERNAL 20 SALES 8 18171.25 612.45 30 MARENGHI 38 MGR 5 17506.75 --------- 40 O'BRIEN 38 SALES 6 18006.00 846.55 50 HANES 15 MGR 10 20659.80 --------- 60 QUIGLEY 38 SALES ------ 16808.30 650.25 70 ROTHMAN 15 SALES 7 16502.83 1152.00 80 JAMES 20 CLERK ------ 13504.60 128.20 90 KOONITZ 42 SALES 6 18001.75 1386.70 100 PLOTZ 42 MGR 7 18352.80 --------- 110 NGAN 15 CLERK 5 12508.20 206.60 120 NAUGHTON 38 CLERK ------ 12954.75 180.00 130 YAMAGUCHI 42 CLERK 6 10505.90 75.60 140 FRAYE 51 MGR 6 21150.00 --------- 150 WILLIAMS 51 SALES 6 19456.50 637.65 160 MOLINARE 10 MGR 7 22959.20 --------- 170 KERMISCH 15 CLERK 4 12258.50 110.10 180 ABRAHAMS 38 CLERK 3 12009.75 236.50 190 SNEIDER 20 CLERK 8 14252.75 126.50 200 SCOUTTEN 42 CLERK ------ 11508.60 84.20 210 LU 10 MGR 10 20010.00 --------- 220 SMITH 51 SALES 7 17654.50 992.80 230 LUNDQUIST 51 CLERK 3 13369.80 189.65 240 DANIELS 10 MGR 5 19260.25 --------- 250 WHEELER 51 CLERK 6 14460.00 513.30 260 JONES 10 MGR 12 21234.00 --------- 270 LEA 66 MGR 9 18555.50 --------- 280 WILSON 66 SALES 9 18674.50 811.50 290 QUILL 84 MGR 10 19818.00 --------- 300 DAVIS 84 SALES 5 15454.50 806.10 310 GRAHAM 66 SALES 13 21000.00 200.30 320 GONZALES 66 SALES 4 16858.20 844.00 330 BURKE 66 CLERK 1 10988.00 55.50 340 EDWARDS 84 SALES 7 17844.00 1285.00 350 GAFNEY 84 CLERK 5 13030.50 188.00

The ORG Table

DEPTNUMB DEPTNAME MANAGER DIVISION LOCATION 10 HEAD OFFICE 160 CORPORATE NEW YORK 15 NEW ENGLAND 50 EASTERN BOSTON 20 MID ATLANTIC 10 EASTERN WASHINGTON 38 SOUTH ATLANTIC 30 EASTERN ATLANTA 42 GREAT LAKES 100 MIDWEST CHICAGO 51 PLAINS 140 MIDWEST DALLAS 66 PACIFIC 270 WESTERN SAN FRANCISCO 84 MOUNTAIN 290 WESTERN DENVER

The EMP Table

EMPNO FIRSTNME MID LASTNAME WORK PHONE HIREDATE JOB ED BIRTHDATE SALARY BONUS COMM INIT DEPT NO LVEL SEX 000010 CHRISTINE I HAAS A00 3978 1965-01-01 PRES 18 F 1933-08-14 52750.00 1000.00 4220.00 000020 MICHAEL L THOMPSON B01 3476 1973-10-10 MANAGER 18 M 1948-02-02 41250.00 800.00 3300.00 000030 SALLY A KWAN C01 4738 1975-04-05 MANAGER 20 F 1941-05-11 38250.00 800.00 3060.00 000050 JOHN B GEYER E01 6789 1949-08-17 MANAGER 16 M 1925-09-15 40175.00 800.00 3214.00 000060 IRVING F STERN D11 6423 1973-09-14 MANAGER 16 M 1945-07-07 32250.00 600.00 2580.00 000070 EVA D PULASKI D21 7831 1980-09-30 MANAGER 16 F 1953-05-26 36170.00 700.00 2893.00 000090 EILEEN W HENDERSON E11 5498 1970-08-15 MANAGER 16 F 1941-05-15 29750.00 600.00 2380.00 000100 THEODORE Q SPENSER E21 0972 1980-06-19 MANAGER 14 M 1956-12-18 26150.00 500.00 2092.00 000110 VINCENZO G LUCCHESI A00 3490 1958-05-16 SALESREP 19 M 1929-11-05 46500.00 900.00 3720.00 000120 SEAN O'CONNELL A00 2167 1963-12-05 CLERK 14 M 1942-10-18 29250.00 600.00 2340.00 000130 DOLORES M QUINTANA C01 4578 1971-07-28 ANALYST 16 F 1925-09-15 23800.00 500.00 1904.00 000140 HEATHER A NICHOLLS C01 1793 1976-12-15 ANALYST 18 F 1946-01-19 28420.00 600.00 2274.00 000150 BRUCE ADAMSON D11 4510 1972-02-12 DESIGNER 16 M 1947-05-17 25280.00 500.00 2022.00 000160 ELIZABETH R PIANKA D11 3782 1977-10-11 DESIGNER 17 F 1955-04-12 22250.00 400.00 1780.00 000170 MASATOSHI J YOSHIMURA D11 2890 1978-09-15 DESIGNER 16 M 1951-01-05 24680.00 500.00 1974.00 000180 MARILYN S SCOUTTEN D11 1682 1973-07-07 DESIGNER 17 F 1949-02-21 21340.00 500.00 1707.00 000190 JAMES H WALKER D11 2986 1974-07-26 DESIGNER 16 M 1952-06-25 20450.00 400.00 1636.00 000200 DAVID BROWN D11 4501 1966-03-03 DESIGNER 16 M 1941-05-29 27740.00 600.00 2217.00 000210 WILLIAM T JONES D11 0942 1979-04-11 DESIGNER 17 M 1953-02-23 18270.00 400.00 1462.00 000220 JENNIFER K LUTZ D11 0672 1968-08-29 DESIGNER 18 F 1948-03-19 29840.00 600.00 2387.00 000230 JAMES J JEFFERSON D21 4265 1966-11-21 CLERK 14 M 1935-05-30 22180.00 400.00 1774.00 000240 SALVATORE M MARINO D21 3780 1979-12-05 CLERK 17 M 1954-03-31 28760.00 600.00 2301.00 000250 DANIEL S SMITH D21 0961 1969-10-30 CLERK 15 M 1939-11-12 19180.00 400.00 1534.00 000260 SYBIL V JOHNSON D21 8953 1975-09-11 CLERK 16 F 1936-10-05 17250.00 300.00 1380.00 000270 MARIA L PEREZ D21 9001 1980-09-30 CLERK 15 F 1953-05-26 27380.00 500.00 2190.00 000280 ETHEL R SCHNEIDER E11 8997 1967-03-24 OPERATOR 17 F 1936-03-28 26250.00 500.00 2100.00 000290 JOHN R PARKER E11 4502 1980-05-30 OPERATOR 12 M 1946-07-09 15340.00 300.00 1227.00 000300 PHILIP X SMITH E11 2095 1972-06-19 OPERATOR 14 M 1936-10-27 17750.00 400.00 1420.00 000310 MAUDE F SETRIGHT E11 3332 1964-09-12 OPERATOR 12 F 1931-04-21 15900.00 300.00 1272.00 000320 RAMLAL V MEHTA E21 9990 1965-07-07 FIELDREP 16 M 1932-08-11 19950.00 400.00 1596.00 000330 WING LEE E21 2103 1976-02-23 FIELDREP 14 M 1941-07-18 25370.00 500.00 2030.00 000340 JASON R GOUNOT E21 5698 1947-05-05 FIELDREP 16 M 1926-05-17 23840.00 500.00 1907.00

The DEPT Table

DEPTNO DEPTNAME MGRNO ADMRDEPT A00 SPIFFY COMPUTER SERVICE DIV. 000010 A00 B01 PLANNING 000020 A00 C01 INFORMATION CENTER 000030 A00 D01 DEVELOPMENT CENTER ------ A00 D11 MANUFACTURING SYSTEMS 000060 D01 D21 ADMINISTRATION SYSTEMS 000070 D01 E01 TECHNICAL SUPPORT 000050 A00 E11 OPERATIONS 000090 E01 E21 SOFTWARE SUPPORT 000100 E01 The "-----" shown above in the MGRNO column indicate that this row contained nulls instead of a data value.

Top of Page




























List of books on DB2 and other mainframe topics