SQL formatting issues in RPG

[Adein]

I am having some problems getting complex quieries to format properly in RDI.

When I try to do something like

SELECT DISTINCT SUBSTR(ititm#, 5, 2) + SUBSTR(ititm#, 7, 2),
(SELECT cfdsc1
FROM confil
WHERE cftype = 'COLR')
... *snip* ...

I get the stuff all crunched to the side, with very little room to type from's and where's.

Is there a way to turn off the auto formatting for the SQL, or at least change it to be more friendly?

Thanks!

-Adein

[MichaelCatalani]

Re: SQL formatting issues in RPG

Edit: Nevermind, just spotted the auto-formatting comment.

[B.Hauser]

Re: SQL formatting issues in RPG

The automatic formatting does not work very well for a little more complex SQL statements.
That's why I swichted the automatic formatting off:

Window --> Preferences --> Remote Systems --> IBM i Parsers --> ILE RPG --> Free Form SQL

Birgitta

[Adein]

Re: SQL formatting issues in RPG

Perfect! Thank you!