RE: Long DB2 Column Names from RPG

While embedded SQL is an option, the issue I have is that when dealing with
LongDescriptiveNames is
that I like to use context assist to reduce the amount of typing.

I agree with Buck that it would be nice if RPG supported the long names
natively.

I assume that changing RPG to support the long SQL names when RPG pulls in the
definition of the files
on the f-specs is a non-trivial task. As an alternative to "full" support of
long names, it would be
almost as good if only externally defined data structures could pull in the
long SQL name. Then as
long as you're reading into and writing from those external DS, you'd only be
dealing with long names.

I think it'd be ok to add the support to external DSs without adding it to the
f-spec defined files.
But I think if you added it to f-spec files, you'd also want to add it to
external DSs.

As far as long file (and record) names. Yes, that would be nice. But if it
was and either/or, I'd
prefer to have long field names.

Just my .02 (+ $100 fuel surcharge ;-)

Charles

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, May 24, 2007 9:14 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Long DB2 Column Names from RPG

I don't suppose you find embedded sql an option?
exec sql select reallyLongFreakingField into :hostVariable
from myfile where thisReallyDescriptiveKeyFieldName = :MyKey;

For RLA would you want an H spec for the long field names on
all files, an F spec keyword so that you can select on a file
by file basis whether you want the long or short field names or what?

Do you want the long table names or short table names also,
or is field names sufficient?


Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"albartell" <albartell@xxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
05/24/2007 08:53 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
Long DB2 Column Names from RPG






On an airplane coming back from RPGWorld right now. As I am
doing some
offline WDSC DDS PF creation I thought of Barbara's comments
awhile back
concerning the most popular feature in an RPG survey a few
years ago (i.e.
%trim enhancements). That got me thinking... man I sure
would like to be
able to use long file field names in RPG. The 10 char limitation is
getting
really old and I was just wondering if anybody knew if we
would be able to
use SQL named fields or fields created/named with the ALIAS keyword
anytime
in the near future. That would be on my top 10 list of
things I want to
see
in RPG this coming year.

Thanks for listening,
Aaron Bartell
http://mowyourlawn.com
--
This is the RPG programming on the AS400 / iSeries (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


--
This is the RPG programming on the AS400 / iSeries (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

This e-mail transmission contains information that is intended to be
confidential and privileged. If you receive this e-mail and you are not a
named addressee you are hereby notified that you are not authorized to read,
print, retain, copy or disseminate this communication without the consent of
the sender and that doing so is prohibited and may be unlawful. Please reply
to the message immediately by informing the sender that the message was
misdirected. After replying, please delete and otherwise erase it and any
attachments from your computer system. Your assistance in correcting this
error is appreciated.