Re: Check PTFs currency (up-to-date-ness)

IBM is positive that the issue is on the back end site it's going out to.
I understand what you are saying - how can that be when it works for your
versions.
However, maybe IBM added new columns or something in the examples and
someone refreshed the back end site and dropped the new columns. IDK.
Maybe because I am using 7.5 and something is malformed in the XML at that
site for a 7.5 entry. Again, IDK.

My example looks like:
(just the failing one, not the STRSQL example)
With iLevel(iVersion, iRelease) AS
(
select OS_VERSION, OS_RELEASE from sysibmadm.env_sys_info
)
SELECT P.*
FROM iLevel, systools.group_ptf_currency P
WHERE ptf_group_release =
'R' *CONCAT* iVersion *CONCAT* iRelease *concat* '0'
ORDER BY ptf_group_level_available -
ptf_group_level_installed DESC;

On Wed, Nov 1, 2023 at 9:59 AM Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
wrote:

I just ran the ACS Run SQL Scripts (1.1.9.0) V7R3 version with DB2 group
32 and it works fine.
Errors introduced in later updates?

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On Wed, Nov 1, 2023 at 8:36 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

Joe,
Which one are you using from that example? There are two. You pasted
both. The first one is the one having issues. The second one is

working.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.