) TYPE=MyISAM;

This is converted to 

output.db2.create.2004.01.06.01.38,

 which in the sample 

application case is as following (Example 5 18).

Example 5 18   Output DB2 statements

   Table structure for table  catalog 

CREATE TABLE catalog ( 

  manufacturer CHAR(14)  default  0 ,

  model CHAR(25)  default NULL,

  type CHAR(25)  default NULL,

  year_from CHAR(7)  default NULL,

  year_to CHAR(7)  default NULL,

  kw CHAR(3)  default NULL,

  hp CHAR(3)  default NULL,

  ccm CHAR(4)  default NULL,

  cyl_capacity CHAR(2)  default NULL,

  motor_code CHAR(60)  default NULL,

  prodgroup CHAR(2)  default NULL,

  sku CHAR(8)  default NULL,

  dimension CHAR(12)  default NULL,

  ac CHAR(3)  default NULL,

  transmission CHAR(3)  default NULL,

  hint CHAR(60)  default NULL,

  stock INT  default NULL,

  id INT  NOT NULL GENERATED BY DEFAULT AS IDENTITY,

  PRIMARY KEY  (id)

  );

   Table structure for table  oenummer 

CREATE TABLE oenummer ( 

  id INT  NOT NULL GENERATED BY DEFAULT AS IDENTITY,

  sku CHAR(8)  default  0 ,

  oe_no CHAR(15)  default NULL,

  PRIMARY KEY  (id)

  );

   Table structure for table  users 

CREATE TABLE users ( 

  id INT  NOT NULL GENERATED BY DEFAULT AS IDENTITY,

  firstname VARCHAR(30)  default NULL,

  lastname VARCHAR(30)  NOT NULL default   ,

122 

MySQL to DB2 UDB Conversion Guide