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.
