Re: Compile SQLRPGLE in WDSC vs Green Screen.

<snip>
F15 is from SEU, to browse the compile listing in split-screen mode.

WDSCi can't find the source because the SQL source comiled is the SQL
pre-compier output in QTEMP/QSQLTEMP1, and that source file is not
accessible when you click in the iSeries error list view.  QSQLTEMP1
apparently exists in the QTEMP library of a different job.  Modifying
the
create command, either with COMPILE or a modified WDSCi create command,
places the compiled source in a permanent library, so any job can access
it.

Note that with either method, when you natvigate to source from the
error
list view, the source in QSQLTEMP1 is opened and errors shown.  That's
not
the source you want to edit.  Make sure you switch to the editor of the
"real" source to fix those errors.
</snip?

Don't know if I was clear. Maybe I can make it clearer.  

If you compile a RPGLE program in WDSC, you get a list of errors. Click
on the error and it takes you to the error line in the source you are
editing. 

Compile a SQLRPGLE program and you get a list of errors. Click on the
error and it opens another copy of the source and like you say, if you
correct the error there, it is not reflected in the actual source. 

My question is why is this happening and is there a way around it?

The light just went on. Because the name of the spool file is different
from the source file name so it opens up a new copy? 

Hmmm, so maybe change the spool file name or source file name? Have to
play with it. 

Anybody got any other ideas?