| Author |
Message
|
| Gopi Sriram |
 Posted: Tue Nov 22, 2016 1:39 am Post subject: Getting the error when accessing the Environment variables. |
 |
|
Newbie
Joined: 17 Aug 2015
Posts: 6
|
Hi,
I'm working with Mapping node in IIB 10.0.0.6. My task is to perform SELECT transformation, in where clause I'm using the Environment variables as place holders to retrieve the data. My where clause and Mapping xpath expressions are as follows. Before this, I have assigned values to Environment also.
MSSUSR5.BANK_CUSTOMER_DETAILS.CUSTOMER_NAME = ? AND MSSUSR5.BANK_CUSTOMER_DETAILS.PASSWORD = ?1
? = $Environment/Variables//Password
?1 = $Environment/Variables//UserName
But I'm getting the error as follows:
IXJXE0797E: [ERR 0712][ERR XPST0008] No binding was found for the external variable 'Environment'
 |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Tue Nov 22, 2016 5:17 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Does the mapping node allow you to work with the Environment?
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| Gopi Sriram |
| Posted: Mon Nov 28, 2016 1:23 am Post subject: |
|
|
Newbie
Joined: 17 Aug 2015
Posts: 6
|
|
| Back to top |
|
|
| timber |
| Posted: Mon Nov 28, 2016 2:45 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1280
|
So you can map from the Environment message tree to (say) OutputRoot.XMLNSC using the Mapping node, but when ( in the Mapping node) you try to refer to the Environment tree in the WHERE clause of a SELECT you get this error.
Is that correct? |
|
| Back to top |
|
|
| Gopi Sriram |
| Posted: Mon Nov 28, 2016 3:05 am Post subject: |
|
|
Newbie
Joined: 17 Aug 2015
Posts: 6
|
Yes, correct.
 |
|
| Back to top |
|
|
| timber |
| Posted: Mon Nov 28, 2016 6:03 am Post subject: |
|
|
Grand Master
Joined: 25 Aug 2015
Posts: 1280
|
| Sounds like a bug, but I'm not an expert in this area. Hopefully martin_b will be along soon to put me right. |
|
| Back to top |
|
|
| Gopi Sriram |
| Posted: Mon Nov 28, 2016 6:12 am Post subject: |
|
|
Newbie
Joined: 17 Aug 2015
Posts: 6
|
| timber wrote: |
| Sounds like a bug, but I'm not an expert in this area. Hopefully martin_b will be along soon to put me right. |
Okay, Hope that I will get solution very soon..  |
|
| Back to top |
|
|
|
|
