RE: More fun with native RLA on an SQL view

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

But the short names can be defined in DDL, allowing the "short" field
names to be six characters or less.
-Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of James H. H.
Lampert
Sent: Tuesday, April 20, 2010 11:18 AM
To: Midrange Systems Technical Discussion
Subject: Re: More fun with native RLA on an SQL view

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