Problems with Query on V4R5

[rbaird@xxxxxxxxxxxxxxxxxxxxx]

Hey all,

Whilst searching through the archives, I came across the following message.

my employer has a client who is experiencing the exact same problems.

they just applied hypers, cumes, etc. on a V4R5 box, and several querys
that ran before suddenly are blowing up:

Message ID . . . . . . :   MCH1210       Severity . . . . . . . :   40
Message type . . . . . :   Escape
Date sent  . . . . . . :   05/01/02      Time sent  . . . . . . :
12:48:59
Message . . . . :   Receiver value too small to hold result.

------
our guy in charge of this is currently putting out another fire and is
unavailable, so I'm just trying to do a little leg work for him.

I've searched the apars and ptf cover letters at ibm support, to no avail.

does anyone have any info on why


----original message----
Re: Problems with Query on V4R5

---------------------------------------------------------------------------
Subject: Re: Problems with Query on V4R5
From: MWalter@xxxxxxxxxxxxxxx
Date: Thu, 14 Jun 2001 13:10:31 -0400

---------------------------------------------------------------------------

Be sure you have the latest DB PTF's applied. We too had some queries that
run every day. All of the sudden, a query bombs with some kind of strange
pointer error. The object description of the QRYDFN says that the object
hasn't been changed since we restored it from our upgrade a year ago. The
files are open order header and detail files so I know they didn't change.
The real funny thing is that the next day, without any changes, the query
ran fine.  I called tech support and they told me about the latest DB
PTF's. I thought I had them on but IBM must be changing them like
underwear. It's a full time job keeping up with the fixes and patches
between OS/400, DB2, Domino, and WDT400. I really feel for shops that have
more than one system.

Ok, rant over for today.




Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040