Re: CREATE TABLE & INDEX in one transaction
Yes!! .- You have to commit your "create the table.. " first
Harry Sheng wrote:
> Hi,
>
> I want to create table and its index in one transaction.
> That is because if CREATE INDEX failed, I can rollback
> the CREATE TABLE.
>
> I used the following script in IDS7.30,
>
> begin work;
> create table tblname (....);
> create index xtblname on tblname (...);> commit work;
>
> I always got an #206 error. I do not know if I have to
> commit the "CREATE TABLE mytable" before
> I can create index on "mytable".
>
> Thanks a lot.