Datatype mapping

[Peter Parslow]

Searching the forum doesn't return anything for 'datatype map', so I'll start a new topic.

I have created a database product "TC211" containing some of the data types used by ISO TC211. I have created a datatype map to map these to Oracle. The tool for doing that is rather clumsy, but I believe I've got there.

But it doesn't work as I would expect, so CharacterString turns to VARCHAR(36), regardless of the length I specify in the map (and it would be even better to be able to specify it in the logical model); Boolean, which I've specified has a max length of 1 comes out as NUMBER(22).

Any suggestions?

[dannodj]

Hi Peter,

i am doing datatype conversions from logical model to xml schema and have used the transformation templates as follows.

%if attType=="Date"%
  type="xs:date"
%elseIf attType=="Title"%
  type="xs:string"
%elseIf attType=="indicator"%
  type="xs:boolean"
%elseIf attType=="Description"%
  type="xs:string"
%elseIf attType=="Time"%
  type="xs:time"
%else%
  type="xs:string"
%endIf%

It may be that the transformation you are doing has an inbuilt conversion?  I hope this helps a bit.
Regards,
Dan

[Peter Parslow]

Re-raised as http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1305025781

I was referring to the Datatype Map which is used by EA's "Reset DBMS"; the response last year seems to relate to scripting, which could be an option I guess.