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



Vern,

Yes, I would hope there's still work being done on it. If you just type
one big long line in (going past column 80), that's fixed in 9.1.1.
There's a setting to enable it. Follow the trail Windows, Preferences,
Remote Systems, Remote Systems LPEX Editor, IBM i Parsers, ILE RPG, and
finally Free-form SQL Formatting. There's now a checkbox for "Treat text
beyond 80 characters as SQL code to be auto-formatted". I just tested that
this morning and it works.

However if you paste in your SQL statement from a series of shorter lines,
it still has problems with the text before column 7 or so. (Maybe it's the
first 5 columns like you said. Anyway the results are seriously ugly--so
you'll probably still need to go through TextPad or something. Doing what
you talk about (adding 7 blanks at the head of each line) works. I was
just looking at some code and I still get a yellow triangle telling me
there's an unexpected token. The statement looks clean to me and runs fine
in STRSQL (or SQL Scripts, if you prefer). I don't see anything wrong ,
but I can't spent much time on it today.

Michael

"WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx> wrote on 01/25/2015 12:16:47 AM:
----- Message from Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx> on Sat,
24 Jan 2015 23:15:47 -0600 -----

To:

Rational Developer for IBM i / Websphere Development Studio Client
for System i & iSeries <wdsci-l@xxxxxxxxxxxx>

Subject:

Re: [WDSCI-L] Outline View

I have a thing that irks me - I believe the team is working on some of
it - that is the way SQL statements are handled - I often like to create

the statement in STRSQL (haven't done it in Navigator's statement
processor), then copy/paste it into an SQLRPGLE source - it can really
get screwed up. I've learned to take it into TextPad, make sure the
content is no more than about 60 long per line, and that I've inserted 7

blanks at the head of each row. That USUALLY works!!

It seems that the editor doesn't handle stuff that ends up in the first
5 positions - and again, I think there is some work on this, just not
there in 9.1.1.

So on it goes - and I still get great benefit from RDi. It seems we all
land on something we use more than anyone else, and that drives us
crazy!

Best to you
Vern


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.