Loading...
Searching...
No Matches
mpe_lineage_cols.ddl
Go to the documentation of this file.
1/**
2 @file mpe_lineage_cols.ddl
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_lineage_cols
14 (
15 col_id char(32),
16 direction char(1),
17 jobname char(256),
18 sourcetablename char(256),
19 sourcecolname char(256),
20 sourcecoluri char(256),
21 map_type char(256),
22 map_transform char(256),
23 targettablename char(256),
24 targetcolname char(256),
25 targetcoluri char(256),
26 Derived_Rule char(500),
27 level int,
28 modified_dttm float,
29 modified_by char(64),
30 constraint pk_mpe_lineage_cols primary key
31 (
32 col_id,direction,sourcecoluri,targetcoluri,map_type,map_transform
33 )
34 );