Hi,

I want to create a trigger for insert in my table and send a resulted recordset to my application.

With SQL SERVER transact-sql I can have this :


CREATE TRIGGER [dbomyTable] ON myTable
FOR INSERT
AS
SELECT myColomn1, myColomn2 FROM INSERTED
GO

But BD2 triggers do not alloaw the use of cursors, so how can I obtain the same result in DB2 ?

Thanks

@+