Re: Feedback regarding the automatic SQL Formatter

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi - I don't think I have all the details - I'd like someone who 
actually contributed more to the conversation to add the RFE.

Anyone?

On 7/16/2014 3:27 PM, Taryn Morris wrote:
> 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.