At 04/30/2002 11:36 AM, you wrote:

>Domains aren't just about data types - they're Domains: that is, a
>particular
>datatype with/out a check constraint and not null constraint and even a
>default value.

What I see is to use get the data type from the Domain and not bother with
the constraints.

>In a stored procedure, what would a parameter or variable be when it is
>defined as NOT NULL?!
>
>I'd rather have the same construct as Oracle:
>
>Declare a variable as: myvar %EMPLOYEE.EMPNO%

This would be helpful too, especially for those fields that don't have a
domain.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)