Code:
- -- Generate SQL
- -- Version: V5R4M0 060210
- -- Generated on: 05/15/08 08:21:42
- -- Relational Database: BOISE03
- -- Standards Option: DB2 UDB iSeries
-
- DROP TABLE DATRELPF ;
-
- CREATE TABLE DATRELPF (
- -- SQL1506 30 Key or attribute for DATRELPF ignored.
- DRDATE CHAR(15) CCSID 37 NOT NULL DEFAULT '' ,
- DRWEEK CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,
- DRDOW NUMERIC(3, 0) NOT NULL DEFAULT 0 )
-
- RCDFMT DATRELRF ;
-
- LABEL ON TABLE DATRELPF
- IS 'Relative Dates File' ;
- Insert Into DATRELPF (DRDATE, DRWEEK, DRDOW)
-
- Values
- ('1' ,'S',1),
- ('+1D' ,'S',1),
- ('+1W' ,'S',7),
- ('10' ,'S',10),
- ('+10D','S',10),
- ('+10W','S',70),
- ('11' ,'S',11),
- ('+11D','S',11),
- ('+11W','S',77),
- ('12' ,'S',12),
- ('+12D','S',12),
- ('+12W','S',84),
- ('13' ,'S',13),
- ('+13D','S',13),
- ('+13W','S',91),
- ('14' ,'S',14),
- ('+14D','S',14),
- ('+14W','S',98),
- ('15' ,'S',15),
- ('+15D','S',15),
- ('16' ,'S',16),
- ('16' ,'S',16),
- ('+16D','S',16),
- ('17' ,'S',17),
- ('+17D','S',17),
- ('18' ,'S',18),
- ('+18D','S',18),
- ('19' ,'S',19),
- ('+19D','S',19),
- ('2' ,'S',2),
- ('+2D' ,'S',2),
- ('+2W' ,'S',14),
- ('20' ,'S',20),
- ('+20D','S',20),
- ('3' ,'S',3),
- ('+3D' ,'S',3),
- ('+3W' ,'S',21),
- ('4' ,'S',4),
- ('+4D' ,'S',4),
- ('+4W' ,'S',28),
- ('5' ,'S',5),
- ('+5D' ,'S',5),
- ('+5W' ,'S',35),
- ('6' ,'S',6),
- ('+6D' ,'S',6),
- ('+6W' ,'S',42),
- ('7' ,'S',7),
- ('+7D' ,'S',7),
- ('+7W' ,'S',49),
- ('8' ,'S',8),
- ('+8D' ,'S',8),
- ('+8W' ,'S',56),
- ('9 ' ,'S',9),
- ('+9D' ,'S',8),
- ('+9W' ,'S',63),
- ('-1' ,'S',-1),
- ('-1D' ,'S',-1),
- ('-1W' ,'S',-7),
- ('-10' ,'S',-10),
- ('-11' ,'S',-11),
- ('-12' ,'S',-12),
- ('-13' ,'S',-13),
- ('-14' ,'S',-14),
- ('-14' ,'S',-14),
- ('-14D','S',-14),
- ('-15' ,'S',-15),
- ('-16' ,'S',-16),
- ('-17' ,'S',-17),
- ('-18' ,'S',-18),
- ('-19' ,'S',-19),
- ('-2 ' ,'S',-2),
- ('-2D' ,'S',-2),
- ('-2W' ,'S',-14),
- ('-20' ,'S',-20),
- ('-3 ' ,'S',-3),
- ('-3D' ,'S',-3),
- ('-3W' ,'S',-21),
- ('-4 ' ,'S',-4),
- ('-4D' ,'S',-4),
- ('-4W' ,'S',-28),
- ('-5 ' ,'S',-5),
- ('-5D' ,'S',-5),
- ('-5W' ,'S',-35),
- ('-6 ' ,'S',-6),
- ('-6D' ,'S',-6),
- ('-6W' ,'S',-42),
- ('-7 ' ,'S',-7),
- ('-7D' ,'S',-7),
- ('-7W' ,'S',-49),
- ('-8 ' ,'S',-8),
- ('-8W' ,'S',-56),
- ('-9 ' ,'S',-9),
- ('-9W' ,'S',-63),
- ('C' ,'D',0),
- ('FRI ','C',6),
- ('FRIDAY','C',6),
- ('LAST FRI','L',6),
- ('LAST FRIDAY','L',6),
- ('LAST MON','L',2),
- ('LAST MONDAY','L',2),
- ('LAST SAT','L',7),
- ('LAST SATURDAY','L',7),
- ('LAST SUN','L',1),
- ('LAST SUNDAY','L',1),
- ('LAST THU','L',5),
- ('LAST THURSDAY','L',5),
- ('LAST TUE','L',3),
- ('LAST TUESDAY','L',3),
- ('LAST WED','L',4),
- ('LAST WEDNESDAY','L',4),
- ('MON','C',2),
- ('MONDAY','C',2),
- ('NEXT FRI','N',6),
- ('NEXT FRIDAY','N',6),
- ('NEXT MON','N',2),
- ('NEXT MONDAY','N',2),
- ('NEXT SAT','N',7),
- ('NEXT SATURDAY','N',7),
- ('NEXT SUN','N',1),
- ('NEXT SUNDAY','N',1),
- ('NEXT THU','N',5),
- ('NEXT THURSDAY','N',5),
- ('NEXT TUE','N',3),
- ('NEXT TUESDAY','N',3),
- ('NEXT WED','N',4),
- ('NEXT WEDNESDAY','N',4),
- ('SAT','C',7),
- ('SATURDAY','C',7),
- ('SUN','C',1),
- ('SUNDAY','C',1),
- ('THIS FRI','C',6),
- ('THIS FRIDAY','C',6),
- ('THIS MON','C',2),
- ('THIS MONDAY','C',2),
- ('THIS SAT','C',7),
- ('THIS SATURDAY','C',7),
- ('THIS SUN','C',1),
- ('THIS SUNDAY','C',1),
- ('THIS THU','C',5),
- ('THIS THURSDAY','C',5),
- ('THIS TUE','C',3),
- ('THIS TUESDAY','C',3),
- ('THIS WED','C',4),
- ('THIS WEDNESDAY','C',4),
- ('THU','C',5),
- ('THURSDAY','C',5),
- ('TM','D',1),
- ('TODAY','D',0),
- ('TOMORROW','D',1),
- ('TUE','C',3),
- ('TUESDAY','C',3),
- ('WED','C',4),
- ('WEDNESDAY','C',4),
- ('Y','D',-1),
- ('YESTERDAY','D',-1)
|
|