Re: SQL Formatter - give me your poor huddled messes

Done. Open PMR# 09268,442,000 RDI 9.6.0.1. <ENTER> does not split SQL Code

-Ken Killian-


-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxx> On Behalf Of Edmund Reinhardt
Sent: Thursday, March 15, 2018 2:26 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Cc: Xueqi Fan <Xueqi.Fan@xxxxxxx>
Subject: Re: [WDSCI-L] SQL Formatter - give me your poor huddled messes


Ken,
I have seen where in the code that behaviour for the enter key is overridden in SQL.

I have someone writing the code to fix it.
A PMR will help track it.

Thanks,
Edmund



|
|
|Edmund Reinhardt
|
|Rational Developer for i Architect
|
|IBM
|p:
| 905 413 3125
|w:
| ibm.biz/rdi_hub e:
| edmund.reinhardt@xxxxxxxxxx
|







From: Ken Killian <kkillian@xxxxxxxxxxxx>
To: Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Date: 2018-03-14 06:44 AM
Subject: Re: [WDSCI-L] SQL Formatter - give me your poor huddled messes
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>



Edmund,

Gee, I have a small request on the sql formatter. Allow <Enter> to split a line like it does in LPEX, Text editor & notepad. What a concept! Hit <enter> to split a line! <Big Goofy Grin>

PS. Not a show-stopper, just would be "nice" to work like other editors.

Love that I can now use TAB to indent my code, like other editors! Awesome!

-Ken Killian-

-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxx> On Behalf Of Edmund Reinhardt
Sent: Tuesday, March 13, 2018 6:21 PM
To: Wdsci-L <wdsci-l@xxxxxxxxxxxx>
Cc: Ken Guo1 <Ken.Guo1@xxxxxxx>
Subject: [WDSCI-L] SQL Formatter - give me your poor huddled messes



Hi Everybody
I have somebody who is getting deep into the bowels of the SQL Formatter code to fix an APAR. This is some non-trivial code and now that we have somebody up to speed on it, it would be a good time to address all of the pain points you are all feeling with the SQL Formatter.
I have heard (and seen) some pretty poor formatting, so if you can send me the EXEC SQL statements to ken.guo1@xxxxxxx. We might have a chance to address some of these issues.

Thanks


|

|

|Edmund Reinhardt

|

|Rational Developer for i Architect

|

|IBM

|p:

| 905 413 3125

|w:

| ibm.biz/rdi_hub e:

| edmund.reinhardt@xxxxxxxxxx

|




--
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:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_wdsci-2Dl&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=xVh0JOaBkAaa2_VJvF7mVrroZMIB4ornEW2uKL1r-oM&m=2D8wGPdJwWz75ATozlKcQgyrdiRBhx4b_2GZqGFuhlM&s=TYaC0ns-3x366tO5z18RdbpKDBBKi1ReycF_n_XD1v4&e=

or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_wdsci-2Dl&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=xVh0JOaBkAaa2_VJvF7mVrroZMIB4ornEW2uKL1r-oM&m=2D8wGPdJwWz75ATozlKcQgyrdiRBhx4b_2GZqGFuhlM&s=HfS3B6tQ8kzb4COxen1sIUCo6ax5t6f_f8LKx9cvZho&e=
.
--
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:
https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_wdsci-2Dl&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=xVh0JOaBkAaa2_VJvF7mVrroZMIB4ornEW2uKL1r-oM&m=2D8wGPdJwWz75ATozlKcQgyrdiRBhx4b_2GZqGFuhlM&s=TYaC0ns-3x366tO5z18RdbpKDBBKi1ReycF_n_XD1v4&e=

or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_wdsci-2Dl&d=DwICAg&c=jf_iaSHvJObTbx-siA1ZOg&r=xVh0JOaBkAaa2_VJvF7mVrroZMIB4ornEW2uKL1r-oM&m=2D8wGPdJwWz75ATozlKcQgyrdiRBhx4b_2GZqGFuhlM&s=HfS3B6tQ8kzb4COxen1sIUCo6ax5t6f_f8LKx9cvZho&e=
.



--
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: https://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/wdsci-l.