Re: Long SQL statements -- WDSCI-L

Michael

Thanks for the reminder on the column 80 setting - just turned it on.

I used to use an SQL formatter called NiceSQL - it gave pretty good results. It's been over 10 years now, but the developer was pretty responsive, even to iSeries syntax stuff, as I recall.

Any formater is better than a long string of SQL, I think - AND I've not tested the various options in the RDi formatter. As it is for you, the same for me - can't take the time right now!!

Cheers
Vern

On 1/26/2015 9:25 PM, MichaelQuigley@xxxxxxxxxx wrote:

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