Topic
No replies
TomKennedy
TomKennedy
1 Post
ACCEPTED ANSWER

Pinned topic MySql set data type and CustumDataMapping.properties

‏2014-07-14T16:05:25Z |

I am having an issue using the IBM Data Mover Tool.

am haviI have this table definition in my  MySql database

CREATE TABLE `eventum_project` (
  `prj_id` int(11) unsigned NOT NULL auto_increment,
  `prj_created_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `prj_title` varchar(64) NOT NULL default '',
  `prj_status` set('active','archived') NOT NULL default 'active',

Notice the prj_status set is of type SET which is I suppose is not supported in DB2.

I see this in the db2tables.sql file

 

CREATE  TABLE "HELPDESK"."EVENTUM_PROJECT"
(
"PRJ_ID" INT  NOT NULL  GENERATED BY DEFAULT AS IDENTITY (START WITH 49, INCREMENT BY 1, CACHE 20),
"PRJ_CREATED_DATE" TIMESTAMP  NOT NULL ,
"PRJ_TITLE" VARCHAR(64)  NOT NULL ,
"PRJ_STATUS" UNDEFINED /* Original data type was SET */  NOT NULL ,

So I added this to the CustomDataMapping.properties file.

HELPDESK.eventum_project.prj_status=CHAR(8)

and tried this of course

HELPDESK.EVENTUM_PROJECT.PRJ_STATUS=CHAR(8)

It seems to not have any effect.  Any idea what I am doing wrong?

FWIW:  I changed the data type  in my test MySql database to enum and it works. 

 

 

 
Updated on 2014-07-14T16:08:11Z at 2014-07-14T16:08:11Z by TomKennedy