#14260: DB2 iSeries -> Extract Triggers -> Condition clause missing from extraction/scripting

ivangron reported 2016-02-05T15:08:25Z · niraj.pandey(*) last modified 2016-02-11T12:00:07Z

DB2 iSeries -> Extract Triggers -> Condition clause missing from extraction/scripting

Dev	ivangron
QA	NielsGron

Priority	Low
Complexity	Unknown

Component	DB - DB2 iSeries
Version	17.0

Need to extract and script the action condition clause in triggers.

1 attachment

Verified 14260 ADS 17.0.3.png

2016-02-11T12:00:07Z

38 KB

All Comments (4) Change History

ivangron 2016-02-05T15:53:04Z

Extraction for data was already present. We are now assigned the action condition value to the trigger object and scripting its WHEN clause accordingly.

ivangron 2016-02-05T15:53:43Z

here is a simple example that can be used to test:

CREATE TABLE TABLEA (A INT, B VARCHAR(25))

CREATE TABLE ABLEB (A INT, B VARCHAR(25))

CREATE TRIGGER RIGGERA

AFTER INSERT ON TABLEA

REFERENCING NEW AS NR

FOR EACH ROW MODE DB2SQL

WHEN (NR.B IN ('9999992')) BEGIN

INSERT INTO TABLEB VALUES (NR.A, NR.B);

END

SachinPrakash 2016-02-11T00:06:20Z

Tariq says this issue can be marked as closed

niraj.pandey(*) 2016-02-11T11:59:55Z

Verified in ADS 17.0.3. Please refer screen shot (Verified 14260 ADS 17.0.3.png)

Search Tips

Aqua Data Studio / nhilam

DB2 iSeries -> Extract Triggers -> Condition clause missing from extraction/scripting

1 attachment

Issue #14260

Completion

Search Tips

Aqua Data Studio / nhilam

Title

DB2 iSeries -> Extract Triggers -> Condition clause missing from extraction/scripting

1 attachment

Issue #14260

Completion