Hi,
What about using defining long names and short (system) names for your
tables.
In this way you can use the long names with (embedded) SQL and the system
names you defined (and that may be more descriptive than the system
generated ones) for native I/O. SQL allows you to use both, long and short
names.
Example:
Create Table MySchema/MyTable
(MyLongColumnNameForCharacters for XXChar Char(20) Not Null with Default,
MyLongColumnNameForIntegers for XXInt Integer Not Null with Default
0, ...)
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [
mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von albartell
Gesendet: Thursday, May 24, 2007 15:55
An: 'RPG programming on the AS400 / iSeries'
Betreff: RE: Long DB2 Column Names from RPG
I don't suppose you find embedded sql an option?
Where it is a good fit, yes SQL is a great option. But A LOT of my
programming is native IO and it would be great to have long names without
any additional coding at the top of the program and instead simply be able
to use the long names declared in DDS (or DDL, doesn't matter to me - except
that I will most likely need to do DDS for clients vs. DDL depending on how
forward thinking they are).
Aaron Bartell
http://mowyourlawn.com
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [
mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of rob@xxxxxxxxx
Sent: Thursday, May 24, 2007 8: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
midrange.com
