Re: More fun with native RLA on an SQL view

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Want to know something funny? The first time the OP wrote about an OPM
program I thought he was referring to a non-prototype RPGLE program!! (I was
mistaken, I know...).

I really had forgotten about the six char limit (and I have 30+ years
programming for IBM's midrange systems!). I had to search some VERY old
programs, in order to get the COLS info. That could be inserted under
masochism 101 :-)

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Tue, Apr 20, 2010 at 2:00 PM, <rob@xxxxxxxxx> wrote:

> OMG, why would someone want to write new code with OPM?
>
> Designers, make this something to keep in mind.  Make at least one field
> name 10 characters long to discourage OPM.  Sadism 101.
>
> If they are really into self flagellation they could use I specs to rename
> long external field names down to something pathetic to fit OPM.
>
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   "James H. H. Lampert" <jamesl@xxxxxxxxxxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Date:   04/20/2010 12:36 PM
> Subject:        Re: More fun with native RLA on an SQL view
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
>  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.
>
>
> --
> 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.