mpe_validations.ddl
Go to the documentation of this file.
1 /**
2  @file mpe_validations.ddl
3  @brief ddl file
4  @details
5 
6 
7  @version 9.2
8  @author 4GL Apps Ltd
9  @copyright 4GL Apps Ltd
10 **/
11 
12 
13 create table &curlib..MPE_VALIDATIONS
14  (
15  TX_FROM float format=datetime19.,
16  BASE_LIB varchar(8),
17  BASE_DS varchar(32),
18  BASE_COL varchar(32),
19  RULE_TYPE varchar(32),
20  RULE_VALUE varchar(128),
21  RULE_ACTIVE int ,
22  TX_TO float not null format=datetime19.,
23  constraint pk_mpe_validations
24  primary key(tx_from, base_lib,base_ds,base_col,rule_type));
25 
26 insert into &syslast set
27  tx_from=0
28  ,base_lib="&mpelib"
29  ,base_ds="MPE_TABLES"
30  ,base_col="LIBREF"
31  ,rule_type='CASE'
32  ,rule_value='UPCASE'
33  ,rule_active=1
34  ,tx_to='31DEC5999:23:59:59'dt;
35 
36 insert into &syslast set
37  tx_from=0
38  ,base_lib="&mpelib"
39  ,base_ds="MPE_TABLES"
40  ,base_col="DSN"
41  ,rule_type='CASE'
42  ,rule_value='UPCASE'
43  ,rule_active=1
44  ,tx_to='31DEC5999:23:59:59'dt;
45 
46 insert into &syslast set
47  tx_from=0
48  ,base_lib="&mpelib"
49  ,base_ds="MPE_TABLES"
50  ,base_col="LIBREF"
51  ,rule_type='NOTNULL'
52  ,rule_value=' '
53  ,rule_active=1
54  ,tx_to='31DEC5999:23:59:59'dt;
55 
56 insert into &syslast set
57  tx_from=0
58  ,base_lib="&mpelib"
59  ,base_ds="MPE_TABLES"
60  ,base_col="DSN"
61  ,rule_type='NOTNULL'
62  ,rule_value=' '
63  ,rule_active=1
64  ,tx_to='31DEC5999:23:59:59'dt;
65 
66 insert into &syslast set
67  tx_from=0
68  ,base_lib="&mpelib"
69  ,base_ds="MPE_TABLES"
70  ,base_col="NUM_OF_APPROVALS_REQUIRED"
71  ,rule_type='MINVAL'
72  ,rule_value='1'
73  ,rule_active=1
74  ,tx_to='31DEC5999:23:59:59'dt;