mpe_selectbox.ddl
Go to the documentation of this file.
1 /**
2  @file
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 proc sql;
13 create table &curlib..mpe_selectbox(
14  selectbox_rk int not null, /* surrogate key */
15  ver_from_dttm num not null, /* timestamp for versioning */
16  select_lib varchar(17) not null, /* libref (big enough for uri)*/
17  select_ds varchar(32) not null,
18  base_column varchar(36) not null, /* variable name against which to apply selectbox */
19  selectbox_value varchar(500) not null, /* selectbox value */
20  selectbox_order int , /* optional ordering (1 comes before 2) */
21  selectbox_type varchar(32) , /* column type (blank for default, else
22  sas or js to indicate relevant system functions*/
23  ver_to_dttm num not null /* timestamp for versioning */
24  );
25 
26 create unique index pk_mpe_selectbox on &syslast(ver_from_dttm, selectbox_rk);
27 
28 insert into &syslast set
29  selectbox_rk=1
30  ,ver_from_dttm=0
31  ,select_lib="&mpelib"
32  ,select_ds="MPE_LOCKANYTABLE"
33  ,base_column="LOCK_STATUS_CD"
34  ,selectbox_value='LOCKED'
35  ,selectbox_order=1
36  ,ver_to_dttm='31DEC5999:23:59:59'dt;
37 insert into &syslast set
38  selectbox_rk=2
39  ,ver_from_dttm=0
40  ,select_lib="&mpelib"
41  ,select_ds="MPE_LOCKANYTABLE"
42  ,base_column="LOCK_STATUS_CD"
43  ,selectbox_value='UNLOCKED'
44  ,selectbox_order=2
45  ,ver_to_dttm='31DEC5999:23:59:59'dt;
46 insert into &syslast set
47  selectbox_rk=3
48  ,ver_from_dttm=0
49  ,select_lib="&mpelib"
50  ,select_ds="MPE_SECURITY"
51  ,base_column="ACCESS_LEVEL"
52  ,selectbox_value='EDIT'
53  ,selectbox_order=1
54  ,ver_to_dttm='31DEC5999:23:59:59'dt;
55 insert into &syslast set
56  selectbox_rk=4
57  ,ver_from_dttm=0
58  ,select_lib="&mpelib"
59  ,select_ds="MPE_SECURITY"
60  ,base_column="ACCESS_LEVEL"
61  ,selectbox_value='APPROVE'
62  ,selectbox_order=2
63  ,ver_to_dttm='31DEC5999:23:59:59'dt;
64 insert into &syslast set
65  selectbox_rk=5
66  ,ver_from_dttm=0
67  ,select_lib="&mpelib"
68  ,select_ds="MPE_SECURITY"
69  ,base_column="ACCESS_LEVEL"
70  ,selectbox_value='SIGNOFF'
71  ,selectbox_order=3
72  ,ver_to_dttm='31DEC5999:23:59:59'dt;
73 insert into &syslast set
74  selectbox_rk=6
75  ,ver_from_dttm=0
76  ,select_lib="&mpelib"
77  ,select_ds="MPE_TABLES"
78  ,base_column="LOADTYPE"
79  ,selectbox_value='UPDATE'
80  ,selectbox_order=1
81  ,ver_to_dttm='31DEC5999:23:59:59'dt;
82 insert into &syslast set
83  selectbox_rk=7
84  ,ver_from_dttm=0
85  ,select_lib="&mpelib"
86  ,select_ds="MPE_TABLES"
87  ,base_column="LOADTYPE"
88  ,selectbox_value='REPLACE'
89  ,selectbox_order=2
90  ,ver_to_dttm='31DEC5999:23:59:59'dt;
91 insert into &syslast set
92  selectbox_rk=8
93  ,ver_from_dttm=0
94  ,select_lib="&mpelib"
95  ,select_ds="MPE_TABLES"
96  ,base_column="LOADTYPE"
97  ,selectbox_value='TXTEMPORAL'
98  ,selectbox_order=3
99  ,ver_to_dttm='31DEC5999:23:59:59'dt;
100 insert into &syslast set
101  selectbox_rk=9
102  ,ver_from_dttm=0
103  ,select_lib="&mpelib"
104  ,select_ds="MPE_TABLES"
105  ,base_column="LOADTYPE"
106  ,selectbox_value='BITEMPORAL'
107  ,selectbox_order=4
108  ,ver_to_dttm='31DEC5999:23:59:59'dt;
109 insert into &syslast set
110  selectbox_rk=10
111  ,ver_from_dttm=0
112  ,select_lib="&mpelib"
113  ,select_ds="MPE_TABLES"
114  ,base_column="LOADTYPE"
115  ,selectbox_value='FORMAT_CAT'
116  ,selectbox_order=5
117  ,ver_to_dttm='31DEC5999:23:59:59'dt;
118