Re: SQLRPGLE

Hey Bill,

As Eric mentions, this issue is not new (check the archives).
Regarding the conversion to free form, APAR SE25187 was previosly opened
for this issue.

thanks,

Violaine Batthish
WebSphere Development Studio Client, IBM Toronto Lab



wdsci-l-bounces@xxxxxxxxxxxx wrote on 10/24/2006 06:02:01 PM:

Bill,

This is not a new problem, nor is it really specific to just WDSCi.
The problem is with the SQL pre-compiler....  What happens when you
compile an SQLRPGLE (or other SQL source type) is that the
precompiler takes your source, modifies it in QTEMP, then compiles
the object from the source in qtemp.  At this point, all the
embedded SQL code has been commented out and replaced with calls to
the SQL runtime.  This explains why none of your line numbers will match.

IBM is fully aware of this problem, and is working to address this.
It's not something that can be accomplished easily, so it might take
some time to resolve.

Regarding free-form SQL, this is brand new and only supported on
V5R4.  The first draft of support for this is a little rough, but
support should improve as fixes are released.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-297-2863 or ext. 1863



-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx]On Behalf Of Bill Barnes
Sent: Tuesday, October 24, 2006 12:12 PM
To: wdsci-l@xxxxxxxxxxxx
Subject: [WDSCI-L] SQLRPGLE


When I compile and SQLRPGLE program through RSE the first time in a
session I get the error list and can click on the error and the source
line is displayed.  That's great.  The problem comes up if there are
still errors after that and I run a second compile.  The error list
comes up and when I click on the error an RPGLE module is created with
the same name as the original SQLRPGLE but it is not SQL.  Any
corrections made there are not transferred to the original module.  I
have to hunt and search through the original module to find the lines
(different numbers from the RPGLE module.



I am getting extremely frustrated with RSE and I admit that it is
affecting my attitude towards it.



Another point is that when converting to FREE in an SQL RPGLE program it
causes errors in the SQL portion of the code that can't be recovered
from unless you exit without saving or restore the member from backup.



My desktop is a Dell DX270 with 2.+ Ghz processor 60GB hard drive and
1Gb main memory.  This is to forestall the question of what my desk top
has in it.



Thanks

Bill Barnes

Sr Analyst/Programmer

The Pantry, Inc

919-774-6700

ext 5211