mpe_lockanytable.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_lockanytable(
14  lock_status_cd varchar(10) not null,
15  lock_lib varchar(8) not null ,
16  lock_ds varchar(32) not null,
17  lock_user_nm varchar(100) not null ,
18  lock_ref varchar(200),
19  lock_pid varchar(10),
20  lock_start_dttm num format=datetime19.3,
21  lock_end_dttm num format=datetime19.3,
22  constraint pk_mpe_lockanytable
23  primary key(lock_lib,lock_ds));