Activity table (ACT)

 

The activity table describes each activity.

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

CREATE TABLE ACT 
             (ACTNO SMALLINT NOT NULL, 
              ACTKWD CHAR(6) NOT NULL, 
              ACTDESC VARCHAR(20) NOT NULL, 
              PRIMARY KEY (ACTNO))

The following indexes are created:

CREATE UNIQUE INDEX XACT1 
              ON ACT (ACTNO)


CREATE UNIQUE INDEX XACT2 
              ON ACT (ACTKWD)

The table below shows the contents of the columns.

Column name	Description
ACTNO	Activity number
ACTKWD	Keyword for activity
ACTDESC	Description of activity

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

 

Parent topic:

DB2 Universal Database for iSeries sample tables