|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
IS NOT NULL |
« View previous topic :: View next topic » |
Author |
Message
|
chanduy9 |
Posted: Tue Oct 04, 2005 1:13 pm Post subject: IS NOT NULL |
|
|
Disciple
Joined: 28 Nov 2001 Posts: 177 Location: USA
|
Hi,
I have migrated the code from 2.1 to 5.0.6, the code was working fine in the 2.1 for all conditions, i have a statement as shown below:
IF ("InputBody"."EIGHT_BYTE_TAG_ELEM"[I]."CLOCHOS_TAG_ELEM"."CLOCHOS_ELEM" IS NOT NULL)
THEN
--do some transformations
END IF;
The above shown code is working fine (as expected) in 2.1 and the same code is working in reverse in the 5.0, even if i have some elements under CLOCHOS_ELEM it is treating has no elements. If I remove the condition the code is workign fine..i mean transformation(parsing) is working fine..here is the trace:
(0x01000013):CLOCHOS_TAG_ELEM = (
(0x0300000B):RESPONSE_TYPE = '00'
(0x01000013):CLOCHOS_ELEM = (
(0x0300000B):HOLDING_COMPANY_NUMBER = '10002'
(0x0300000B):V560_WRK_NAME_1 = 'XXXXXXX'
(0x0300000B):V560_CIF_TIE_BREAKER_N = '1'
(0x0300000B):V560_CIF_CUST_NO = 'XXXXXXXX'
(0x0300000B):V560_CIF_SSN_TAXID_IND = '0'
(0x0300000B):X90003_SSN_TAXID = 'XXXXXXXX'
(0x0300000B):V561_ADF_ADR_1 = 'XXXXXXXXXX'
(0x0300000B):V561_ADF_CITY = 'XXXXXXX'
(0x0300000B):V561_ADF_STATE = 'MI'
(0x0300000B):V561_ADF_ZIP_CODE = 'XXXXXXX'
(0x0300000B):V560_CIF_CUST_DATE_OF_BIRTH = 'XXXXXX'
(0x0300000B):V560_CIF_CUST_STATUS = 'XX'
(0x0300000B):V560_CIF_ID1_DESCRIPT = 'XXXXXX'
(0x0300000B):V560_CIF_ID1_TYPE = 'XX'
)
when run the same code with IS NULL it is working fine...
'InputBody.EIGHT_BYTE_TAG_ELEM[I].CLOCHOS_TAG_ELEM.CLOCHOS_ELEM IS NULL' at (, 47.79). The result was 'TRUE'.
Is there any changes I need to do..i know the code should work in 5.0....there is no errors are warnings while migrating..
Thanks in advace,
Chandra. _________________ Chandra,
IBM WebSphere MQ Certified. |
|
Back to top |
|
 |
elvis_gn |
Posted: Tue Oct 04, 2005 8:53 pm Post subject: |
|
|
 Padawan
Joined: 08 Oct 2004 Posts: 1905 Location: Dubai
|
Well i dont think the code is wrong....great discovery, right
Anyway, try removing the quotes....
Also the CLOCHOS_ELEM is a complex type ???
Check is the condition is failing when even one of the sub fields have a NULL value ...... |
|
Back to top |
|
 |
chanduy9 |
Posted: Wed Oct 05, 2005 12:00 pm Post subject: |
|
|
Disciple
Joined: 28 Nov 2001 Posts: 177 Location: USA
|
Hi,
I removed the quotes...but there is no luck...the code is working fine in 2.1
Thanks,
Chandra. _________________ Chandra,
IBM WebSphere MQ Certified. |
|
Back to top |
|
 |
elvis_gn |
Posted: Wed Oct 05, 2005 8:22 pm Post subject: |
|
|
 Padawan
Joined: 08 Oct 2004 Posts: 1905 Location: Dubai
|
I noticed that you are using a EIGHT_BYTE_TAG_ELEM"[I].....
I understand that the same code works for 2.1 but can u check if the segment [I] has an existing CLOCHOS_ELEM....
What does the flow debug show you ??
try to do a
IF ("InputBody"."EIGHT_BYTE_TAG_ELEM"[I]."CLOCHOS_TAG_ELEM"."CLOCHOS_ELEM"."HOLDING_COMPANY_NUMBER" IS NOT NULL) |
|
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
|
|
|
|