MQSeries.net :: View topic

asamanta · Posted: Mon Nov 10, 2003 4:37 pm Post subject:

DECLARE rEnvVar REFERENCE TO Environment.Variables.Data[];

CREATE FUNCTION FnXYZ('val' CHAR,rEnvVar REFERENCE) RETURNS CHARACTER
BEGIN
BEGIN
DECLARE rEnvVar1 REFERENCE TO rEnvVar.Data1[];
DECLARE sCHAR1 CHARACTER;
DECLARE sCHAR2 CHARACTER;

SET rEnvVar1.FnI[] = (SELECT T.CHAR1,T.CHAR2 FROM Database.ARDH AS T WHERE T.ABS ='val' );

SET sCHAR1 = rEnvVar1.FnI[1].CHAR1;
SET sCHAR2 = rEnvVar1.FnI[1].CHAR2;

RETURN sCHAR1;
END;

Can anyone help me where this is wrong????

It gives error like: "The dynamic field reference supplied to the SET statement does not resolve to a non-list field in a modifiable message tree. The dynamic field reference supplied to the SET statement must resolve to a non-list field in a modifiable message tree. Ensure that only non-list references to modifiable trees are passed to the SET statement."