MQSeries.net :: View topic

paranoid221 · Posted: Mon Dec 08, 2008 2:57 pm Post subject: UDPs in ESQL

Hey guys -
This is how i currently have my flow.
MQInput -> Compute -> MQOutput
I have defined a UDP at the msg flow level, schemaName with a value of ABC.
Also declared it as EXTERNAL inside my Compute Node... and then I have

Call myProc1(...) EXTERNAL SCHEMA schemaName
and then
CREATE PROCEDURE myProc1( ...,...,...) LANGUAGE DATABASE EXTERNAL NAME "%.PROC_IN_MY_DB2";

Works like a charm the way I want it to.

How would I go about doing something similar if I have to externalize the stored procedure name as well. So in the above code, instead of saying
EXTERNAL NAME "%.PROC_IN_MY_DB2" I could pop in another UDP procName (and set its value to PROC_IN_MY_DB2) declared at the message flow level ?

I ran out of ideas on how to externalize the stored procedure name so that it can be modified on the bar file prior to deployment. Any inputs are much appreciated.
Cheers
_________________
LIFE is a series of complex calculations, somewhere multiplied by ZERO.