Re: Is there a better way to run SQL in a CL pgm?

On 30-Mar-2012 07:44 , Dave wrote:

Unfortunately there was an issue with REXX and SQL after V6R1 in
certain conditions. We created a dossier with IBM (LPAR?) <ed: PMR
and\or APAR> over this but it could not be fixed and so we changed
our EXECSQL tool from using REXX to RPG. This issue is in the
archives, somewhere.

The only reference in the archives that I found was specific to the SQL CREATE ALIAS statement not working from an EXECSQL environment invocation within\from REXX; that, and my pointing out a similar issue with the SQL RENAME TABLE not functional from REXX. Is that\those what IBM refused to fix? If the response from IBM was only to\in a PMR, from which no APAR was ever published, then there was not a valid reply offered from IBM; i.e. the issue should be pursued again until an APAR is [closed,] visible on the web.

_i Subject: REXX AND ADDRESS EXECSQL i_ Date: 1 Apr 2010
http://archive.midrange.com/midrange-l/201004/msg00200.html
http://archive.midrange.com/midrange-l/201004/threads.html#00001

Regards, Chuck