#2 xml method of describing platform options

[Mark Newnham]

I'm trying to create a schema that runs against
multiple platforms. At the moment I've got

<table name="applications" platform="mysql|ocipo">
......
</table>

Is there any way I can add a platform specific option
against the table e.g.
<table name="applications" platform="mysql|ocipo">
<platform name="mysql">
<opt name="type">ISAM</opt>
<platform>
<platform name="ocipo">
<opt name="tablespace">USERS</opt>
<platform>

......
</table>

that duplicates the taboptarray feature?

[Richard Tango-Lowy]

Logged In: YES
user_id=302293

An interesting and valid question. To do this in the current
version, you would have to make one copy of the table for
each platform type. I haven't tried it, but the following
should work:

<table name="applications" platform="mysql">
<opt name="type">ISAM</opt>
...
</table>
<table name="applications" platform="ocipo">
<opt name="tablespace">USERS</opt>
...
</table>

As an enhancement, I might be able to add the "platform"
argument to the <opt> tag. E.g., <opt name="tablespace"
platform="ocipo">.