Re: Files used by SQL in RPGLE

Mark,
I did look at that, but if my SQL is dynamically prepared, it does not know
what files are used.
I think that I need to either include an "F" spec or external Ds to get the
reference for the files used.

Thanks

Jeff Young
Sr. Programmer Analyst

On Fri, Jun 10, 2016 at 12:54 PM, MARK GOLDEN <mark_golden@xxxxxxxxxxxxxxx>
wrote:

Hi John,
Try the PRTSQLINF command. See if that gives you what you need.
R,Mark.

On Friday, 10 June 2016, 15:38, "JRusling@xxxxxxxxxxx" <
JRusling@xxxxxxxxxxx> wrote:


Its what i do :-)

Should I include unused "F" specs, external DS? some other method that
will allow the files to be seen by a cross reference utility or

dsppgmref?

John
<br />
The information in this email is confidential and may be legally
privileged.
It is intended solely for the addressee. Access to this email by anyone
else is
unauthorized. If you are not the intended recipient, any disclosure,
copying,
distribution or any action taken or omitted to be taken in reliance on it,
is
prohibited and may be unlawful.
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.



--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.