mpe_datacatalog_vars.ddl
Go to the documentation of this file.
1 /**
2  @file
3  @brief DDL for MPE_DATACATALOG_VARS
4  @details
5 
6  @version 9.3
7  @author 4GL Apps Ltd
8  @copyright 4GL Apps Ltd
9 **/
10 
11 create table &curlib..mpe_datacatalog_vars(
12  TX_FROM float format=datetime19.,
13  TX_TO float format=datetime19.,
14  libref char(8) label='Library Name',
15  dsn char(64) label='Table Name',
16  memtype char(8) label='Member Type',
17  name char(64) label='Column Name',
18  type char(16) label='Column Type',
19  length num label='Column Length',
20  varnum num label='Column Number in Table',
21  label char(512) label='Column Label',
22  format char(49) label='Column Format',
23  idxusage char(9) label='Column Index Type',
24  notnull char(3) label='Not NULL?',
25  pk_ind num label="Primary Key Indicator (1=Primary Key field)",
26  constraint pk_mpe_datacatalog_vars
27  primary key(libref,dsn,name,tx_to));