I am making it a habit to issue a COMMIT to my SQL scripts, just in case.
Maybe that could help.

-John Voris

date: Fri, 25 Jul 2014 08:54:38 -0400
from: "Siwicki, Gary (GSiwicki)" <GSiwicki@xxxxxxxxxxx>
subject: Creating SQL View in CL closes SQL cursor in RPG program

In my RPG program, I call a CL that has a RUNSQLSTM command that uses
the commands in a TXT source member to create an SQL view in QTEMP.

Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot 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 here. If you have questions about this, please contact