CREATE TABLE "ZZZ"."YYY" 
("AAA" VARCHAR2(64 CHAR), 
"BBB" VARCHAR2(64 CHAR), 
"CCC" VARCHAR2(10 CHAR) DEFAULT 'SQLORA', 
"DDD" VARCHAR2(4000 CHAR), 
CONSTRAINT "YYY_PK" PRIMARY KEY ("AAA") ENABLE
) ORGANIZATION INDEX NOCOMPRESS PCTFREE 10 INITRANS 2 MAXTRANS 255 LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "ZZZ_HOLDING_DATA" 
PCTTHRESHOLD 50 INCLUDING "AAA" OVERFLOW
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "ZZZ_HOLDING_DATA" ;

COMMENT ON COLUMN "ZZZ"."YYY"."AAA" IS 'Abc';
COMMENT ON COLUMN "ZZZ"."YYY"."BBB" IS 'Def';
COMMENT ON COLUMN "ZZZ"."YYY"."CCC" IS 'Ghi';
COMMENT ON COLUMN "ZZZ"."YYY"."DDD" IS 'Jkl';
COMMENT ON TABLE "ZZZ"."YYY"  IS 'Tuv';

--------------------------------------------------

FILENAME=ZZZ_YYY, SUFFIX=SQLORA  ,
REMARKS='Tuv', $
SEGMENT=ZZZ_YYY, SEGTYPE=S0, $
    FIELDNAME=AAA, ALIAS=AAA, USAGE=A64, ACTUAL=A64,
      DESCRIPTION='Abc', $
    FIELDNAME=BBB, ALIAS=BBB, USAGE=A64, ACTUAL=A64,
      DESCRIPTION='Def', $
    FIELDNAME=CCC, ALIAS=CCC, USAGE=A10, ACTUAL=A10,
      DESCRIPTION='Ghi', $
    FIELDNAME=DDD, ALIAS=DDD, USAGE=A4000, ACTUAL=A4000,
      MISSING=ON,
      DESCRIPTION='Jkl', $

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server