At 02:32 PM 28/04/2004 +0100, you wrote:

>I wish this could be done but my observation
>contradicts this solution. Just having two connections
>and performing create table with a foreign key
>definition gives me the error. So, such a 'defer' DDL
>approach will not work. One solution I can think of is
>to create the tables up front rather than doing it
>from my application. This way, I can ensure
>"Exclusive" access to the DB (at least from my own
>application) during the DDL execution. I can not still
>avoid some user trying to connect using (say) a isql
>console to the same DB !

Of course you can. You perform a database shutdown (see gfix -shut) which
gives you exclusive access until you bring the database online again with
gfix -online.

/heLen