Re: Dynamic Sql - -661 Errors

I was one of the first to report it in 11.50.xC2. There is a work around I found: Add an extra variable to the LET statement or RETURNS clause in the CALL statement. The stack header reports that there are one more returning variable than the function is actually returning. If you turn on trace you can see the extra return value (which is NULL) on the stack. I also thought that this was fixed in .xC4. If not, open a case with IBM and send them the TRACE output. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Jun 15, 2010 at 11:01 AM, Plugge, Joe R. <JRPlugge@west.com> wrote: > Has anybody else out there run into this bug? I am running 11.50.FC6 on > AIX 5.3 TL11. Case open with IBM for months now, no resolution. > > The APAR says it was fixed, but it is not and I can reproduce it at will. > > > Joe Plugge > > > > **************************************************************** > * * USERS AFFECTED: * > * * IDS 11.10 and 11.50 users * > * **************************************************************** > * * PROBLEM DESCRIPTION: * > * * In some cases the let statement inside the procedure which * > * * is using the dynamic spl feature can give the -661 error * > * **************************************************************** > * * RECOMMENDATION: * > * * Upgrade to IDS 11.50.xC5 and above. * > * **************************************************************** > > Problem conclusion > * Problem first fixed in IDS 11.50.xC4. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >