mpe_dataloads.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  @copyright 4GL Apps Ltd
10 **/
11 
12 proc sql;
13 create table &curlib..mpe_dataloads(
14  libref varchar(8) not null,
15  dsn varchar(32) not null,
16  etlsource varchar(100) not null,
17  loadtype varchar(20) not null,
18  changed_records int,
19  new_records int,
20  deleted_records int,
21  duration num,
22  user_nm varchar(50) not null,
23  processed_dttm num format=datetime19.3,
24  mac_ver varchar(5),
25  constraint pk_mpe_dataloads
26  primary key(processed_dttm, libref,dsn,etlsource));