All rows are triggered using 'WHEN' and 'WHERE' with database triggering

Technote (troubleshooting)


Problem(Abstract)

All database table rows are triggered using 'WHEN' and 'WHERE' clauses using WebSphere® Transformation Extender (WTX) database triggering, even those that do not match the 'WHEN' clause.

Symptom

All rows triggered in tatabase instead of when a particular field has a value specified in the 'WHEN' clause.


Cause

All database table rows are triggered instead of only when a particular field has a value specified in the 'WHEN' clause.

Environment

Using database triggering with IBM WebSphere Transformation Extender (WTX) database adapters.

Diagnosing the problem

The WTX database trace log file shows that all rows are being triggered.

Resolving the problem

The 'WHEN' clause needs to be altered to : column condition new.FIELDNAME='VALUE'



...where 'new.' is a static entry, regardless of the actual tablename.


Product Alias/Synonym

Mercator Ascential DataStage TX

Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Transformation Extender
Database Adapter

Software version:

8.3.0.0, 8.3.0.1, 8.3.0.2, 8.3.0.3, 8.3.0.4, 8.3.0.5, 8.4.0.0, 8.4.0.1, 8.4.0.2, 8.4.0.3

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Linux zSeries, Solaris, Windows

Reference #:

1637168

Modified date:

2013-05-22

Translate my page

Machine Translation

Content navigation