Re: More fun with native RLA on an SQL view

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Sorry, missed the part about OPM RPG (long time, no see :-) )

Even so, you can rename the field inside an old RPG program. The I spec is
something like this:

FMT **   ...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6
0032.01      I              TENCHRNAME                      SIXCHR

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Tue, Apr 20, 2010 at 11:48 AM, James H. H. Lampert <
jamesl@xxxxxxxxxxxxxxxxx> wrote:

> Luis Rodriguez wrote:
> > Regarding long names in SQL, they always have a "short name" version for
> use
> > in laguages like CL and/or RPG. If you run a DSPFFD against the SQL
> table,
> > you should see the short version. For example, VERYLONGNAME could
> translate
> > to VERYL00001, VERYLONGNAME2 as VERYL00002 and so on.
>
> Right, but while this would get us in with ILE RPG, I don't know that it
> would necessarily do so for OPM RPG, which seems to have problems with
> even 10-character field names.
>
> --
> JHHL
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.