Re: More fun with native RLA on an SQL view

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.