1 CREATE TABLE table-name 2 ( 2.1+ , 2.1.0 %column-definition 2.1.0 %period-definition 2.1.0 %unique-constraint 2.1.0 %referential-constraint 2.1.0 %check-constraint 2.2 ) 2 LIKE 2.1 table-name 2.1 view-name 2.2? %copy-options 2 %as-result-table 2.1? %copy-options 2 %materialized-query-definition 3+ 3 (1) 3.1? 3.1.0 IN 3.1.0.1.0? database-name. 3.1.0.1.1 table-space-name 3.1.0 IN DATABASE database-name 3.1.0 IN ACCELERATOR accelerator-name 3.1 %partitioning-clause 3.1 %organization-clause 3.1 EDITPROC program-name 3.1.1! WITH ROW ATTRIBUTES 3.1.1? 3.1.1 WITHOUT ROW ATTRIBUTES 3.1 VALIDPROC program-name 3.1! AUDIT NONE 3.1? 3.1 AUDIT CHANGES 3.1 AUDIT ALL 3.1 OBID integer 3.1! DATA CAPTURE NONE 3.1? 3.1 DATA CAPTURE CHANGES 3.1 WITH RESTRICT ON DROP 3.1 CCSID 3.1.1 ASCII 3.1.1 EBCDIC 3.1.1 UNICODE 3.1! NOT VOLATILE 3.1.1! CARDINALITY 3.1? 3.1 VOLATILE 3.1.1! CARDINALITY 3.1! LOGGED 3.1? 3.1 NOT LOGGED 3.1! COMPRESS NO 3.1? 3.1 COMPRESS YES 3.1 APPEND 3.1.1! NO 3.1.1 YES 3.1 DSSIZE integer G 3.1 BUFFERPOOL bpname 3.1 MEMBER CLUSTER 3.1! TRACKMOD YES 3.1? 3.1 TRACKMOD NO