× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Yeah, I set system field names also...

But that doesn't help if I want the long ones.

Charles


On Wed, Apr 16, 2014 at 6:56 AM, Paul Bailey <PaulBailey@xxxxxxxxxx> wrote:


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.
--
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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.