I know where you are coming from, but giving SQL DDL to a client when they
are used to DDS just isn't a good idea because now you are taking away from
their productivity. Now, if they WANT you to teach them new ways to do
things then that is just fine (which is how more than 75% of my clients
work, with some opening the door stating "do whatever you want, we want to
learn the newest/best ways to do things")
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 9:07 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: Long DB2 Column Names from RPG
What? You'd ask your clients? Do they actually put a preference in their
project specifications or do they say "Get me this pretty screen on time and
on budget"?
But you're right, you can also declare the long field names in DDS if you
have to, using the ALIAS keyword. Had a former coworker call me years ago.
Had a client (he normally did PC development) in which he had to interface
with their software. The PC software was all written using long field
names. DBA on the as/400 set them up with short field names and he wanted
to know how to meet in the middle and I suggested ALIAS. Got a big thank
you but I don't know if he ever convinced them to CHGPF to use ALIAS.
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 09:56 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
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
