Re: SQLRPGLE

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