constraints and transactions

nelapsi · #1 (**permalink**) 02-16-06, 10:29

that I want to do :

Code:

update command options using c off;
create table ttt(id integer not null);
commit;
insert into ttt values(null)
<....>
update ttt set id = 1;
commit

but DB2 check "not null" constraint inside transaction. But I want to check it after transaction..
how can I do it?

n_i · #2 (**permalink**) 02-16-06, 10:46

Create the table without the unique constraint; add the constraint when you're finished with updates.

nelapsi · #3 (**permalink**) 02-16-06, 16:32

Quote:

Originally Posted by n_i

Create the table without the unique constraint; add the constraint when you're finished with updates.

I want to use such transactions at any time - not only after table creation

NGambler · #4 (**permalink**) 02-17-06, 07:10

You can switch a constraint to enforced or not enforced state...
for instance:

update command options using c off;
create table ttt
(id integer
constraint chk_null CHECK(id is not null)
);
commit;
alter table ttt alter CHECK chk_null not enforced;
insert into ttt values(null);
<....>
update ttt set id = 1;
alter table ttt alter CHECK chk_null enforced;
commit;

Internet Services

Web Development

Digital Marketing

Consumer Tech