RE: SQL on 4.3 doubling up result set.

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
+---