Lucas Franzen wrote:

>
> Aage Johansen schrieb:
>> I seem to remember that one is not supposed to use COMMITs within a
>> script (TIB_Script). Is this correct?
>>
>> I need to define several tables with indexes, constraints, triggers,
>> generators and grants (preferably in a single script). Can I do any
>> number of DDL statements and just do the single commit afterwards?
>
> yes.
>

Hmmm.
Testing seems to indicate that creating foreign key contraints
require previous DDL to be committed. "Object in use" ...


--
Aage J.