Loading...
Searching...
No Matches
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
12proc sql;
13create 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
26create unique index pk_mpe_selectbox on &syslast(ver_from_dttm, selectbox_rk);
27
28insert 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;
37insert 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;
46insert 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;
55insert 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;
64insert 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;
73insert 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;
82insert 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;
91insert 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;
100insert 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;
109insert 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