| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQSI - ESQL -DBLOOK-UP -ERROR- INTERESTING |
« View previous topic :: View next topic » |
| Author |
Message
|
| asamanta |
 Posted: Wed Oct 29, 2003 10:43 pm Post subject: MQSI - ESQL -DBLOOK-UP -ERROR- INTERESTING |
 |
|
Novice
Joined: 20 Aug 2003
Posts: 18
|
I want to do this dblook up inside a function.
SET XXXX= (SELECT T.ZUPDMAT,T.ZUPDMAU,T.ZUPDMIP FROM Database.ZCS_G7TDMS_CFG_SAP_UPDATE AS T WHERE
T.ZSTAT_TO = 4 AND
T.ZCURR_ST = 'pq' AND
T.ZMAT_TYPE = 'h2') ;
Function is getting all input values properly but createing problem when it trying to store values in XXXX.
Can you please tell me what would be this 'XXXX' value which will hold these three returned values???
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??? |
|
| Back to top |
|
 |
| Yanghui |
| Posted: Thu Oct 30, 2003 1:13 am Post subject: |
|
|
Disciple
Joined: 08 May 2002
Posts: 151
Location: Dublin, Ireland
|
Hi,
I think the return result from your SELECT statement must be a list. So, the method I chose was to use Environment tree. Let's say we have created an element called Environment.Variables.DBLookupResult. You can use this element to accept all the return value from database and then continue your processing...
Hope it helps.
Regards
-Yanghui |
|
| Back to top |
|
|
| asamanta |
| Posted: Thu Oct 30, 2003 1:43 am Post subject: |
|
|
Novice
Joined: 20 Aug 2003
Posts: 18
|
Hi Yanghui,
I wanted to execute this DBLook-up inside a function. Inside function , if i declare a Environment variable, it gives you wmqi parsing(after deployment -- go to LOG tab) error.
How i will do this inside a function Or how i can pass a reference of an Environment varialble to the function.
Thanks in advance
Thanks for your reply Yanghui. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
