RE: SQL in Free Format in V5R3

Hi Peter,

I applied these PTFs 8 days ago. Some PTFs from Ginas mail were already old
and superseded by others. I applied the newer PTFs.

I can compile any SQLRPGLE, fixed and free.

Mit freundlichen Grüßen

Erich W. Schasse

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Peter.Colpaert@xxxxxxxxx
Sent: Monday, April 23, 2007 1:31 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: SQL in Free Format in V5R3

Gina,

We applied these PTF's over the weekend (at my request), and nothing but
trouble has followed since!

As it appears, we are now unable to compile any SQLRPGLE program that has
fixed-format SQL statements...

I don't think it's IBM's intention to break downward compatibility?

Is there any solution other than un-applying the PTF's?

The other developers are now very angry with me.

Thanks,

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



Gina M Whitney <whitneyg@xxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
20/04/2007 16:30
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
rpg400-l@xxxxxxxxxxxx
cc

Subject
Re: SQL in Free Format in V5R3







Yes

date: Thu, 19 Apr 2007 17:38:37 -0500
from: "Brian Johnson" <brian.johnson.mn@xxxxxxxxx>
subject: Re: SQL in Free Format in V5R3

Do these these PTFs support compiling on V5R3 with TGTRLS(*PRV) and then,

of

course, running on V5R2?


On 4/12/07, Gina M Whitney <whitneyg@xxxxxxxxxx> wrote:


SQL in Free Format is now available in V5R3. PTFs SI25763, SI25532,
SI23384 will supply this function.
The PTFs are also in the database group PTF SF99503 which will be
available
on or after May 4.

The v5r4 DB2 Universal Database for iSeries Embedded SQL programming

topic

in the info center has the syntax.
Here is a link to it:

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzajp/rzajp.pdf

.


Gina