Jimy Carol
New User
Joined: 31 Aug 2012 Posts: 25 Location: Australia
|
|
|
|
Hi All ,
I have a question related to DB2 v 10 for Temporal table . Can a 'WITH DEFAULT ' clause appear for any column of Temporal table or History table ?
my existing code doesnt support WITH DEFAULT ' for any column of temporary and Aux table .
Appreciate for any pointers .
Regards ,
Carol |
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
works perfectly :
Code: |
create table test_temporal4
( emplid integer not null
, empltype varchar(4) with default 'CUST'
, eff_beg date not null with default
, eff_end date not null with default '9999-12-30'
, period business_time (eff_beg,eff_end)
, primary key (emplid, business_time without overlaps)
) ;
;
insert into test_temporal4 (emplid) values (1);
;
select * from test_temporal4
;
drop table test_temporal4 |
|
|