Code:
-
- CREATE TABLE PGMT/DTKSTRPF (
- STOF# DECIMAL(10, 0) NOT NULL DEFAULT 0 ,
- STSTORE DECIMAL(3, 0) NOT NULL DEFAULT 0)
-
- RCDFMT DTKSTRRF ;
-
- LABEL ON TABLE PGMT/DTKSTRPF
- IS 'Order Form Stores Auth. to Order.' ;
-
- LABEL ON COLUMN PGMT/DTKSTRPF
- ( STOF# IS 'ORDER FORM#' ,
- STSTORE IS 'Store Number' ) ;
-
- LABEL ON COLUMN PGMT/DTKSTRPF
- ( STOF# TEXT IS 'ORDER FORM#' ,
- STSTORE TEXT IS 'Store Number' ) ;
-
- Insert into PGMT/DTKSTRPF (STOF#, STSTORE)
- Values
- (2 ,1 ),
- (2 ,2 ),
- (2 ,3 ),
- (2 ,4 ),
- (2 ,5 ),
- (2 ,6 ),
- (2 ,7 ),
- (2 ,9 ),
- (2 ,10 ),
- (2 ,11 ),
- (2 ,12 ),
- (2 ,13 ),
- (2 ,14 ),
- (2 ,15 ),
- (2 ,17 ),
- (2 ,18 ),
- (2 ,20 ),
- (2 ,21 ),
- (2 ,22 ),
- (2 ,23 ),
- (2 ,25 ),
- (2 ,26 ),
- (2 ,28 ),
- (2 ,29 ),
- (2 ,30 ),
- (2 ,31 ),
- (2 ,34 ),
- (2 ,36 ),
- (2 ,37 ),
- (2 ,38 ),
- (2 ,39 ),
- (2 ,40 ),
- (2 ,41 ),
- (2 ,42 ),
- (2 ,43 ),
- (2 ,44 ),
- (2 ,45 ),
- (2 ,47 ),
- (2 ,48 ),
- (2 ,49 ),
- (2 ,50 ),
- (2 ,51 ),
- (2 ,52 ),
- (2 ,53 ),
- (2 ,55 ),
- (2 ,56 ),
- (2 ,57 ),
- (2 ,58 ),
- (2 ,59 ),
- (2 ,60 ),
- (6 ,1 ),
- (6 ,3 ),
- (6 ,4 ),
- (6 ,6 ),
- (6 ,9 ),
- (6 ,11 ),
- (6 ,13 ),
- (6 ,14 ),
- (6 ,15 ),
- (6 ,18 ),
- (6 ,20 ),
- (6 ,22 ),
- (6 ,23 ),
- (6 ,27 ),
- (6 ,28 ),
- (6 ,29 ),
- (6 ,30 ),
- (6 ,34 ),
- (6 ,38 ),
- (6 ,39 ),
- (6 ,40 ),
- (6 ,41 ),
- (6 ,44 ),
- (6 ,47 ),
- (6 ,48 ),
- (6 ,49 ),
- (6 ,51 ),
- (6 ,64 ),
- (8 ,58 ),
- (10 ,1 ),
- (10 ,11 ),
- (11 ,7 ),
- (11 ,10 ),
- (11 ,11 ),
- (11 ,12 ),
- (11 ,17 ),
- (11 ,21 ),
- (11 ,24 ),
- (11 ,25 ),
- (11 ,26 ),
- (11 ,31 ),
- (11 ,36 ),
- (11 ,37 ),
- (11 ,52 ),
- (11 ,53 )
-
-
|
|