|
The program still won't execute report #2. When it trys to execute the SQL statements for report #2, the program bombs and gives me some kind of SQL dump that doesn't make any kind of sense. It's nothing like a program dump. Each subprocedure has multiple PREPARE & EXECUTE statements that run 1 after the other with no problems, but as soon as the program trys to process report #2, the program crashes. If anyone can help figure out what's going on, I'd appreciate it. Here's what's happening so far: ================================================================================= Screen 1: User selects the reports they would like to print(Report 1, Report 2, or Report 3) <Enter Pressed> (SQL RPG Program Begins) If Report 1 callp PRCS_REPORT1 ENDIF If Report 2 callp PRCS_REPORT2 ENDIF If Report3 callp PRCS_REPORT3 ENDIF start PRCS_REPORT1 SQLSTRING = 'DECLARE GLOBAL TEMPORARY TABLE.......' /EXEC SQL PREPARE SQLCMD FROM :SQLSTRING EXECUTE SQLCMD /END-EXEC end PRCS_REPORT1 start PRCS_REPORT2 SQLSTRING = 'DECLARE GLOBAL TEMPORARY TABLE.......' /EXEC SQL PREPARE SQLCMD FROM :SQLSTRING EXECUTE SQLCMD /END-EXEC end PRCS_REPORT2 start PRCS_REPORT3 SQLSTRING = 'DECLARE GLOBAL TEMPORARY TABLE.......' /EXEC SQL PREPARE SQLCMD FROM :SQLSTRING EXECUTE SQLCMD /END-EXEC end PRCS_REPORT3 *INZSR BEGSR C/EXEC SQL C+ Set Option C+ Naming = *Sys, C+ Commit = *None, C+ UsrPrf = *User, C+ DynUsrPrf = *User, C+ Datfmt = *iso, C+ CloSqlCsr = *EndMod, C+ Commit = *none C/END-EXEC ENDSR (SQL RPG Program Ends) ================================================================================= I can run Report 1, 2, or 3 one at a time with no problems, but if I select all 3 reports to print, the 1st report will print, but the program crashes on the 2nd report. Am I missing an SQL statement anywhere? I'm only using PREPARE and EXECUTE. Thanks, Frank
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.