Re: [dtp-dev] SQL Model Question - Column Data Types

[rcernich@xxxxxxxxxx]

Hey Hemant,

Thanks for the response.

> referenceType returns UserDefinedType and containedType returns
> SQLDataType(superclass of PredefinedDataType). both referenceType and
> containedType are XOR.
>
> DataType is superclass of SQLDataType and UserDefinedDataType. the
> convenience method get/setDataType
> on Column wraps both referenceType and containedType so that the
> user can only think it terms of DataType
> when manipulating datatype of a column.
>
> pl refer TypedElement diagram in Schema package.
>

Just to clarify, referenceType should be used when the column's type is a
UserDefinedType and containedType should be used when the column's type is
a REF type or predefined data type?  (This isn't clear from the
documentation.)  If so, I'm guessing this implies that the containedType is
actually a container for the specific type?  (Which is what the
relationship implies.)

Thanks again for the clarification.

Rob