Re: Feedback regarding the automatic SQL Formatter

Hello folks,

You will remember the discussion we had about being able to format SQL that
goes beyond column 80. In order to make our internal processes work, I
could use an RFE requesting this.

I am not able to see any open RFEs for this issue that Vern thought may
exist already. So Vern, would you mind making a new RFE request for the SQL
formatting beyond column 80 option?

Taryn Morris
IBM - Software Developer for RDi


|------------>
| From: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Ken Killian <kkillian@xxxxxxxxxxxx> |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|"Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries" <wdsci-l@xxxxxxxxxxxx>, |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|06/14/2014 10:26 AM |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Re: [WDSCI-L] Feedback regarding the automatic SQL Formatter |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Sent by: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|"WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx> |
>--------------------------------------------------------------------------------------------------------------------------------------------------|





Edmund,

In SQL I use the "--" to do right hand comments...
<grin>

So, extending it out would be NO PROBLEM for me!

When using "Totally-Free" I have to use "//" for regular RPGLE/SQLRPGLE.

So, extend out SQL if you can in future Release!
<Big Smile>

-Ken Killian-


-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Edmund
Reinhardt
Sent: Friday, June 13, 2014 2:38 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for
System i & iSeries
Cc: WDSCI-L
Subject: Re: [WDSCI-L] Feedback regarding the automatic SQL Formatter


OK Ken, so you are the first one who would be impacted.
We will make this an option in the preferences for the SQL formatter and
you would have to turn it off or your right hand comments will get pulled
into your SQL.
Of course you could prefix your comments with // and they would be
unambiguously understood as comments.
Or, as you probably are doing today, you could turn off the SQL formatter.



Regards,

Edmund (E.H.) Reinhardt
Technical Architect for Rational Developer for i



Phone: 1-905-413-3125 | Home: 1-905-854-6195
IBM
E-mail: edmund.reinhardt@xxxxxxxxxx

RDi YouTube: 8200
Warden Ave
www.youtube.com/user/IBMRational#g/c/62DF24D5BCD43501 Markham, ON
L6G 1C7
Find me on: LinkedIn:
Canada
http://ca.linkedin.com/in/edmundreinhardt/







From: Ken Killian <kkillian@xxxxxxxxxxxx>
To: "Rational Developer for IBM i / Websphere Development Studio
Client for System i & iSeries" <wdsci-l@xxxxxxxxxxxx>,
Date: 13/06/2014 12:44 PM
Subject: Re: [WDSCI-L] Feedback regarding the automatic SQL
Formatter
Sent by: "WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxx>



I use Right-hand comments all the time, for over 20-years...

I guess once I got started on it, and never quit...

I even use right Hand comments on SQL Statements...
<grin>

-Ken Killian-


-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Voris,
John
Sent: Friday, June 13, 2014 11:39 AM
To: wdsci-l@xxxxxxxxxxxx
Subject: [WDSCI-L] Feedback regarding the automatic SQL Formatter

My $ 0.02

I would say that Michael is an exception to have used right hand comments
anytime in the past 2 decades Noone, noone noone for the past twenty years
that I know has been used the right hand side comment on the "C" spec . . .

--
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.

--
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.
--
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.