Re: REXX AND ADDRESS EXECSQL

[CRPence <CRPbottle@xxxxxxxxx>]

  I expect there is a defect which would need to be reported to 
your service provider.  In my experience, the REXX is not thoroughly 
tested in the lab, nor as well supported as for with embedded SQL. 
For example in REXX the SQL RENAME does not work [perhaps only with 
FOR SYSTEM NAME, I do not recall] and SQL CALL for INOUT parameters 
does not effect any updated parameter values, and the lab had no 
intention to correct these when I reported them years ago [although 
I made a private version of the code in the lab which made the INOUT 
parametes function as I expected].

Regards, Chuck

Jack Kingsley wrote:
> <<SNIP per message from OP not on NG; using msg indirectly>>
>
> On Thu, Apr 1, 2010 at 6:17 AM, David FOXWELL wrote:
>
> > I've been using this little script for a while now without any 
> > problems in order to use SQL from the command line or in CL
> > programs.
> >
> > PARSE ARG iSql
> > RC=0
> >
> > ADDRESS EXECSQL,
> > EXECSQL 'SET OPTION COMMIT = *NONE'
> > ADDRESS EXECSQL,
> > EXECSQL iSql
> >
> > However, if I pass a CREATE ALIAS command, I get this in the
> > joblog :
> >
> > STRREXPRC EXECSQL PARM('create alias myalias for myfile')
> > *   Address EXECSQL EXECSQL iSql;
> > +     RC(-10)
> > SNDPGMMSG MSGID(SQL0901) MSGF(QSQLMSG)
> >
> > Create table/index works fine.
> >
> > Any ideas what might be different with create alias?