Help with Oracle to DB2 trigger translation

[gimme_this_gimme_that]

I'm new to DB2 and our team is in the process of
migrating from Oracle to DB2.

Assuming new.created_date is now a TIMESTAMP,
what would be the DB2 translation of this Oracle
trigger?

Thanks.

CREATE OR REPLACE TRIGGER "BZ".atable_created_date
BEFORE INSERT ON atable
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
BEGIN
SELECT sysdate INTO :new.created_date
FROM DUAL;
END;
/

[Serge Rielau]

gi*******************@yahoo.com wrote:

I'm new to DB2 and our team is in the process of
migrating from Oracle to DB2.

Assuming new.created_date is now a TIMESTAMP,
what would be the DB2 translation of this Oracle
trigger?

Thanks.

CREATE OR REPLACE TRIGGER "BZ".atable_created_date
BEFORE INSERT ON atable
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
BEGIN
SELECT sysdate INTO :new.created_date
FROM DUAL;
END;
/

CREATE TRIGGER "BZ".atable_created_date
BEFORE INSERT ON atable
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN ATOMIC
SET NEW.created_date = CURRENT DATE;
END
@

If you are on a version prior to DB2 V8.2 you need to use:
_NO_CASCADE_ BEFORE and also add _MODE_DB2SQL_ after FOR EACH ROW

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab