Re: SQL Table Usage in programs

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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