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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Yeah, I'm afraid JOIN and USING are too common.  None of the abstracts
look promising and doing an exact match on using USING CLAUSE didn't
return anything.

Thus my question to the list....

Charles

On Wed, Feb 17, 2010 at 3:16 PM,  <rob@xxxxxxxxx> wrote:
> 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.