How to resolve slqerror -1424 too many references to transition variables and transition table columns or the row....

Article View: ibm.software.db2.mvs

Article #4

Back to ibm.software.db2.mvs Previous Next

From: Andreas Lederer
Date: Fri, 11 Oct 2002 12:19

32 lines
2437 bytes

hallo!

i have a simple table:
create table tec_synca1(a_key integer not null, a_varchar varchar(3000), 
primary key(a_key));

i have created this table in a 4kB tablespace.

now i want to create a trigger with:
CREATE TRIGGER GTS03.TG_U_GTS03_TEC0003 AFTER UPDATE ON GTS03.TEC_SYNCA1 
REFERENCING OLD AS OLD NEW AS NEW  FOR EACH ROW MODE DB2SQL   INSERT 
INTO GTS03.TG_SYNCTESTGCT (tabname, command, retkey, commitet, fetched) 
VALUES ('GTS03.TEC_SYNCA1',(case when (new.A_VARCHAR<>old.A_VARCHAR) 
then ('hhhhh') else ('') end),0,0,0);

which leads to the following error:

ERROR: -1424:  54040 : [IBM][CLI Driver][DB2/NT] SQL1424N  Zu viele 
Verweise auf Uebergangsvariablen und Spalten in Uebergangstabellen oder 
die Zeilen dieser Verweise sind zu lang. Ursachencode: "2".LINE 
NUMBER=1.  SQLSTATE=54040

Ursachencode: "2" means: sum of the lengths of the references exceeds 
the maximum length of a row in a table.

the table tg_synctestgct is on a 32kB tablespace.

how can i resolve this problem?
i need the comparison of old and new value!

thanks
andreas lederer

Technical Details

Message-ID: <3da6c1d4$1@e-post.inode.at>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!newsfeed.stanford.edu!news.tele.dk!small.news.tele.dk!151.189.0.75!newsfeed.arcor-online.net!newsfeed.r-kom.de!newsfeed.completel.de!news.netway.at!newsfeed01.univie.ac.at!e-post.inode.at!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10da59,be16106c701a8ac5,start
X-Google-Attributes: gid10da59,public
X-Google-Thread: f675e,be16106c701a8ac5,start
X-Google-Attributes: gidf675e,public
X-Google-Thread: 10f47b,be16106c701a8ac5,start
X-Google-Attributes: gid10f47b,public
X-Google-ArrivalTime: 2002-10-11 05:19:41 PST
Date: Fri, 11 Oct 2002 14:19:26 +0200
From: Andreas Lederer <andreas@tecco.at>
Reply-To:  Andreas.Lederer@tecco.at
User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.1) Gecko/20020826
X-Accept-Language: German/Austria, de-AU, en
MIME-Version: 1.0
Newsgroups: ibm.software.db2.mvs,comp.databases.ibm-db2,bit.listserv.db2-l
Subject: How to resolve slqerror -1424 too many references to transition variables
 and transition table columns or the row....
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 62.99.185.90
Message-ID: <3da6c1d4$1@e-post.inode.at>
X-Trace: e-post.inode.at 1034338772 62.99.185.90 (11 Oct 2002 14:19:32 +0200)
Lines: 33
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!newsfeed.stanford.edu!news.tele.dk!small.news.tele.dk!151.189.0.75!newsfeed.arcor-online.net!newsfeed.r-kom.de!newsfeed.completel.de!news.netway.at!newsfeed01.univie.ac.at!e-post.inode.at!not-for-mail