MQSeries.net :: View topic

nu1 · Posted: Mon Sep 19, 2005 8:36 pm Post subject:

HI
I Created a Message flow project.
I created a message flow(Input Node, Compute Node, Output Node) with default schema.
Then I created a Broker Schema "com.sampleschema"
I created a SampleProcedure in SampleProcedure.esql giving schema name com.sampleschema.
************************************

BROKER SCHEMA com.sampleschema
CREATE PROCEDURE SampleProcedure(INOUT OutRef REFERENCE)
BEGIN
SET OutRef.message='Hello';
END;

************************************
From the message flow (with default Schema) I tried calling this procedure
I have the esql file

****************************************
PATH com.sampleschema;
CREATE COMPUTE MODULE Samplemsgflow_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
DECLARE numHeaders INTEGER CARDINALITY(InputRoot.*[]);

WHILE i < numHeaders DO
SET OutputRoot.*[i] = InputRoot.*[i];
SET i = i+1;
END WHILE;

CREATE FIELD OutputRoot.XML."Outgoing";
DECLARE OutRef REFERENCE TO OutputRoot.XML."Outgoing";

CALL SampleProcedure(OutRef );

RETURN TRUE;
END;
END MODULE;

************************************************
I am receiving this error when I tried to depoly the msg flow project
BIP2402E: Syntax error: 'keyword Create'

BIP4121E: The State text was'CREATE SCHEMA ""PATH com.sampleschema;
CREATE COMPUTE MODULE ......

Though I have coded anything like was'CREATE SCHEMA ""PATH com.sampleschema I am repeatedly getting the error pointing to this.

How should I call a procedure in different schema?
WHat should I set for this in my main esql file?
Please let me know if you have ideas to resolve this error.

Appreciate your help in advance.

Regards
-nu1
_________________
-nu1