Re: SQL objects last used.... -- MIDRANGE-L

Thanks Matt and Rob.

I recall recently that someone mentioned that perhaps we could save the type of queries somewhere on the internet so that everyone had access.

Was it ever decided where? Perhaps I can add Rob's query if he doesn't mind.

Rob

On 3/5/2019 4:16 PM, Rob Berendt wrote:

Good idea Matt, kind of where I started.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Tyler, Matt
Sent: Tuesday, March 5, 2019 4:00 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: SQL objects last used....

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=
--
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@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com