Re: More fun with native RLA on an SQL view

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.