We in our organization have decided to migrate from Derby Data base to
H2 data base. I would like to get some assistance from any one if you
are free.
The Problem that i face as of now.
I want to create a table with auto increment of primary key how to
define the same.i.e. in dery we create a table like below.
create table lgr(lgr_code int not null primary key generated always as
identity(start with 1, increment by 1),lgr_user_code varchar(13) not
null unique , lgr_name varchar(50) not null unique,lgr_description
varchar(125) default null,lgr_grp_code int not null, status char(1)
constraint status_type check(status in ('C','D')) default
'D',opening_balance double default 0.00,active char(1) not null
constraint acct_check check(active in('Y','N')) default
'Y',lgr_grp_head_code char(3) not null constraint lgrgrouphead check
(lgr_grp_head_code in
('CSH','PUR','DIN','DT','IIN','IEC','DTT','TCR','DEX','PLA','BNK','CPA','DEP','LNS','PVS','TAS','SDL','INV','UDL','GNR','OCL','ADV','MIS','IAS'))
,transaction_dr
double default 0.00,transaction_cr double default
0.00,transaction_balance double default 0.00)
now could any one assist me how to create the above table in H2
Database.
Thanking you
Regds - K.Prakash
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
mailing list - http://groups.google.com/group/openbd?hl=en
!! save a network - please trim replies before posting !!
