Re: How do you create a dynamic ALIAS command in RPG

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

Yup.  Maybe put it in QTEMP so it goes away automatically:
wMySqlStmt = 'create alias qtemp/myalias for mylib/mytable';

Sam

On 11/2/2012 5:11 PM, Charles Wilt wrote:
> wMySqlStmt = 'create alias myalias for mylib/mytable';
>
> exec sql
>    execute immediate :wMySqlStmt;
>
> should work IIRC...
>
> Charles

> On Fri, Nov 2, 2012 at 4:54 PM, Darryl Freinkel <dfreinkel@xxxxxxxxxxxxxxxxx
> > wrote:
>
> > I have not used this in a while and need to be able to create a SQL alias
> > on
> > the fly.