|
EMPNO |
CHARACTER |
6 |
0 |
1251 |
|
|
|
|
|
FIRSTNME |
VARCHAR |
12 |
0 |
1251 |
|
|
|
|
|
MIDINIT |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
LASTNAME |
VARCHAR |
15 |
0 |
1251 |
|
|
|
|
|
WORKDEPT |
CHARACTER |
3 |
0 |
1251 |
|
|
|
|
|
PHONENO |
CHARACTER |
4 |
0 |
1251 |
|
|
|
|
|
HIREDATE |
DATE |
4 |
0 |
0 |
|
|
|
|
|
JOB |
CHARACTER |
8 |
0 |
1251 |
|
|
|
|
|
EDLEVEL |
SMALLINT |
2 |
0 |
0 |
|
|
|
|
|
SEX |
CHARACTER |
1 |
0 |
1251 |
|
|
|
|
|
BIRTHDATE |
DATE |
4 |
0 |
0 |
|
|
|
|
|
SALARY |
DECIMAL |
9 |
2 |
0 |
|
|
|
|
|
BONUS |
DECIMAL |
9 |
2 |
0 |
|
|
|
|
|
COMM |
DECIMAL |
9 |
2 |
0 |
|
|
|
|
Total: 14 column(s)
Total: 1 index(s)
Total: 2 referencing table(s)
|
SYSIBM |
USER |
CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE |
Total: 1 autherisation(s)
CREATE TABLE "USER "."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) )
IN "USERSPACE1" ;
ALTER TABLE "USER "."EMPLOYEE"
ADD CONSTRAINT "CC1151778928062" PRIMARY KEY
("EMPNO");
List of tables