Re: SQL Table Usage in programs

On Sep 27, 2021, at 11:08 PM, Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx> wrote:

Jon

When you say you don't think it has happened, do you mean that DSPPGMREF doesn't show the usage? I saw a similar post in Scott's new site about this, related to ABSTRACT.

So I looked at a program of mine with a bunch of embedded SQL - the usage is all there in DSPPGMREF - now these are all things like DELETE and DECLARE CURSOR used directly in EXEC SQL, not prepared from a variable.

I don't know if it resulted from an RFE - I should know, I was probably there, right? :)

<tmi>
I did find a recent RFE #149604 for adding procedure and function usage - seems it was just recently delivered. There was also RFE#131040 for some dependency stuff delivered Fall 2020.

I also see #102402, "Create SQL Service that produces a list simliar tp dsppgmref", submitted in 2017 - I see I put in a private comment, in March this year, that it didn't look like anything happened, and there is a comment from IBM, same day, about a view, QSYS2.SYSPROGRAMSTMTSTAT, and a table function, QSYS2.PARSE_STATEMENT. The person who entered the comment said the details were not in the original comment about the update, so I don't know when those came out as the deliverables that provided what the RFE asked for - have to look at the IBM services web page, I guess.

Looks like SYSPROGRAMSTMTSTAT was around at 7.1, at least. PARSE_STATEMENT looks like it appeared at 7.2.
</tmi>

Cheers, mates!
Vern

On 9/27/2021 6:36 PM, Jon Paris wrote:

I honestly don't recall Karl - probably three or four years.


Memory ain't what it was!


Jon

On Sep 27, 2021, at 6:03 PM, Karl Haggart <karl.haggart@xxxxxxxxxxxxxxxxxx> wrote:

Hi Jon,

I just did a quick look through of the open RFE's and couldn't find it, but I like the idea.

How far back did you think it was raised?

Thanks,
Karl.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jon Paris
Sent: Monday, September 27, 2021 2:56 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: SQL Table Usage in programs

I have a vague memory of there being an RFE requesting that IBM add tables used in embedded SQL to the DSPPGMREF data.

Anyone know anything about that? I can't find the RFE and it doesn't;t seem to have happened so ...

Hopefully someone else's memory is better than mine ...


Jon Paris
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com
--
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@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

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

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

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