Re: Colorized SQL

Sample colorization for SQL using the LPEX editor. Not sure if that is what you are looking for or not...

https://imgur.com/a/92xLlh4



-Ken Killian-

-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Tyler, Matt
Sent: Monday, February 25, 2019 10:21 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Colorized SQL

Did you look in Preferences -> LPEX Editor -> Parsers -> Parser Styles? There is one for each type of parser extension for LPEX. If there is non for SQL for you then click on Parser Associations first. Scroll to see the document type of SQL or sql. Then select the document parser.

-Matt

-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Monday, February 25, 2019 8:16 AM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Colorized SQL

That helped. Also, trying to figure out the source member type to use helped.
Still not up to the same level of Run SQL Scripts but it's an improvement.
What it is missing is the colorization of constants. Compare this in RDi vs Run SQL Scripts:
values 'sss' as mychar;
And the green for comments sticks out much better in Run SQL Scripts than the shade of green in RDi. I suppose there's some way to change that but I shouldn't have to. Except maybe RFE.

-----Original Message-----
From: WDSCI-L <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jon Paris
Sent: Friday, February 22, 2019 4:51 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries <wdsci-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: [WDSCI-L] Colorized SQL

Have you tried adding it under LPEX Editor > Parsers > Parser Associations ?


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Feb 22, 2019, at 4:31 PM, dlclark@xxxxxxxxxxxxxxxx wrote:

"WDSCI-L" <wdsci-l-bounces@xxxxxxxxxxxxxxxxxx> wrote on 02/22/2019
04:25:59 PM:

I am using RDi to edit a stored procedure stored in a source physical

file.

Is there some way to get it colorized, and get some of the other
features available in Run SQL Scripts while in RDi?

I get colorized SQL in RSE for source member types of SQL and
SQLPRC but not for SQLSRC.


Sincerely,

Dave Clark