Re: Free form SQL

Scott,

I also noticed that the automatic formatting for free-format SQL in WDSCi
7 will create really awful looking code! It doesn't seem to align
anything correctly.

Or am I doing something wrong?

(cross-posted to WDSCi-L for possible follow-up)

Peter Colpaert
Application Developer
PLI - IT - Kontich, Belgium
-----
Yoda of Borg are we. Futile is resistance, assimilated will you be.
-----



Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/10/2007 07:18
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: Free form SQL






Hi Pete,

Actually, I think Vern is wrong. You *can* use TGTRLS(*PRV), as long as
you're using an SQL precompiler that supports free-format.

Remember what the precompiler does! It converts your code into calls to
SQL APIs, then compiles that code. It doesn't matter whether your
original code is fixed or free, in either case, it converts your code to
fixed format calls to the APIs (it'll insert /end-free and /free as
appropriate, providing you have the latest PTFs... there were bugs in
the original implementation that caused the /end-free to be misplaced in
certain circumstances, but these are fixed in the latest PTFs -- make
sure you have the ones that supercede the original ones, don't just pick
the ones from the APAR)

Anyway.. the point is, the code that the precompiler creates will work
with TGTRLS(*PRV), no problem -- so it doesn't matter whether you use
TGTRLS(*PRV) or not. You *do* have to use SQL statements that are
supported on the target release (i.e. if you use a new SQL keyword that
requires V5R3, you'd have a problem). (But that would be a problem in
either fixed or free format.)

The only flaw in free-format SQL on V5R3 (that I'm aware of) is that the
syntax checker in WDSC 7.0 reports a strange error on free-format SQL
statements. (Something about a connection error, which it turns out had
nothing to do with what was wrong, what was really wrong was that the
RPG syntax checker in V5R3 didn't support free-format SQL.) Not sure if
they ever fixed that problem.

But that's only a problem in the editor. The precompiler and compiler
should work fine (assuming you have the right PTFs applied) even with
TGTRLS(*PRV).