For everyone, on my IBM i Reference Pages Blog, on the home page at the bottom,
there are 2 examples of this that can be copied and used as needed.
http://ibmireference.blogspot.com/
Respectfully,
Michael Mayer
IBM i on Power System Admin
ERMCO-ECI
2225 Industrial Rd
Dyersburg, Tennessee 38024
Office and OnCall: 731.676.4318
Cell: 518.641.8906
Email: michael.mayer@xxxxxxxxxxxxx
https://www.ermco-eci.com/
IBM i Personal Blog:
https://ibmireference.blogspot.com/
"Success is not final. Failure is not fatal. It is the courage to continue that counts".
4. Re: Firmware Updates (Jack Woehr)
------------------------------
message: 4
date: Wed, 28 Feb 2024 15:24:25 +0000
from: Jack Woehr <jack.woehr@xxxxxxxxxxx>
subject: Re: Firmware Updates
I think ya wanna take the stars off of *CONCAT*.
Jack Woehr
Independent Consulting Programmer
303-847-8442
jack.woehr@xxxxxxxxxxx
http://www.procern.com/
Stay Connected!
New Name. Same Great Service.
NON-DISCLOSURE NOTICE: This communication including any and all attachments is for the intended recipient(s) only and may contain confidential and privileged information. If you are not the intended recipient of this communication, any disclosure, copying further distribution or use of this communication is prohibited. If you received this communication in error, please contact the sender and delete/destroy all copies of this communication immediately.
________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of Rob Berendt <robertowenberendt@xxxxxxxxx>
Sent: Wednesday, February 28, 2024 7:59 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Firmware Updates
You can use the following (works better in iACS Run SQL Scripts) to really check your group ptfs.
It will actually compare what you have on your system with what is available at IBM.
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;
------------------------------
message: 5
date: Wed, 28 Feb 2024 15:27:07 +0000
from: Rich Loeber <rich@xxxxxxxxx>
subject: Function Usage Control from ACS
When I use the WRKFCNUSG command from the command line, I see a list of functions that I can review. When accessing function usage from ACS, the list is much smaller. For example, the QIBM_QTMF* functions do not show.
I see articles on the web that seem to indicate that this was available in the old Navigator but I'm not finding it in ACS. What am I missing?
Rich
------------------------------
Subject: Digest Footer
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest 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.
------------------------------
End of MIDRANGE-L Digest, Vol 23, Issue 168
*******************************************
midrange.com
