Missing columns in trigger text in data tools

Technote (troubleshooting)


Problem(Abstract)

There is data missing from trigger body in SQL editor or Properties view in IBM Rational Application Developer (RAD) and Rational Developer for System z.

Symptom

You note missing data from trigger body in SQL editor or Properties view

More specifically there is a rare case where the trigger body is missing a column in the "UPDATE OF" clause.

Firstly only "UPDATE" Triggers are affected since you can only specify columns for the "UPDATE OF <column>" clause. Also since to "OF <column>" clause of the ddl is optional not all UPDATE triggers are affected by this.

Secondly this can only occur if the schema or table name specified in the "ON <table name>" clause of the ddl contains the following string "ON".

Example of this "ON ADMF001.TELEPHONE" The "ON" in TELEPHONE causes a problem with the parsing.

Here is another example of the table that will cause the issue.

CREATE TABLE "ADMF001"."ON" (
"COL1" SMALLINT NOT NULL,
"ON" CHAR(5) FOR SBCS DATA WITH DEFAULT NULL
)
PARTITION BY SIZE EVERY 4 G
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC;

 CREATE TRIGGER RE.SL_TRI_TRIGGER01 AFTER UPDATE OF COL1,ON ON ON
 REFERENCING NEW AS NEWROW
 FOR EACH ROW MODE DB2SQL
 WHEN ( 1 <= (SELECT COUNT(*) FROM RE.TrigC WHERE Col1 = NEWROW.Col1) )
 SIGNAL SQLSTATE '75000' ('Exceeds the cardinality upper bound!');

Cause

This has been identified as a product defect which is being tracked as APAR PM73670 under Rational Application Developer for System z.

There was a parsing error in the data tools component.


Environment

RAD v8.0.3x, RAD v8.0.4, RD/z v8.0.1, RD/z v8.0.2, RD/z 8.0.3, RD/z v8.5

Diagnosing the problem

Check if the schema or table name specified in the "ON <table name>" clause of the ddl contains the following string "ON".

Example of this "ON ADMF001.TELEPHONE" The "ON" in TELEPHONE causes a problem with our parsing.


Resolving the problem

Contact IBM Rational Client Support to obtain the official patch to work around the issue.

An official patch is available for RDz 8.0.3.1 only.


Cross reference information
Segment Product Component Platform Version Edition
Software Development Rational Application Developer for WebSphere Software 8.0.3, 8.0.4

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Developer for System z
General Information

Software version:

8.0.1, 8.0.2, 8.0.3, 8.0.3.1, 8.0.3.2, 8.0.3.3, 8.5, 8.5.0.1

Operating system(s):

Linux, Windows, z/OS

Reference #:

1612231

Modified date:

2012-10-23

Translate my page

Machine Translation

Content navigation