Re: The SAGA or is it Soap Opera Continues

The SQL pre-compiler does indeed generate a temporary file for the RPG compiler to read. On WDSc 7.0 the temporary file is opened up and the errors are inserted there. Better than nothing as long as you don't try to correct the temporary file. At least that's what it does for me at work--not that I'm enthralled about this approach.

It may be that this has something to do with the "Compile in Batch" option (Remote Sytems>iSeries>Command Execution). Checking this may cause the compile to be submitted as a separate job while unchecking causes the compile to run in the servicing job. If submitted, maybe the temp file is lost.

Sam

To: wdsci-l@xxxxxxxxxxxx
From: pete@xxxxxxxxxxxxxx
Date: Mon, 2 Nov 2009 16:47:57 -0600
Subject: Re: [WDSCI-L] The SAGA or is it Soap Opera Continues

Yes, I use OPTIONS(*EVENTF). The Implementer plugin requires it. Are you
working with embedded SQL? The problem seems to be that the SQL
precompiler modifies the source and places it in a temporary source
member in QTEMP, which is then processed by the RPG compiler.

_________________________________________________________________
Bing brings you maps, menus, and reviews organized in one place.
http://www.bing.com/search?q=restaurants&form=MFESRP&publ=WLHMTAG&crea=TEXT_MFESRP_Local_MapsMenu_Resturants_1x1