A few years ago on 7.1, i changed my system default from Java 6 to Java 7 and quite a few IBM things broke.
Like i said, that was several years ago, so YMMV.
________________________________________
From: broehmer@xxxxxxxxxxxxxxx [broehmer@xxxxxxxxxxxxxxx]
Sent: Friday, May 4, 2018 4:38 PM
To: Midrange Systems Technical Discussion
Subject: Java - 6
Have a question relating to Java on the system.
I'm at 7.1 and my (boss) wants to go ahead and
remove Java 6 on our development box and see what happens.
We've got 7 & 8 on it and while I realize that
when we move to 7.3 (next month) that won't matter but
his question is what's going to happen to our system now?
How much "stuff" relies on 6 and why can't we just move to 7 or 8?
Bill Roehmer
Senior Pgmr/Analyst
The C.D. Hartnett Company
817 594-3813 ext. 1631
"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments
accompanying it) contain confidential information belonging to the sender.
The information is intended only for the use of the intended recipient.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution or the taking of any action in reliance
on the contents of the information is strictly prohibited. Any
unauthorized interception of this transmission is illegal under the law.
If you have received this transmission in error, please promptly notify
the sender by reply e-mail, and then destroy all coTVpies of the
transmission."
From: Justin Taylor <JUSTIN@xxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 05/04/2018 01:06 PM
Subject: RE: Better SQL performance than SUBSTRING
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
That doesn't seem to work for me. The statement ran, but no object was
created.
Here's my statement:
create index MY_TABLE_SUBSTRING on table MY_TABLE
(SUBSTRING(MY_COLUMN,5,6))
Here's the message iACS gave me on the create:
SQL State: 01505
Vendor Code: 143
Message: [SQL0143] Statement CREATE INDEX AUXILIARY TABLE ignored. Cause .
. . . . : Statement CREATE INDEX AUXILIARY TABLE is not supported by DB2
for IBM i. It has been ignored. Recovery . . . : No action is
required.
Statement ran successfully, with warnings (6 ms)
IBMi 7.3, PTF's current as-of 07 Apr 18
iACS 1.1.7.3
-----Original Message-----
From: Steve Needles [mailto:Stephen.Needles@xxxxxxxxxxx]
Sent: Friday, May 04, 2018 10:09 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: RE: Better SQL performance than SUBSTRING
Yes...you can create an index using a substring:
CREATE INDEX Table_Index
ON Table
(substr(Column,case when length(trim(Column))-7 <= 0
then 1
else length(trim(Column))-6 end
, 7));
Generate a key using the last characters in the string no matter the total
length of the string
Steve Needles
--
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:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://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
"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments accompanying it) contain confidential information belonging to the sender. The information is intended only for the use of the intended recipient. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of the information is strictly prohibited. Any unauthorized interception of this transmission is illegal under the law. If you have received this transmission in error, please promptly notify the sender by reply e-mail, and then destroy all copies of the transmission."
midrange.com
