Re: Rexx address command versus execsql

[Simon Coulter <shc@xxxxxxxxxxxxxxxxx>]

On 03/04/2008, at 6:08 AM, <lgoodbar@xxxxxxxxxxxxxx>  
<lgoodbar@xxxxxxxxxxxxxx> wrote:

> If I say "ADDRESS EXECSQL" at the top of a Rexx program, then I can  
> run
> SQL statements fine. Prefixing i5/OS commands with ADDRESS COMMAND  
> works
> well also.
>
> However, if I use just ADDRESS COMMAND at the beginning of a program,
> then ADDRESS EXECSQL statements return with RC(-10).

I think I no the problem. I also have an OPINION on the behaviour of  
EXECSQL in Rexx. Show me some source so I can be sure.

Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         OS/400, i5/OS Technical Specialists

   http://www.flybynight.com.au/
   Phone: +61 2 6657 8251   Mobile: +61 0411 091 400        /"\
   Fax:   +61 2 6657 8251                                   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------