mpe_datastatus_tabs.ddl
Go to the documentation of this file.
1 /**
2  @file mpe_datastatus_tabs.ddl
3  @brief ddl file
4  @details
5 
6  @version 9.3
7  @author 4GL Apps Ltd
8  @copyright 4GL Apps Ltd
9 **/
10 
11 create table &curlib..mpe_datastatus_tabs(
12  TX_FROM float format=datetime19.,
13  TX_TO float format=datetime19.,
14  libref char(8) label='Library Name',
15  dsn char(64) label='Member Name',
16  filesize num format=SIZEKMG. label='Size of file',
17  crdate num format=DATETIME. informat=DATETIME. label='Date Created',
18  modate num format=DATETIME. informat=DATETIME. label='Date Modified',
19  nobs num label='Number of Physical (Actual, inc. deleted) Observations',
20  constraint pk_mpe_datastatus_tabs
21  primary key(libref,dsn,tx_to));