Subject Re: [IBO] TIB_Script
Author Lucas Franzen
Aage Johansen schrieb:
> 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" ...

No, I do exactly this kind of DDL with TIB_Scripts for years now.
"Object is in use" is not a matter of committing, it's rather caused by
a second connection to the database.