John Powell's question - executing dynamic SPL

My version of the question was: CREATE PROCEDURE tst_dbs(srvr CHAR(64)) CALL database@srvr:procedure(parms); END PROCEDURE; ------ The following works: create procedure tst_dbs(srvr CHAR(64)) DEFINE stmt CHAR(200); LET stmt = "echo execute procedure procedure\\(parms\\) | dbaccess database@" || srvr; system stmt; end procedure; (I needed it too). cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com Back in Boise _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________