Missing columns in trigger text in data tools
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.
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
DATA CAPTURE NONE
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!');
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.
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 126.96.36.199 only.
|Software Development||Rational Application Developer for WebSphere Software||8.0.3, 8.0.4|
More support for:
Rational Developer for System z
Software version: 8.0.1, 8.0.2, 8.0.3, 188.8.131.52, 184.108.40.206, 220.127.116.11, 8.5, 18.104.22.168
Operating system(s): Linux, Windows, z/OS
Reference #: 1612231
Modified date: 23 October 2012