RE: SQL objects last used....

Default is in a folder up from the folders where you save your emulator configs. Its named "..\RunSQLScripts\Examples". You can move that location in the properties file be changing the property named "com.ibm.iaccess.SQLCustomExamples" (at least in 1.1.8.1, good reason to update).

-Matt

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Robert Rogerson
Sent: Tuesday, March 5, 2019 2:24 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: SQL objects last used....

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.co
m_mailman_listinfo_midrange-2Dl&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwol
PvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=cV4NW
DRMF8Bujj2SjnSTeb5Ug9mUiFxcfwVHZnOx898&s=kGd9OPFnXzlo5qix6vu7__4RPTH-f
JpjbaqdKLTiEFU&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.c
om&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8
HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=cV4NWDRMF8Bujj2SjnSTeb5Ug9mUiFxcfw
VHZnOx898&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://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.co
m_mailman_listinfo_midrange-2Dl&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwol
PvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=febkP
XqBQMdAoZlp5l3KWQ7iax-sdzZFK8apjTEd9LE&s=W22XkI7I6z3WeAuJLr0GfOlqtwrPI
eNAn8wvjpbVfjU&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=febkPXqBQMdAoZlp5l3KWQ7iax-sdzZFK8apjTEd9LE&s=pB67LiRfNDLKTd1jdsMatbuza9Oe9TlGOKsbknNwaPE&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.c
om&d=DwIGaQ&c=2S-2xx8Cum_thMfWs-kOOHQTwolPvSZ4PFLhr1wDDGs&r=wgq2KO1Tl8
HswJht2RKpmz7qvL2YDU_M-VhnRH6r43I&m=febkPXqBQMdAoZlp5l3KWQ7iax-sdzZFK8
apjTEd9LE&s=u9X4xpbp7jD-ysPf0z8QwDffCyLWwJ60-pmDJZkdCNI&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://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=febkPXqBQMdAoZlp5l3KWQ7iax-sdzZFK8apjTEd9LE&s=W22XkI7I6z3WeAuJLr0GfOlqtwrPIeNAn8wvjpbVfjU&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=febkPXqBQMdAoZlp5l3KWQ7iax-sdzZFK8apjTEd9LE&s=pB67LiRfNDLKTd1jdsMatbuza9Oe9TlGOKsbknNwaPE&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=febkPXqBQMdAoZlp5l3KWQ7iax-sdzZFK8apjTEd9LE&s=u9X4xpbp7jD-ysPf0z8QwDffCyLWwJ60-pmDJZkdCNI&e=