Re: Bug affecting DSPPGMREF

Jeffrey,

In a message dated 98-04-13 12:07:46 EDT, you write:

> We discovered this bug during our Y2K analysis.  We couldn't see ref's to 
> DTAARA's when running DSPPGMREF against CL pgm's compiled on our V3R7 system
> to release V3R1. Thought I'd pass it along.  It is fixed with PTF SF43359 (
> and a recompile of effected programs!). 
<<snip>>

Thanks for the reminder!  We received a PTF for SQL under V3R2 last week for a
problem discovered at my client (thanks to Todd Hansen in Rochester for his
_excellent_ service with this problem BTW, even if the client _DOES_ think
that patches to the database handlers ought to have a two-day turnaround
;-)!).  I'm not sure what exactly caused the problem (wasn't privy to the
cover letter), but SF47251 corrects a problem one of our developers
experienced joining a large file to a small one with select and sort criteria.
The query ran for a _LONG_ time and finally terminated with a machine error
(MCH0601?).  The problem manifested itself under both SQLRPG and interactive
SQL.  The query still runs like a dog, but no longer blows up!

Regards!

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@aol.com

"If people don't want to come out to the ball park, nobody's going to stop
them." -- Yogi Berra
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---