If you have ACS RSS installed there are examples (menu Edit -> Insert from Examples). Search for lateral and at 1.1.8.x there is an example using OBJECT_STATISTICS but as the primary driver for the query. You might be able to adapt your query. The example I suggest is the one named "Find objects in a library, not included in an authorization list". Looks like you should be able to replace the QSYS2.AUTHORIZATION_LIST_INFO view with SYSPROCS view easily. I know its not exactly what you wanted but I don’t have an actual example.
-Matt
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Robert Rogerson
Sent: Tuesday, March 5, 2019 1:17 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: SQL objects last used....
Hi all,
If I run these two queries
SELECT specific_schema, specific_name, external_name
FROM sysprocs
WHERE specific_schema = ('QS36F')
AND SPECIFIC_NAME = 'ADDSTOREZONE';
Which returns
SPECIFIC_SCHEMA SPECIFIC_NAME EXTERNAL_NAME
QS36F ADDSTOREZONE QS36F/ADDST0001
And then feed it to the table function
SELECT *
FROM TABLE(QSYS2.OBJECT_STATISTICS('QS36F', '*PGM',
OBJECT_NAME => 'ADDST00001')) A;
I can get the last used date for the sql procedure.
Before I go reinventing the wheel has anyone else done a similar query
that could be posted?
Thanks,
Rob
--
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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_midrange-2Dl&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=cV4NWDRMF8Bujj2SjnSTeb5Ug9mUiFxcfwVHZnOx898&s=kGd9OPFnXzlo5qix6vu7__4RPTH-fJpjbaqdKLTiEFU&e=
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_midrange-2Dl&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=cV4NWDRMF8Bujj2SjnSTeb5Ug9mUiFxcfwVHZnOx898&s=qsfnKEOFaLqH1J2OKg9xHyOyRsDK2al3u9-eYAt5Tx0&e=.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://urldefense.proofpoint.com/v2/url?u=https-3A__amazon.midrange.com&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=cV4NWDRMF8Bujj2SjnSTeb5Ug9mUiFxcfwVHZnOx898&s=KlReo9ZjG6Kxhpz-plPRQuCDtzJMkVICzGfZrmBj3HY&e=
midrange.com
