1-Define the other systems with ADDRDBDIRE or WRKRDBDIRE
2-Select * from systemX.library.table
You will have to issue a SQL CONNECT command and provide credentials or use command ADDSVRAUTE to store password
HTH
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Robert Wenzel
Sent: Monday, November 2, 2020 11:35
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Subject: Gathering Object Statistics Across LPARs
Caution: This email originates from outside of Fresche | Attention: Ce message provient de l'extérieur de Fresche
We have four LPARs. One contains our source repository and test databases/schemas. The other LPARs contains databases and program objects deployed from the source LPAR.
I am writing an SQLRPGLE program to create an Obsolete Objects table for review and potential retirement from our source repository.
I need to be able to gather the object statistics (more specifically the Last Used Date of objects) from the other three LPARs while residing on the source repository LPAR.
Anyone know how I can get Object Statistics from another LPAR while resident on another LPAR?
I can run this SQL statement on the local LPAR but cannot figure out how to get this data from LPAR2, LPAR3 and LPAR4 while I am on LPAR1.
Any suggestions other than populating an output file on each LPAR separately and then combining later?
select objname, date(Last_used_timestamp) as LastUsedDate, objtext from table (QSYS2.OBJECT_STATISTICS('LIBRARY','*PGM') ) AS X order by objname ;;
--
*Robert Wenzel, Software Engineer*
iSeries Applications Support and Development
[image: Inmar]
<
https://www.inmar.com/?utm_source=email%20signature&utm_medium=email&utm_campaign=Associate%20Email%20Signature&utm_content=Inmar%20Logo>
robert.wenzel@xxxxxxxxx
635 Vine Street, Winston Salem, NC 27101
*p: 336-770-3478*
www.inmar.com
<
https://www.inmar.com/?utm_source=email%20signature&utm_medium=email&utm_campaign=Associate%20Email%20Signature&utm_content=URL%20link>
| LinkedIn <
https://www.linkedin.com/company/inmar> | Facebook <
https://www.facebook.com/inmarinc> | Twitter <
https://twitter.com/inmarinc>
--
********************************************
*Inmar Confidentiality
Note*: This e-mail and any attachments are confidential and intended to be viewed and used solely by the intended recipient. If you are not the intended recipient, be aware that any disclosure, dissemination, distribution, copying or use of this e-mail or any attachment is prohibited. If you received this e-mail in error, please notify us immediately by returning it to the sender and delete this copy and all attachments from your system and destroy any printed copies. Thank you for your cooperation.
*Notice of Protected Rights*: The removal of any copyright, trademark, or proprietary legend contained in this e-mail or any attachment is prohibited without the express, written permission of Inmar, Inc. Furthermore, the intended recipient must maintain all copyright notices, trademarks, and proprietary legends within this e-mail and any attachments in their original form and location if the e-mail or any attachments are reproduced, printed or distributed.
********************************************
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
Confidentiality Warning/Avertissement de confidentialité:
This message is intended only for the named recipients. This message may contain information that is privileged or confidential. If you are not the named recipient, its employee or its agent, please notify us immediately and permanently destroy this message and any copies you may have. Ce message est destiné uniquement aux destinataires dûment nommés. Il peut contenir de l'information privilégiée ou confidentielle. Si vous n'êtes pas le destinataire dûment nommé, son employé ou son mandataire, veuillez nous aviser sans tarder et supprimer ce message ainsi que toute copie qui peut en avoir été faite.
midrange.com
