MQSeries.net :: View topic

vids · Posted: Tue Apr 12, 2005 3:22 pm Post subject:

Hi,

I'm using WBIMB 5.0.2. I have a messageFlowProject1 under which I have schema1 which has around 10 flows and associated esql files.
I need to call a particular function in all these 10 esql files. To make that function reusable, I created a new util.eqsl file under schema1 and put the function in this util.esql.

Here is what my util.esql contains....

CREATE FUNCTION GetCurrentGMT() RETURNS CHARACTER

BEGIN
code goes here....
RETURN xyz;

END;

I'm calling this GetCurrentGMT() in all the modules within the same schema.
My util.eqsl does not contain any MODULE or main function.

Just wondering if this is the right way to do it. Is there any other way to make the code reusable?
How to make this function reusable across different schemas?

Thanks
Vids