*   *ID* N99A24   DBCMD    changed on 1992-09-28-13.27.18 by ADMIN     *
* PRISM 107821
* tz, 31.7.90
file connect ( kern test !
CREATE TABLE t_appl_tracking
( aa01 char(5) key,
  aa02 char(5),
  aa03 char(5),
  aa04 char(5),
  aa05 char(5),
  aa06 char(5),
  aa07 char(5),
  aa08 char(5),
  aa09 char(5),
  aa10 char(5),
  aa11 char(5),
  aa12 char(5),
  aa13 char(5),
  aa14 char(5),
  aa15 char(5),
  aa16 char(5),
  aa17 char(5),
  aa18 char(5),
  aa19 char(5),
  aa20 char(5),
  aa21 char(5),
  aa22 char(5),
  aa23 char(5),
  aa24 char(5),
  aa25 char(5),
  aa26 char(5),
  aa27 char(5),
  aa28 char(5),
  aa29 char(5),
  aa30 char(5),
  aa31 char(5),
  aa32 char(5),
  aa33 char(5),
  aa34 char(5),
  aa35 char(5),
  aa36 char(5),
  aa37 char(5),
  aa38 char(5),
  aa39 char(5),
  aa40 char(5),
  aa41 char(5),
  aa42 char(5),
  aa43 char(5),
  aa44 char(5),
  aa45 char(5),
  aa46 char(5),
  aa47 char(5),
  aa48 char(5),
  aa49 char(5),
  aa50 char(5),
  aa51 char(5),
  aa52 char(5),
  aa53 char(5),
  aa54 char(5),
  aa55 char(5),
  aa56 char(5),
  aa57 char(5),
  aa58 char(5),
  aa59 char(5),
  aa60 char(5),
  aa61 char(5),
  aa62 char(5),
  aa63 char(5),
  aa64 char(5),
  aa65 char(5),
  aa66 char(5),
  aa67 char(5),
  aa68 char(5),
  aa69 char(5),
  aa70 char(6),
  aa71 char(6),
  aa72 char(5),
  aa73 char(5),
  aa74 char(5),
  zz01 fixed(4) range between 0 and 5000,
  zz02 char(1) range in ('Y','N',' ')) !
COMMIT WORK !
CREATE VIEW v_appl_tracking AS
SELECT * FROM t_appl_tracking !
COMMIT WORK !
file sel_cols_tab ( V_APPL_TRACKING !
drop table t_appl_tracking !
COMMIT WORK RELEASE !
