Staff table (STAFF)

 

The staff table describes the background information about employees.

The staff table is created with the following CREATE TABLE statement:

CREATE TABLE STAFF 
             (ID  SMALLINT NOT NULL, 
              NAME VARCHAR(9), 
              DEPT SMALLINT, 
              JOB CHAR(5), 
              YEARS SMALLINT, 
              SALARY DECIMAL(7,2), 
              COMM DECIMAL(7,2))

The table below shows the contents of the columns.

Column name	Description
ID	Employee number
NAME	Employee name
DEPT	Department number
JOB	Job title
YEARS	Years with the company
SALARY	Employee's annual salary
COMM	Employee's commission

• STAFF
  Here is a complete listing of the data in the STAFF table.

 

Parent topic:

DB2 Universal Database for iSeries sample tables