Loading...
Searching...
No Matches
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
13create 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
27insert 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
38insert 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
49insert 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
60insert 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;