RE: Retrieving numeric partition ID in SQL

Well, bloody hell.  I coulda sworn I looked at QSYS2.SYSTEM_STATUS_INFO before and didn't find the partition ID.  I knew it had the partition name, but ...

<sigh>

This sure beats the other technique I posted several minutes ago on simplicity!  Thanks Michael!

- Dan Bale

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org> On Behalf Of Michael Mayer via MIDRANGE-L
Sent: Thursday, July 30, 2026 8:59 AM
To: [email protected]
Cc: Michael Mayer <michael.mayer-Cdy/[email protected]>
Subject: Retrieving numeric partition ID in SQL

Dan, try this .... I think this gets you what you want.
If not - I tried!
MM

SELECT
  (SELECT VARCHAR(CURRENT_CHARACTER_VALUE, 10)
   FROM QSYS2.SYSTEM_VALUE_INFO
   WHERE SYSTEM_VALUE_NAME = 'QSRLNBR') AS SERIAL_NUMBER,

  (SELECT VARCHAR(CURRENT_CHARACTER_VALUE, 10)
   FROM QSYS2.SYSTEM_VALUE_INFO
   WHERE SYSTEM_VALUE_NAME = 'QMODEL') AS SYSTEM_MODEL,

  (SELECT VARCHAR(CURRENT_CHARACTER_VALUE, 10)
   FROM QSYS2.SYSTEM_VALUE_INFO
   WHERE SYSTEM_VALUE_NAME = 'QPRCFEAT') AS PROCESSOR_FEATURE,

  PARTITION_ID
   FROM QSYS2.SYSTEM_STATUS_INFO;

Respectfully,
Michael Mayer
IBM i on Power System Admin
INFOR LN Jr ERP Admin
ERMCO-ECI
*** CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender. ***
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.

You can help support midrange.com by visiting https://donate.midrange.com and making a contribution.