zOs/SQL/HANS

  SET CURRENT SQLID='S100447';
  drop table oA1T.tadm35A1;
  CREATE TABLE OA1T.TADM35A1
     (DB_NAME              CHAR(8) NOT NULL,
      DD_NAME              CHAR(8) NOT NULL,
      high_used_rba        DECIMAL(10) not null with DEFAULT,
      free_block_pct       DECIMAL(6, 2) not null with DEFAULT,
      cisplit             DECIMAL(5) not null with DEFAULT,
      casplit             DECIMAL(5) not null with DEFAULT,
      extents              DECIMAL(4) not null with DEFAULT,
      BLock_beyond         DECIMAL(6) not null with DEFAULT,
      over_flow_pct        DECIMAL(6,2) not null with DEFAULT,
      syn_chain            DECIMAL(2, 0) not null with DEFAULT
     )
    IN DB2ADMIN.A035A;
insert into oa1t.tadm35a1 (db_name, dd_name) values('db', 'dd');
commit  ;