mpe_datadictionary.ddl
Go to the documentation of this file.
1 /**
2  @file mpe_datadictionary.ddl
3  @brief ddl file
4  @details
5 
6 
7  @version 9.3
8  @author 4GL Apps Ltd
9  @copyright 4GL Apps Ltd
10 **/
11 
12 
13 create table &curlib..mpe_datadictionary
14  (
15  TX_FROM float format=datetime19.,
16  DD_TYPE char(16),
17  DD_SOURCE char(1024),
18  DD_SHORTDESC char(256),
19  DD_LONGDESC char(32767),
20  DD_OWNER char(128),
21  DD_RESPONSIBLE char(128),
22  DD_SENSITIVITY char(64),
23  TX_TO float not null format=datetime19.,
24  constraint pk_mpe_datadictionary
25  primary key(tx_from, dd_type,dd_source));
26 
27 insert into &syslast set
28  tx_from=0
29  ,DD_TYPE='LIBRARY'
30  ,DD_SOURCE="&mpelib"
31  ,DD_SHORTDESC="Data Controller Control Tables"
32  ,DD_LONGDESC="# The Data Controller Library"
33  ,DD_OWNER="&sysuserid"
34  ,DD_RESPONSIBLE="&sysuserid"
35  ,DD_SENSITIVITY="Low"
36  ,tx_to='31DEC5999:23:59:59'dt;
37 
38 insert into &syslast set
39  tx_from=0
40  ,DD_TYPE='TABLE'
41  ,DD_SOURCE="&mpelib..MPE_TABLES"
42  ,DD_SHORTDESC="Configuration of new tables for Data Controller"
43  ,DD_LONGDESC="# MPE_TABLES - adding new tabels to Data Controller"
44  ,DD_OWNER="&sysuserid"
45  ,DD_RESPONSIBLE="&sysuserid"
46  ,DD_SENSITIVITY="Low"
47  ,tx_to='31DEC5999:23:59:59'dt;
48 
49 insert into &syslast set
50  tx_from=0
51  ,DD_TYPE='COLUMN'
52  ,DD_SOURCE="&mpelib..MPE_TABLES.DSN"
53  ,DD_SHORTDESC="Dataset Name to be edited"
54  ,DD_LONGDESC="_DSN_ - must be UPCASE"
55  ,DD_OWNER="&sysuserid"
56  ,DD_RESPONSIBLE="&sysuserid"
57  ,DD_SENSITIVITY="Low"
58  ,tx_to='31DEC5999:23:59:59'dt;
59 
60 insert into &syslast set
61  tx_from=0
62  ,DD_TYPE='DIRECTORY'
63  ,DD_SOURCE="/some/directory"
64  ,DD_SHORTDESC="Directory for some purpose"
65  ,DD_LONGDESC="This directory is great. It's great directory. It trumps all other directories."
66  ,DD_OWNER="&sysuserid"
67  ,DD_RESPONSIBLE="&sysuserid"
68  ,DD_SENSITIVITY="Low"
69  ,tx_to='31DEC5999:23:59:59'dt;