mpe_filtersource.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 **/
10 
11 create table &curlib..mpe_filtersource(
12  filter_hash char(32) not null,
13  filter_line num not null,
14  group_logic char(3) not null,
15  subgroup_logic char(3) not null,
16  subgroup_id num not null,
17  variable_nm varchar(32) not null,
18  operator_nm varchar(12) not null,
19  raw_value varchar(4000) not null,
20  processed_dttm num not null format=datetime19.,
21  constraint pk_mpe_filteranytable
22  primary key(filter_hash,filter_line));