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


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...


On Fri, Nov 2, 2012 at 4:54 PM, Darryl Freinkel <dfreinkel@xxxxxxxxxxxxxxxxx

I have not used this in a while and need to be able to create a SQL alias
the fly.

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

This mailing list archive is Copyright 1997-2015 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