RE: SQL between V7R1 and V7R3

Depending on how the test system was created, this sound like a DB/2 indexing issue to me. Are there SQL packages that did not restore properly in the P8 test environment? Is the test running with debug turned on so you can see the diagnostics, I'm guessing not due to your comments about the lack of messaging. Turn on DEBUG.

Look for the thread that just concluded a couple of days ago regarding DB/2 index creation. Also, assuming the systems to be under software maintenance, a call to IBM might help you figure out what's going on.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Luis Rodriguez
Sent: Wednesday, December 14, 2016 7:15 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL between V7R1 and V7R3

As always, check out the appropriate Memo to users documents. On your case, check the docs corresponding to 7.2 and 7.3.

Also, check out IBM's Developers works site, in particular the modifications introduced in the different TRs (Technology Refreshes) applicable to your OS level.

HTH,

Luis

Sent from my Moto G phone. Please excuse my brevity.

On Dec 14, 2016 9:08 AM, "福田勉" <tufukuda@xxxxxxxxx> wrote:

Hi.

We have been used IBM i7.1(V7R1) , and we have a plan to upgrade into
V7R3 on new machine(Power8) next year.

We tested our batch program which is written SQLCBL on V7R3 as pre-test.

But it was failed because of the reason as follows.

NO.1

One cobol program ran over 8hours.(It have been run on V7R1
within 20minute every day.) .
NO.2

Error on run because of SQL-ambiguous(SQL0203).
(I do not attach error message bacause it is written by japanese)

->No messeges were produced when compiling of them.
They have been run normal on prod(V7R1) without trouble everyday.


Does anyone know about change-point about SQL between V7R1 and V7R3.

Does SQL-engine have been changed Significantly?

I would like to know some document and web-site to resolve it.


With Best Regards.

Tsutomu Japan.
--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD