---------- Forwarded message ----------
From: Prakash Krishnan <[email protected]>
Date: Sat, Nov 21, 2009 at 4:02 AM
Subject: Require assistance
To: [email protected]
Dear Thomas,
We in our organization have decided to migrate from Derby Data base to H2
data base. I would like to get some assistance from you 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 u assist me in how to create the above table in H2
Thanking you
Regds - K.Prakash
--
Keep in Touch
Prakash
[email protected]
--
Keep in Touch
Prakash
[email protected]
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=.
