MQSeries.net :: View topic

LearnMQSI · Posted: Thu Dec 02, 2004 1:20 pm Post subject:

Hi Folks,

Can somebody explain me the following SELECT Statement within
IF L1 <> oldL
condition
end if;

I need to know what exactly happening in SELECT Statement. Thanx a bunch in advance

Current Values in variables:
DECLARE ABC CHARACTER;
DECLARE XYZ CHARACTER;
DECLARE CON CHARACTER;
DECLARE DEF CHARACTER;
DECLARE V1 CHARACTER;

DECLARE refin REFERENCE TO "OutputRoot"."MRM"."TMP"."FIN"[1];
DECLARE refout REFERENCE TO "OutputRoot"."MRM"."TMPO"."FIN"[1];

SET ABC = 'DSF';
SET XYZ = 'DS';
SET CON = 'DSF';
SET L1 = 'FSD';
SET oldL1 = ' ';
SET DEF = 'N';

IF ABC = 'Temp' THEN
SET V1 = TRIM(' ' FROM DEF);
ELSE
IF XYZ = 'V' THEN
SET V1 = "Outpput"."MRM"."P"."V".{CAST(TRIM(' ' FROM ABC) AS
CHAR)};
ELSE
IF L1 <> oldL1 THEN
SET V1 = THE (SELECT ITEM T.{CAST(TRIM(' ' FROM ABC)
AS CHAR)} FROM "OutputRoot"."MRM"."P"."V".{CAST( TRIM(' '
FROM XYZ) AS CHAR)}[] AS T WHERE T.{CAST(TRIM(' ' FROM
CON) AS CHAR)} = L1);
ELSE
SET V1 = NULL;
END IF;
END IF;