Re: Anybody know if there's a v5r4 PTF that corrects the results when doing a JOIN with the USING clause?

Searching the ptf database for just 5.4 ptf's shows 250 hits with both
words JOIN and USING.
http://www-912.ibm.com/a_dir/as4ptf.nsf/as4ptfhome


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From:   Charles Wilt <charles.wilt@xxxxxxxxx>
To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:   02/17/2010 03:00 PM
Subject:        Anybody know if there's a v5r4 PTF that corrects the
results when    doing a JOIN with the USING clause?
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



All,

At 6.1, IBM corrected behavior of the USING clause such that

select * from table1 join table2 using (KEYFLD1, KEYFLD2)

contained only one copy of KEYFLD1, KEYFLD2 fields in the results set
instead of one from each file.

Does anybody know if they PTF'd this back to v5r4 where USING was
introduced?

Thanks!
Charles
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.