Re: Free-form SQL auto formatting in SQLRPGLE

I don't think the autoformat was ever intended for SQL - only real RPG. Now if you want a formatter for SQL, google on a program called cutesql - very nice. Takes any statement you have put on the clipboard and reformats it according to your settings. Then you paste that result wherever. It does not probably do EVERYTHING exactly as you'd like, but the developer is very responsive to user suggestions and problems - or was 5 years ago. He took care of a couple things specific to iseries for me.

HTH
Vern

At 07:43 AM 2/20/2008, you wrote:

WDSCi 7.0.0.4 (all updates applied)

>From Preferences:

Automatic uppercasing is Custom, Keywords are Uppercase, Identifiers are Lowercase.
Automatic indent is on and set to 3 blanks.
Automatic formatting is on, New line on comma is End of line, New line on AND/OR keywords is After, On Case keyword is on.
Comments are Move to top.

Problem: It doesn't handle the JOIN and ON keywords the way I'd like. Example:

EXEC SQL
INSERT INTO fip020a
SELECT t2.f2cmpy, t1.f2styl, t1.f2clr, t1.f2size, t1.f2back,
t2.f2cust, ' ', 0, 0, 0, 0, 0, 0
FROM fip020r t1 INNER JOIN fip020 t2 ON t1.f2styl = t2.f2styl
AND
t1.f2clr = t2.f2clr AND
t1.f2size = t2.f2size AND
t1.f2back = t2.f2back LEFT EXCEPTION JOIN fip020a t3 ON
t1.f2styl = t3.f2styl AND
t1.f2clr = t3.f2clr AND
t1.f2size = t3.f2size AND
t1.f2back = t3.f2back
WHERE t1.f2cmpy = :wccmpy AND
t1.f2back = :wcback;

What I'd like to see:

EXEC SQL
INSERT INTO fip020a
SELECT t2.f2cmpy, t1.f2styl, t1.f2clr, t1.f2size, t1.f2back,
t2.f2cust, ' ', 0, 0, 0, 0, 0, 0
FROM fip020r t1
INNER JOIN fip020 t2 ON
t1.f2styl = t2.f2styl AND
t1.f2clr = t2.f2clr AND
t1.f2size = t2.f2size AND
t1.f2back = t2.f2back
LEFT EXCEPTION JOIN fip020a t3 ON
t1.f2styl = t3.f2styl AND
t1.f2clr = t3.f2clr AND
t1.f2size = t3.f2size AND
t1.f2back = t3.f2back
WHERE t1.f2cmpy = :wccmpy AND
t1.f2back = :wcback;

Is there any way to get it to do this now, or does it need to go on the 'wish list'?

Thanks!

Dave Shaw
Mohawk Industries
--
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.