Re: Autoformat SQL in RPGLE FREE

[Paul Bailey <PaulBailey@xxxxxxxxxx>]

Thanks Rob,

I knew about the option. I was just hoping I could turn it on and off again without having to navigate all that way - some sort of shortcut, toolbar option or keypress to turn the SQL formatting on and off while I am writing a new SQL line. I would have to do it at least five times per SQLRPGLE program (ten times for the round trip) making 45 mouse-clicks in all (90 for the round trip), and every little helps.

If I leave it off, the SQL code doesn't always comply to the in-house standards that the SQL formatting in RDi has allowed us to agree upon. Without it I have almost as much trouble as the SEU programmers in getting it right.


Paul.


-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Robert Rogerson
Sent: 09 April 2014 14:29
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Autoformat SQL in RPGLE FREE

Paul, take a look at
Window->Preferences->Remote Systems->Remote Systems LPEX Editor->IBM i
Parsers->ILE RPG->Free Form SQL Formatting

This may what you want.  This is for RDi V9

Rob
On 2014-04-09 8:39 AM, Paul Bailey wrote:
> Hi,
>
> I'm having a bad time entering a brand new SQLRPGLE program. When I enter an EXEC SQL statement in my RPG (say, for instance, between a begsr; and endsr;) and then press ENTER, (or DOWN, or otherwise try to indicate I want to continue typing on the next line) the SQL autoformatter sucks out all the whitespace between the EXEC SQL and the endsr; and puts them both on the same line. And it keeps doing it after every press of ENTER or DOWN! At least until the SQL statement is complete, anyway. Obviously endsr; is not a valid SQL statement, so I would expect the formatter to not do anything until it can parse the line properly.
>
> Anybody know if there is an option to stop this (turning off the autoformatter is an option, but I'd prefer to keep using it to keep my SQL statements properly formatted.)
>
> Is there a quick way to turn the SQL formatter on and off? So maybe I can turn it off, type a whole statement and turn it back on to format it. Navigating the windows/preferences page for this option isn't ideal.
>
>
> -Paul.
>
>
> ________________________________
> Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.
>
> We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.
>
> Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham, B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.

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

Scanned by MailDefender - managed email security from intY - www.maildefender.net

Important, this email transmission and any files with it are strictly confidential to the intended recipient and may be legally privileged. Any views or opinions presented are solely those of the author and do not necessarily represent those of BHSF. If you are not the intended recipient, you must not copy, disclose or distribute its contents in any way. If you have received this e-mail in error, please notify the sender and delete the e-mail from your system.

We have taken steps to ensure this email and attachments are free from any virus but do not accept any responsibility once this e-mail has been transmitted. You should scan any attachments for viruses. No contract may be concluded on behalf of BHSF Limited by e-mail.

Registered Office: BHSF Limited, Gamgee House, 2 Darnley Road, Birmingham, B16 8TE. www.bhsf.co.uk Registered in England number 35500. BHSF Limited is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and Prudential Regulation Authority.