Import and triggers

[Lino]

I'm a db2 newbie.
I want to import text file in a db2 table with a primary key and some
foreign key. Import utility works fine but I want bad data to be archived in
a file or in an error table (in oracle sqlldr there are bad files). I've
tried also with db2 load that works fine but there isn's insert_update. So I
thought a before insert trigger but this with this kind of trigger I cannot
insert data in another table.
Any suggestions?

Thanks.
Lino

[Tuong Do]

Import into a temp table
use after insert trigger to insert into the real table or bad data table
"Lino" <ad****@libero.it> wrote in message
news:g6*******************@twister2.libero.it...

I'm a db2 newbie.
I want to import text file in a db2 table with a primary key and some
foreign key. Import utility works fine but I want bad data to be archived
in
a file or in an error table (in oracle sqlldr there are bad files). I've
tried also with db2 load that works fine but there isn's insert_update. So
I
thought a before insert trigger but this with this kind of trigger I
cannot
insert data in another table.
Any suggestions?

Thanks.
Lino