Subject Re: [ib-support] How to test a sequence then rollback?
Author Mark Patterson
Helen Borrie wrote:
> At 02:06 PM 28-08-02 +1000, you wrote:
>>I want to test a sequence of scripts, adding fields, giving them values
< snip >
>>rollback. What's the trick?
> No trick of this ilk that could possibly succeed. All metadata must be
> committed before it exists.You can't do CommitRetaining on DDL; and you
> can't perform DML involving metadata objects that don't exist.

OK, thanks for the info. I've got a test bed to start from. I'll just have to do
lots of file copying, I suppose.