Hi Dave,
I have added this in our requirement database. Let's see what we can do.
Regards,
Nazmin Haji
"Dave Shaw"
<daveshaw@bellsou
th.net> To
Sent by: wdsci-l@xxxxxxxxxxxx (wdsci-l)
wdsci-l-bounces@m cc
idrange.com
Subject
Re: [WDSCI-L] Free-form SQL auto
02/20/2008 01:36 formatting in SQLRPGLE
PM
Please respond to
Websphere
Development
Studio Client for
iSeries
<wdsci-l@midrange
.com>
Vern,
We're on V5R4, so I'm using free-form SQL all the time now and trying not
to look back. Like most pioneers, though, I seem to be getting a lot of
arrows in my back. ;-)
I'm sure it was just an oversight when they did the formatter, since most
people don't use the JOIN/ON syntax very often. After all, the STRSQL
prompter only tolerates it, rather than properly supporting it.
It looks to me like the variations on JOIN should be treated more or less
like CASE, and ON should be treated like AND/OR. I don't know how hard
that would be for IBM to do, though, and I'm not allowed access to put in
PMRs. Sigh. I'm just hopeful that one of friendly IBM people will notice
this.
Thanks for the NiceSQL info. I'll take a look when I get time.
Dave Shaw
Mohawk Industries
----- Original Message -----
From: <vhamberg@xxxxxxxxxxx>
To: "Websphere Development Studio Client for iSeries"
<wdsci-l@xxxxxxxxxxxx>
Sent: Wednesday, February 20, 2008 1:16 PM
Subject: Re: [WDSCI-L] Free-form SQL auto formatting in SQLRPGLE
Dave
Thanks - had not seen that - don't usually develop to V5R3 these days.
I suspect it is related to not thinking in terms of the JOIN syntax,
maybe it'd work if you do JOINs with the WHERE clause - but that is so
restrictive.
I gave the wrong name for the SQL formatter - should be NiceSQL and the
site is
http://home.broadpark.no/~ihalvor/
--
This is the Websphere Development Studio Client for 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.
midrange.com
