Re: REXX AND ADDRESS EXECSQL

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

Maybe you need a seperate variable defined for the create alias portion and
a seperate execsql statement for it.

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzajp/rzajpmst150.htm



On Thu, Apr 1, 2010 at 6:17 AM, David FOXWELL <David.FOXWELL@xxxxxxxxx>wrote:

> Hi all,
>
> 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 SRCMBR(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?
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.