mpe_maxkeyvalues.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_maxkeyvalues(
14  keytable varchar(41) label='Base table in libref.dataset format',
15  keycolumn char(32) format=$32.
16  label='The Surrogate / Retained key field containing the key values.',
17  max_key num label=
18  'Integer value representing current max RK or SK value in the KEYTABLE',
19  processed_dttm num format=E8601DT26.6
20  label='Datetime this value was last updated',
21  constraint pk_mpe_maxkeyvalues
22  primary key(keytable));