Loading...
Searching...
No Matches
mpe_config.ddl
Go to the documentation of this file.
1/**
2 @file
3 @brief Provides configuration by scope, name & value
4
5 @version 9.2
6 @author 4GL Apps Ltd
7 @copyright 4GL Apps Ltd
8**/
9
10proc sql;
11create table &curlib..mpe_config(
12 tx_from num not null format=datetime19.3
13 ,tx_to num not null format=datetime19.3
14 ,var_scope varchar(10) not null
15 ,var_name varchar(32) not null
16 ,var_value varchar(5000)
17 ,var_active num
18 ,var_desc varchar(300)
19 ,constraint pk_mpe_config
20 primary key(tx_from, var_scope, var_name));