MQSeries.net :: View topic - Is referencing fields ouside a loop allowed?

tbt102 · Posted: Sun May 11, 2003 6:40 pm Post subject:

Hi all,

I'm trying to reference fields outside a loop. See sample code below. When I do the message BIP2432E is displayed when I deploy. See full message below.

Is referencing fields ouside a loop allowed? If not, is there a way to expose the fields outside the loop.

Thanks in advance for any help.

DECLARE blobCF99 BLOB;

WHILE LASTMOVE (refInput) = TRUE DO
IF refInput."INPUT_CF01" <> 0 THEN
SET blobCF99 = refInput."INPUT_CF01";
CALL WriteOutMesg(blobCF99);
ELSE
SET intRecNotProcessed = intRecNotProcessed + 1;
END IF;

IF refInput."INPUT_CF01" <> 0 THEN
SET blobCF99 = refInput."INPUT_CF01";
CALL WriteOutMesg(blobCF99);
ELSE
SET intRecNotProcessed = intRecNotProcessed + 1;
END IF;

MOVE refInput NEXTSIBLING;
END WHILE;

CREATE PROCEDURE WriteOutMesg(IN blobCF99 BLOB)
BEGIN
SET "OutputRoot"."MRM"."OUTPUT"[intNextMesgOut]."OUTPUT_FC_ARTNR" = refInput."INPUT_ARTNO";
SET "OutputRoot"."MRM"."OUTPUT"[intNextMesgOut]."OUTPUT_FC_FC" = blobCF99;
SET intNextMesgOut = intNextMesgOut + 1;
END;

BIP2432E: (58, 6) : The correlation name 'OutputRoot' is not valid. Those in scope are: , blobCF99.

The first element of a field reference must be a valid correlation name, from those in scope. This message may sometimes be due to an incorrectly formed or spelled expression which is not intended to be a field reference being parsed as if it were a field reference because the parser does not recognize it.

Correct the syntax of the expression and redeploy the message flow.