Re: 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 #6

Back to ibm.software.db2.mvs Previous Next

From: Andreas Lederer
Date: Mon, 14 Oct 2002 10:01

35 lines
2737 bytes

PM (pm3iinc-nospam) schrieb:
> My gut feeling (bow in the dark)
> 
> DDL of GTS03.TG_SYNCTESTGCT can't fit the Command column vs varchar(3000).
> or
>  try the tec_synca1 in a 32k TS.
> 

The definition of the command column in GCT is long varchar and there 
are no problems when i use a trigger like:

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',new.A_VARCHAR || new.A_VARCHAR,0,0,0);

but when i use

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',new.A_VARCHAR || old.A_VARCHAR,0,0,0);

i get the same error message as in my first posting.

tec_synca1 is only a testtable. i know that it will work if i move it to
a 8k tablespace but this can't be done with the tables i use in production.

the question is why db2 limits the size of transition variables to the 
size of the tec_synca1 ts.

is there a solution to bypass this limitation??

thanks
andreas lederer

Technical Details

Message-ID: <3DAA95F5.7050107@tecco.at>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news.tele.dk!small.news.tele.dk!195.54.122.107!newsfeed1.bredband.com!bredband!news01.chello.se!newsrouter.chello.at!newsfeed01.univie.ac.at!e-post.inode.at!not-for-mail

References: <3da6c1d4$1@e-post.inode.at> <QfCp9.20123$ZO1.1245738@news20.bellglobal.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10da59,be16106c701a8ac5
X-Google-Attributes: gid10da59,public
X-Google-Thread: f675e,be16106c701a8ac5
X-Google-Attributes: gidf675e,public
X-Google-Thread: 10f47b,be16106c701a8ac5
X-Google-Attributes: gid10f47b,public
X-Google-ArrivalTime: 2002-10-14 03:01:27 PST
Message-ID: <3DAA95F5.7050107@tecco.at>
Date: Mon, 14 Oct 2002 12:01:25 +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
To: "PM (pm3iinc-nospam)" <Pm3iinc.NoSpam@sympatico.ca>
Subject: Re: How to resolve slqerror -1424 too many references to transition
 variables and transition table columns or the row....
References: <3da6c1d4$1@e-post.inode.at> <QfCp9.20123$ZO1.1245738@news20.bellglobal.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 62.99.185.90
X-Trace: e-post.inode.at 1034589701 62.99.185.90 (14 Oct 2002 12:01:41 +0200)
Lines: 36
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news.tele.dk!small.news.tele.dk!195.54.122.107!newsfeed1.bredband.com!bredband!news01.chello.se!newsrouter.chello.at!newsfeed01.univie.ac.at!e-post.inode.at!not-for-mail

Reply to Parent Message