RE: [Firebird-devel] XML Load/Dump Utility

[Leyne, S. <Se...@br...>]

Jim,

> Default value and domain (global field) definitions are more
> problematic.  First, they're not supported by JDBC on which IscDbc is
> modelled.  Second, I don't really know how to differentiate between
bona
> fide and artificial domains.  I would like to support the former and
not
> clutter up the world with the latter.
>=20
>    <metadata>
>       <table name=3D"EMPLOYEE">
>          <column name=3D"SALARY" type=3D"double" scale=3D"-2"
nullable=3D"yes"/>

This presentation is 'unexpected' (I didn't expect it).

Although "double" is the true datatype, it is not the SQL datatype which
I expected to be used in the DDL (i.e. NUMERIC( 10, 2)).  Doesn't this
representation loose the accuracy of data schema?

How would a value with a datatype of NUMERIC( 10, 2) be presented?

<column name=3D"SALARY" type=3D"numeric" size=3D"10" precision=3D"2"
nullable=3D"yes"/>???


Further, keeping "small is beautiful" in mind, wouldn't it be better to
use 'NotNull=3D"yes"' instead of 'nullable=3D"yes"', since NotNull is =
the
exception more than the norm?=20


Sean