db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prakash (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2934) Trigger for data from two tables to one.
Date Fri, 13 Jul 2007 07:39:04 GMT
Trigger for data from two tables to one.
----------------------------------------

                 Key: DERBY-2934
                 URL: https://issues.apache.org/jira/browse/DERBY-2934
             Project: Derby
          Issue Type: Wish
    Affects Versions: 10.2.2.0
         Environment: Netbeans ide 5.5, linux
            Reporter: Prakash


i did create the below tables

create table one (v_id int not null primary key generated always as identity(start with 1,
increment  by 1), v_date date, cs_cr char (1) default 's' constraint cscr check (cs_cr in('s','r')),
total decimal (5) )

create table two (v_id int not null primary key generated always as identity(start with 1,
increment  by 1), one_v_id inf foreign key references one(v_id), prd_code int foreign key
references prd(prd_code), qty double, uom int foreign key references uom(uom_code), rate decimal
(3) )

create table three (v_id int not null primary key generated always as identity(start with
1, increment  by 1), one_v_id int, one_v_date, two_v_id int, prd_code int ,qty double)

after create i want to know hw to create a single triger to insert/update [on change] values
from "one", "two" to "three". 

column in table three                                  value from table(column)
v_id                                                                 should be auto generated.
one_v_id                                                        one(v_id)
one_v_date                                                   one(v_date)
two_v_id                                                        two(v_id)
prd_code                                                       two(prd_code)
qty                                                                   two(qty)

it could be found that the above table are without schema. if it is created with schema then
hw to write a trigger.

Prakash

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message