I use the STRSQL+copy&paste trick too, but I also have the system field names set for each field so there is no issue with extra long field names, e.g.:
CREATE TABLE ...
MaximumLimit FOR BCMAXL bigint NOT NULL,
...;
BCMAXL is the system field name for the MaximumLimit field.
It can make programs a bit confusing if there is no consensus about which field name to use in which situation, but usually having the 6-char field name for every field makes life a bit easier especially if the file is used in a fixed-format RPG program. If you could select field names in RDi (as in the noted RFE) then I think I could make an effort to do without the system field names altogether.
-Paul.
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: 15 April 2014 18:20
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] New RFE for your review
I usually cheat by bring up STRSQL and prompting the "SELECT fields" ...
That gives me a nice list of columns I can copy and paste.
Of course, it doesn't work so well on my newer files with long column names.
I suppose I could query sysolumns....
Charles
On Tue, Apr 15, 2014 at 12:50 PM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:
On 4/15/2014 11:15 AM, Kurt Anderson wrote:
I voted. I'm not entirely sold on it, but I think it might be one
of
those things that I'd use once I see it in action.
Buck, you don't use data structure key lists (%kds)?
It's a very mixed bag here. For the really monstrous programs, there
just isn't enough time to go through them line by line and freshen up
the formatting. Generally, only the code blocks that are being
immediately maintained get that treatment. So we have some really old
looking code adjacent to 7.1 TR7 code :-/ I don't stress over that
because I can open up a massive S/36 style program and refresh my
memory as to how truly ugly 3 columns of left side indicators really appear...
I see this RFE as being very helpful for refactoring those blocks of
code we're working on right now. Maybe there is a conversion from
CHAIN to FETCH as we re-engineer the underlying database...
--buck
--
This is the Rational Developer for IBM i / Websphere Development
Studio Client for System i & iSeries (WDSCI-L) mailing list To post a
message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/wdsci-l.
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
Scanned by MailDefender - managed email security from intY - www.maildefender.net
Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.
We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.
Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham, B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.
midrange.com
