MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » November 2012

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



fixed

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.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact