zOs/SQL/EXCEP

  SET CURRENT SQLID='S100447';
  drop tablespace dgdb9998.except;
--drop tablespace DA540769.except;
  commit;
  CREATE TABLESPACE  except
    IN DGDB9998
    USING STOGROUP GSMS
    PRIQTY 48 SECQTY 100
    ERASE  NO
    FREEPAGE 0 PCTFREE 10
    GBPCACHE CHANGED
    TRACKMOD YES
    SEGSIZE 8
    BUFFERPOOL BP2
    LOCKSIZE ANY
    LOCKMAX SYSTEM
    CLOSE YES
    COMPRESS YES
    CCSID      EBCDIC
    DEFINE YES
    MAXROWS 255;
--
  CREATE TABLE GDB9998.except
     (pri       smallint not null with default 20,
      db        char(8) not null,
      ts        char(8) not null,
      ix        char(16) not null with default ,
      fun       char(8) not null,
      code      char(8) not null,
      wert      float   not null with default -1,
      info      char(50) not null with default
      )
    IN DGDB9998.except
    AUDIT NONE
    DATA CAPTURE NONE
    CCSID      EBCDIC
    NOT VOLATILE;
--