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