Loading...
Searching...
No Matches
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
13create 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
26insert 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
36insert 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
46insert 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
56insert 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
66insert 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;