Re: Files used by SQL in RPGLE

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 06/13/2016 02:34:25
PM:

----- Message from Darren Strong <darren@xxxxxxxxx> on Mon, 13 Jun
2016 14:34:07 -0400 -----

To:

"RPG programming on the IBM i \(AS/400 and iSeries\)"

<rpg400-l@xxxxxxxxxxxx>

Subject:

Re: Files used by SQL in RPGLE

I like to use external data structures with a 'qualified template' to

give

me fields to reference for my cursor fields. This makes sure that
DSPPGMREF picks it up, and gives me a nice way to have external fields
define my internal fields so they always match on the fetch.


So, it might look like this

D IIM_t E DS extname(IIM) qualified template
D C1 DS qualified
D Part like(IIM_t.IPROD)
D Qty like(IIM_t.IONH)

Is there new functionality since 7.1 to implement this? At 7.1 DSPPGMREF
does not show files referenced for defining a data structure by using
EXTNAME.

I've been contemplating entering an RFE asking IBM to report files used
this way in the output of DSPPGMREF. If it's already in 7.2 or 7.3, that
would be incentive for us to upgrade sooner than our current plans.

Michael Quigley
Computer Services
The Way International
www.TheWay.org