MQSeries.net :: View topic

elvis_gn · Posted: Sat Dec 04, 2004 4:17 am Post subject:

I have a BLOB domain message flow getting a XML input of
<Name>
<FirstName>ELVIS</FirstName>
<LastName>NINAN</LastName>
</Name>

I want to just get an output as: ELVISNINAN

My ESQL is like this:

CREATE COMPUTE MODULE CIO_TO_DATABASE_MSGFLOW_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
DECLARE CobolOutput BLOB;
CALL CopyMessageHeaders();

SET CobolOutput = CAST( (InputBody.VehicleInfoRequest.RegistrationNumber || InputBody.VehicleInfoRequest.RegistrationType) AS BLOB CCSID InputRoot.Properties.CodedCharSetId);

SET OutputRoot.BLOB.Vehicle = CobolOutput;
RETURN TRUE;
END;

CREATE PROCEDURE CopyMessageHeaders() BEGIN
DECLARE I INTEGER 1;
DECLARE J INTEGER CARDINALITY(InputRoot.*[]);
WHILE I < J DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I + 1;
END WHILE;
END;
END MODULE;

Plz help, i have been stuck with this problem for days now....thx