| CREATE TABLE trafodion.persnl.job | |
| ( jobcode NUMERIC (4) UNSIGNED NO DEFAULT NOT NULL | |
| , jobdesc VARCHAR (18) DEFAULT ' ' NOT NULL | |
| , PRIMARY KEY ( jobcode ) | |
| ) ; | |
| INSERT INTO trafodion.persnl.job VALUES | |
| ( 100, 'MANAGER' ) | |
| , ( 200, 'PRODUCTION SUPV' ) | |
| , ( 250, 'ASSEMBLER' ) | |
| , ( 300, 'SALESREP' ) | |
| , ( 400, 'SYSTEM ANALYST' ) | |
| , ( 420, 'ENGINEER' ) | |
| , ( 450, 'PROGRAMMER' ) | |
| , ( 500, 'ACCOUNTANT' ) | |
| , ( 600, 'ADMINISTRATOR' ) | |
| , ( 900, 'SECRETARY' ) | |
| ; | |
| UPDATE STATISTICS FOR TABLE trafodion.persnl.job ON EVERY COLUMN ; |