MQSeries.net :: View topic

asamanta

I am trying to excute it inside a function. My requirement is that to hold these db look up values in a Environment variable called rDBLookup, which is a reference, sending by REf to the function.
SET rDBLookup.DATA[] = (SELECT T.ZUPDMAT,T.ZUPDMAU,T.ZUPDMIP FROM Database.ZCS_G7TDMS_CFG_SAP_UPDATE AS T WHERE
T.ZSTAT_TO = rInMfcRefTarget.statusind AND
T.ZCURR_ST = rInMfcRefTarget.statusonsap AND
T.ZMAT_TYPE = rInMfcRefTarget.sapmattypform) ;

Function is getting all input values properly but createing problem when it trying to store values in rDBLookup.DATA[] .
Below error is getting through trace file.

BIP2536E: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.
Can i do this in other way out???