At 17/06/2002 08:57 PM, you wrote:

>I'm new to IB.
>
>My original Paradox to IB6 conversion used the script
>
>CREATE DOMAIN D_NUMERIC NUMERIC(15,8);
>
>As a side note, the actual definiton now appears to
>be NUMERIC(18,8).
>
>I now want to alter this to DECIMAL(18,8).
>
>When I prepare a script in the IB_SQL DSQL window, I'm getting
>an error:
>
>The Script:
>
>ALTER DOMAIN D_NUMERIC TO DECIMAL(18,8);

What you entered above corresponds to:
ALTER DOMAIN domain_name TO new_domain_name;

This is what you need to enter:
ALTER DOMAIN D_NUMERIC TYPE DECIMAL(18,8);

2. If possible, a correct script example to help me along

> would be greatly appreciated.

Look in the Data Definition Guide on page 91 and you'll get the example
that you are looking for.


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