I think the problem with the leading blanks causing a problem will be fixed
by
APAR SE58260 - RDI 9.0.1 AUTO-FORMAT OF SQL DOES NOT ALWAYS WORK IN LPEX
WHEN EDITING SQLRPGLE SOURCE
Mike Hockings, M.Eng., P.Eng.
IBM Rational Developer for System z and Power Systems Software Technical
Support
IBM Canada Ltd. Laboratory
hockings@xxxxxxxxxx
voice 1-905-413-3199 T/L 313-3199 ITN 23133199
From: x y <xy6581@xxxxxxxxx>
To: wdsci-l@xxxxxxxxxxxx,
Date: 2014-03-05 22:10
Subject: [WDSCI-L] RDi 9.0.1 free-form SQL formatting questions
Sent by: wdsci-l-bounces@xxxxxxxxxxxx
I'm seeing some odd behavior in free-form SQL formatting on V7/TR6. While
SELECT gives me a new line for each variable, FETCH NEXT, INSERT INTO, and
MERGE don't. When you're working on a long statement, you have to add a
semicolon to prevent the editor from appending the next (non-SQL) line.
Finally, the formatting sometimes doesn't work at all--it looks like
leading spaces or blanks lines cause a failure even on simple statements
(EXEC SQL OPEN RO, for example, but if I remove the blank line before that
line it it formats properly). In addition, my comments don't stay in
place--they get sucked to the left
I've adjusted the options available under Remote Systems LPEX Editor | ILE
RPG | Free-Form SQL Formatting, including New Line After Comma. Have I
missed an option somewhere?
Thanks!
--
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.
midrange.com
