Re: SQL on 4.3 doubling up result set.

I am upgrading a v4r2 to v4r3. The current CUM requires that another PTF be
ordered and applied first! (WHY DIDN'T IBM JUST SEND IT!!, How MS can you get).

Anyway, the reqired PTF described your situation, but I canot find the info at
AS400SERVICE, and the paperwork is at the clients. I will respond monday if 
noone
else has.
bob

Pete Hall wrote:

> At 13:27 07/09/1999 , John Bussert wrote:
> >The physical file does not have duplicates.  This is definitely an SQL
> >result set "work file" problem.  There are no joins, it even returns two
> >records on a count(*) select.  We have found dozens of SQL based PTF's (on
> >top of PTF's) that we are going to try, but it is pretty darn scary that
> >something like this can happen.  It's almost like dealing with Microsoft...
> >Yikes!
>
> Well, I wouldn't go that far, but it has been a little buggy since the new
> hashing algorithm was added. We push SQL pretty hard these days, and had a
> lot of trouble. It finally appears to have become stable within the last
> two weeks. Be certain that you have the database PTFs installed, as well as
> the current cume and hypers. You can do a lot more strange things with a
> single SQL command than you could ever think about with RPG. Consequently,
> processing has become a lot more complex. The good news is that IBM is
> turning out some really efficient code and cool features. The bad news is
> that if you are a heavy user, you are probably doomed to have problems
> periodically when new features are added. I don't believe it is possible to
> completely test all possible combinations/uses.
> Pete Hall
> pbhall@execpc.com
> http://www.execpc.com/~pbhall
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@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
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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
+---