| Author |
Message
|
| Kool-Aid |
 Posted: Fri May 14, 2004 10:51 am Post subject: BIP2430E: Illegal Operands for "NULL" and "NU |
 |
|
Novice
Joined: 22 Apr 2004
Posts: 22
|
BIP2430E: Illegal Operands for "NULL" and "NULL" for concatenation.
What Iam trying to do:
Concatenate multiple input fields placing a single white space in between them.
Example:
SET "OutputRoot"."XML"."GenIntegrationMsg"."GenProfessional"."ListOfAddress"."Address"."AddressLine1"= TRIM("InputBody"."OCF_SAP.IC.ZASSOC"."OCF_SAP.IFC.ZASSOC.Z1KNA1_ASSO"."OFF_SAP.IFF.ZASSOC.Z1KNA1_ADDR"."ZORG1" ||' ' || "InputBody"."OCF_SAP.IC.ZASSOC"."OCF_SAP.IFC.ZASSOC.Z1KNA1_ASSO"."OFF_SAP.IFF.ZASSOC.Z1KNA1_ADDR"."ZORG2");
SET "OutputRoot"."XML"."GenIntegrationMsg"."GenProfessional"."ListOfAddress"."Address"."AddressLine3"=
TRIM("InputBody"."OCF_SAP.IC.ZASSOC"."OCF_SAP.IFC.ZASSOC.Z1KNA1_ASSO"."OFF_SAP.IFF.ZASSOC.Z1KNA1_ADDR"."ZADDRESS2" ||' ' || "InputBody"."OCF_SAP.IC.ZASSOC"."OCF_SAP.IFC.ZASSOC.Z1KNA1_ASSO"."OFF_SAP.IFF.ZASSOC.Z1KNA1_ADDR"."ZDEPARTMENT" || ' ' || "InputBody"."OCF_SAP.IC.ZASSOC"."OCF_SAP.IFC.ZASSOC.Z1KNA1_ASSO"."OFF_SAP.IFF.ZASSOC.Z1KNA1_ADDR"."ZLOC_NAME");
SET "OutputRoot"."XML"."GenIntegrationMsg"."GenProfessional"."ListOfAddress"."Address"."AddressLine4"= TRIM("InputBody"."OCF_SAP.IC.ZASSOC"."OCF_SAP.IFC.ZASSOC.Z1KNA1_ASSO"."OFF_SAP.IFF.ZASSOC.Z1KNA1_ADDR"."ZADDRESS3" ||' ' || "InputBody"."OCF_SAP.IC.ZASSOC"."OCF_SAP.IFC.ZASSOC.Z1KNA1_ASSO"."OFF_SAP.IFF.ZASSOC.Z1KNA1_ADDR"."ZRM_STE" || ' ' || "InputBody"."OCF_SAP.IC.ZASSOC"."OCF_SAP.IFC.ZASSOC.Z1KNA1_ASSO"."OFF_SAP.IFF.ZASSOC.Z1KNA1_ADDR"."PO_BOX");
It is really hard for me to determine if this error is telling me that the actual data contains nulls or whether it is an error with my EQSL statement. Is this an incorrect to code for spaces?
I have used the concatenation operand many times before and this is the first time I got this error. I will say the other times I used this operand I was not trying to code for a single whits space in between fields. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Sat May 15, 2004 3:14 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I'm pretty sure it's telling you that your data fields are null, at least one of them if not more.
It should be fine to use {single-quote][space][single-quote] to represent spaces, since there isn't a SPACES mnemonic or predefined constant to the best of my knowledge.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| fschofer |
| Posted: Sat May 15, 2004 3:34 pm Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
to avoid NULLs and replace them with '' or some other value like 'not found' take a look at the COALESCE function.
Also running a debug trace will show you what happend.
Greetings
Frank |
|
| Back to top |
|
|
| Kool-Aid |
| Posted: Thu May 20, 2004 7:51 am Post subject: Still getting the same errors |
|
|
Novice
Joined: 22 Apr 2004
Posts: 22
|
I ahve tried everything. I made sure that my the fields my data references contain data. I conducted various test that included removing the TRIM statements, and removing parenthesis. I still get the error "Illegal operands 'NULL' and 'NULL' for concatenation operator."
I am taking operands to mean the fields that I am trying to concat. Still nothing. Any other suggestions? |
|
| Back to top |
|
|
| EddieA |
| Posted: Thu May 20, 2004 8:21 am Post subject: |
|
|
Jedi
Joined: 28 Jun 2001
Posts: 2453
Location: Los Angeles
|
| Quote: |
Also running a debug trace will show you what happend.
|
Cheers,
_________________
Eddie Atherton
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| Kool-Aid |
| Posted: Thu May 20, 2004 10:42 am Post subject: THIS ISSUE HAS BEEN RESOLVED |
|
|
Novice
Joined: 22 Apr 2004
Posts: 22
|
| Thanks guys for the advice. I used the debugger and the trace file but it still didn't give me a clear answer. I figured out what was wrong. My code was referencing a field that was mis spelled. Thanks for all your help. I am good to go now. |
|
| Back to top |
|
|
|
|
