Subject | Multiple scripts needing reconnection |
---|---|
Author | sdbeames |
Post date | 2002-11-26T00:28:42Z |
Hi,
I'm making some major changes to a FB1 db and I've found I need to
split the script into multiple sections and manually
disconnect/reconnect between running each one to avoid errors.
Are there some guidelines as to when this is needed? I've read that I
need to have commits when switching between DDL & DML, but I still
can't do everything with one script/connection.
Thanks,
Steve
I'm making some major changes to a FB1 db and I've found I need to
split the script into multiple sections and manually
disconnect/reconnect between running each one to avoid errors.
Are there some guidelines as to when this is needed? I've read that I
need to have commits when switching between DDL & DML, but I still
can't do everything with one script/connection.
Thanks,
Steve