RE: [WDSCI-L] Retrieving compile errors with SQL RPG

["Samuel J Lennon" <lennon_s_j@xxxxxxxxxxx>]

   Don, thanks for the comment.

   I changed the CRTSQLRPGI command to put the pre-compiler file in my
   personal library.

   My first compile has SQL errors. I get them back in the error window .
   This is good, but I can't insert them into the source.

   I fix the SQL errors, and recompile. Now I have compile errors. I double
   click on an error message to insert the messages. WDSC goes out to the
   iSeries to download something, then I see error messages inserted in the
   source. Joy!

   I fix the errors and click compile. No CRTSQLRPGI choice! Then I realize
   that WDSC downloaded the pre-compiler temporary file and I've fixed the
   errors in that source. Not what I want. (Thump forehead for not noticing
   another window had opened.)

   I fix the errors in the real source and try again. Being fat-fingered I
   still have errors. I insert the errors again, and even knowing better, I
   still attempt to correct the temporary source. (Thump forehead again.)

   At this point, I'm still of two minds whether compiling on the green
   screen and Alt-Tabbing between SEU and WDSC isn't a better option than
   having a temporary source member open in WDSC with errors inserted.

   I'm still inclined to stand by my opinion that WDSC is less than effective
   for embedded SQL. Is there any other work around that I am missing?

   Sam

   >From: Don Yantzi <YANTZI@xxxxxxxxxx>
   >Reply-To: Websphere Development Studio Client for
   iSeries<WDSCI-L@xxxxxxxxxxxx>
   >To: Websphere Development Studio Client for iSeries
   <WDSCI-L@xxxxxxxxxxxx>
   >Subject: [WDSCI-L] Retrieving compile errors with SQL RPG
   >Date: Thu, 4 Mar 2004 16:41:17 -0500
   >
   > >>1) SQL embedded in RPG.  Can't get the compile errors back.
   >
   >Sam,
   >
   >Do you not see the error list coming back, or you get the error list and
   >can't double click on errors?  If it is the latter then you will need to
   >use the TOSRCFILE parameter for the CRTSQLRPG command to change where the
   >temporary source file created by the SQL preprocessor gets generated.  By
   >default this is QTEMP which the RSE cannot access after the
   compile.  When
   >the RPG compiler generates error messages the messages reference lines in
   >this temporary file.
   >
   >Don Yantzi
   >WebSphere Development Studio Client for iSeries
   >IBM Toronto Lab
   >Phone: (905) 413-4476
   >IBM internal:  IBMCA(yantzi)  -  Internet: yantzi@xxxxxxxxxx
   >_______________________________________________
   >This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
   mailing list
   >To post a message email: WDSCI-L@xxxxxxxxxxxx
   >To subscribe, unsubscribe, or change list options,
   >visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
   >or email: WDSCI-L-request@xxxxxxxxxxxx
   >Before posting, please take a moment to review the archives
   >at http://archive.midrange.com/wdsci-l.

     ----------------------------------------------------------------------

   FREE pop-up blocking with the new MSN Toolbar * get it now!