Think perhaps you mean "joins that use the USING clause"...

I am not aware of any changes to outer joins...but joins using USING did change.

USING came out at v5r4, but it was implemented wrong. IBM fixed it at 6.1.


On Mon, Sep 17, 2012 at 1:19 PM, Jim Oberholtzer
<midrangel@xxxxxxxxxxxxxxxxx> wrote:

There's a little gem lost in most of the documentation and that is a
change that was made in DB/2 regarding outer joins. The only spot I
have seen customers have trouble with in a V5R4 to V7 upgrade is with
SQL statements that use certain kinds of joins. There are workarounds
but the best solution is to fix the SQL.

See the archives of Midrange-L for much more information as well as
IBM's web site, although good luck finding much out there.....

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects

On 9/17/2012 10:20 AM, rob@xxxxxxxxx wrote:
Many of you are preparing budgets for next year. I've got no dog in this
fight, but you may want to consider adding upgrading from V5R4 to your
budget. End of service for V5R4 is end of September of 2013.
You can get an extension but IBM will REALLY, REALLY rake you over the
coals financially for it. Besides, all that buys you is one year of delay
for a LOT of money.

I suggest you read the Memo to Users for both 6.1 and 7.1. Some items to
consider in your budgeting:
- Are you current with IBM software subscription?
- ANZOBJCVN. This may (almost guarantee WILL) affect some vendor
purchased software. If you're behind on your vendors versions of software
that are supported on 7.1 then there may be some serious costs including:
= Paying up back support
= Replacing the vendor if back support is too pricey or if they still
don't support 7.1, which has been out for 2.5 years now. We replaced a
few packages that we're dragging their feet on 6.1 versions when 6.1 first
came out. IBM gave them a year's notice on ANZOBJCVN prior to 6.1 and we
got tired of them milking maintenance for nothing.
= Training on the new version (or replacement) of your vendor software.
When we jumped from BPCS 405CD to LX 8.something we put everyone through
non software specific ERP training and then LX training. (Note: You can
get 405CD to work past V5R4 but it WILL require applying some BMRs.
- Domino:
- Hardware: Is all your hardware currently supported on something higher
than V5R4?
There are some cards etc which may need to be replaced. Including models
otherwise supported on these releases:
- Actually doing your OS upgrades. Some of you contract that out versus
doing it in house. IBM or your BP may provide you a quote on that.

Rob Berendt
-- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept
1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108
6928N 400E Kendallville, IN 46755
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page