ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Check for missing tags

Post new topic  Reply to topic
 Check for missing tags « View previous topic :: View next topic » 
Author Message
LH33
PostPosted: Wed Mar 19, 2003 6:51 am    Post subject: Check for missing tags Reply with quote

Master

Joined: 21 Nov 2002
Posts: 200
HI!

I have to check for the existence of a tag and if it doesn't exist, create the output tag and populate it with a Default value of '9999' I am using the NULL check, but when I test with XML that does not have the tag, it still does not create it. Can someone take a loojk at my code and see what I am doing wrong? Thank you!! LisaB

IF (InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 IS NULL)
THEN
CREATE FIELD OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1;
SET OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 = '9999';
END IF;
Back to top
View user's profile Send private message
granthmuk
PostPosted: Wed Mar 19, 2003 7:47 am    Post subject: Reply with quote

Apprentice

Joined: 16 May 2001
Posts: 38
Location: Edinburgh, Scotland
Try it without the Create Field line, not sure why you would need this for what you are doing and the SET should create the field anyway which is maybe why you are having a problem. Code would then be:
Code:
IF (InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 IS NULL)
THEN
SET OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 = '9999';
END IF;
Back to top
View user's profile Send private message
LH33
PostPosted: Wed Mar 19, 2003 7:53 am    Post subject: Reply with quote

Master

Joined: 21 Nov 2002
Posts: 200
I tried your code suggestion and it still did not work. I also need to check this tag to see if it contains any data. I check for the tag = ' ' and when I send spaces down in teh XML it doesn't work either. Here is my code for both checks: Thanks LisaB

IF (InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 IS NULL)
THEN
SET OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 = '9999';
END IF;

IF (InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 = ' ')
THEN
SET OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 = '9999';
END IF;
Back to top
View user's profile Send private message
granthmuk
PostPosted: Wed Mar 19, 2003 7:57 am    Post subject: Reply with quote

Apprentice

Joined: 16 May 2001
Posts: 38
Location: Edinburgh, Scotland
Could you post the whole of your ESQL? Are you copying InputRoot to OutputRoot? Also what does the rest of your flow do?
Back to top
View user's profile Send private message
LH33
PostPosted: Wed Mar 19, 2003 8:02 am    Post subject: Reply with quote

Master

Joined: 21 Nov 2002
Posts: 200
Sure! It does a lot of Data transformations. It's a rather long ESQL. The two in question are at the end of the ESQL. The rest of it works fine. Thanks!!

SET OutputRoot = InputRoot;
-- Enter SQL below this line. SQL above this line might be regenerated, causing any modifications to be lost.
--The following Business Logic is documented in the Complete ODl Job Use Case.

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_DISTRICT_CODE =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_DISTRICT_CODE
WHEN 'HOWARD' THEN 'H'
WHEN 'BELAIR' THEN 'B'
WHEN 'COCKEYSVIL' THEN 'C'
WHEN 'GLENBURNIE' THEN 'G'
WHEN 'WESTMINSTE' THEN 'W'
WHEN 'FRONTST' THEN 'F'
WHEN 'ANNAPOLIS' THEN 'A'
END;

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_OWNERSHIP_ID =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_MUNICIPALITY
WHEN 'OTHER' THEN 1
WHEN 'AACO' THEN 2
WHEN 'BALTCITY' THEN 3
WHEN 'BALTCO' THEN 4
WHEN 'CALCO' THEN 5
WHEN 'CARRCO' THEN 6
WHEN 'HARCO' THEN 7
WHEN 'HOWCO' THEN 8
WHEN 'MONTCO' THEN 9
WHEN 'PGCO' THEN 10
WHEN 'STHIGH' THEN 11
END;

If InputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_LIGHT_TYPE = 'STLT' THEN
set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_STLT_FLAG = 'Y';
set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_PAL_FLAG = 'N';
End if;

If InputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_LIGHT_TYPE = 'PAL' THEN
set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_STLT_FLAG = 'N';
set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_PAL_FLAG = 'Y';
End if;

If InputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_PROXIMITY = 'REAR' THEN
Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_REAR_FLAG = 'Y';
end if;

If InputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_PROXIMITY <> 'REAR' THEN
Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_REAR_FLAG = 'N';
end if;

If InputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_ORIGIN = 'GUI' THEN
set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_ROUTED_FLAG = 'Y';
set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_PICKUP_FLAG = 'N';
End if;

If InputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_ORIGIN <> 'GUI' THEN
set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_ROUTED_FLAG = 'N';
set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_PICKUP_FLAG = 'Y';
End if;

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_RELATED_INFORMATION.ODL_BURNING_OK =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_RELATED_INFORMATION.ODL_BURNING_OK
WHEN 'SERVICED' THEN 'RS'
WHEN 'GOODVOLT' THEN 'HG'
WHEN 'SOCKETVOLT' THEN 'SV'
END;

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_RELATED_INFORMATION.ODL_BGE_NOT_MAINTAIN =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_RELATED_INFORMATION.ODL_BGE_NOT_MAINTAIN
WHEN 'ROMEX' THEN 'RW'
WHEN 'UNFFIXPOL' THEN 'UF'
WHEN 'OTHER' THEN 'OT'
END;

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_RELATED_INFORMATION.ODL_PHOTOCELL_LOC =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_RELATED_INFORMATION.ODL_PHOTOCELL_LOC
WHEN 'ATFIXTURE' THEN 'PF'
WHEN 'ATRELAY' THEN 'PR'
WHEN 'TIMER' THEN 'TP'
END;

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_RELATED_INFORMATION.ODL_LOC_LOOSE_CONN =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_RELATED_INFORMATION.ODL_LOC_LOOSE_CONN
WHEN 'BASE' THEN 'BS'
WHEN 'BUSS' THEN 'BW'
WHEN 'CLAMP' THEN 'CL'
WHEN 'FIXTURE' THEN 'FI'
WHEN 'FUSEHOLDER' THEN 'FH'
WHEN 'LOOP' THEN 'LP'
WHEN 'RELAY' THEN 'RL'
WHEN 'PHOTOCELL' THEN 'PC'
WHEN 'OTHER' THEN 'OT'
END;

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_RELATED_INFORMATION.ODL_FUSE_LOC =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_RELATED_INFORMATION.ODL_FUSE_LOC
WHEN 'BASE' THEN 'BS'
WHEN 'POWERPOST' THEN 'PP'
WHEN 'RELAY' THEN 'RL'
END;

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_PRIORITY_CODE =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_PRIORITY_CODE
WHEN 60 THEN 1
WHEN 70 THEN 3
WHEN 80 THEN 7
END;

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_SECONDARY_STREET =
SUBSTRING (InputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_DESC_LOC
FROM 1 for 50);

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_SECONDARY_HOUSE_NUMBER =
SUBSTRING (InputRoot.XML.CompleteOdlJob.DataArea.ODL_OTHER_INFORMATION.ODL_DESC_LOC
FROM 51 for 50);

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_DIAGNOSIS_CODE_1 =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_DIAGNOSIS_CODE_1
WHEN 'ADJUSTPAL' THEN 'AP'
WHEN 'ARM' THEN 'AR'
WHEN 'BADLOC' THEN 'BL'
WHEN 'BALLAST' THEN 'BA'
WHEN 'BASEPLATE' THEN 'BP'
WHEN 'BULB' THEN 'BU'
WHEN 'BURNINGOK' THEN 'OK'
WHEN 'CABLEFAULT' THEN 'CA'
WHEN 'CANOPY' THEN 'CN'
WHEN 'DUPLEX' THEN 'DP'
WHEN 'DUPLICATE' THEN 'SA'
WHEN 'FIXTURE' THEN 'FI'
WHEN 'FUSE' THEN 'FS'
WHEN 'FUSEKIT' THEN 'FK'
WHEN 'GLOBE' THEN 'GL'
WHEN 'PANEL' THEN 'PN'
WHEN 'LOOSECONN' THEN 'LK'
WHEN 'MADESAFE' THEN 'MS'
WHEN 'NEWCONST' THEN 'NC'
WHEN 'NOPHONE' THEN 'PH'
WHEN 'NOTBGEEQ' THEN 'NB'
WHEN 'PHOTOCELL' THEN 'PC'
WHEN 'PHOTORECEP' THEN 'PL'
WHEN 'POLE' THEN 'OT'
WHEN 'SHORTCAP' THEN 'SC'
WHEN 'STARTER' THEN 'ST'
WHEN 'TURNOFF' THEN 'TR'
WHEN 'TURNON' THEN 'TO'
WHEN 'TWINWIRE' THEN 'TW'
WHEN 'OTHER' THEN 'OT'
WHEN 'PATROL' THEN 'OT'
END;

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_DIAGNOSIS_CODE_2 =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_DIAGNOSIS_CODE_2
WHEN 'ADJUSTPAL' THEN 'AP'
WHEN 'ARM' THEN 'AR'
WHEN 'BADLOC' THEN 'BL'
WHEN 'BALLAST' THEN 'BA'
WHEN 'BASEPLATE' THEN 'BP'
WHEN 'BULB' THEN 'BU'
WHEN 'BURNINGOK' THEN 'OK'
WHEN 'CABLEFAULT' THEN 'CA'
WHEN 'CANOPY' THEN 'CN'
WHEN 'DUPLEX' THEN 'DP'
WHEN 'DUPLICATE' THEN 'SA'
WHEN 'FIXTURE' THEN 'FI'
WHEN 'FUSE' THEN 'FS'
WHEN 'FUSEKIT' THEN 'FK'
WHEN 'GLOBE' THEN 'GL'
WHEN 'PANEL' THEN 'PN'
WHEN 'LOOSECONN' THEN 'LK'
WHEN 'MADESAFE' THEN 'MS'
WHEN 'NEWCONST' THEN 'NC'
WHEN 'NOPHONE' THEN 'PH'
WHEN 'NOTBGEEQ' THEN 'NB'
WHEN 'PHOTOCELL' THEN 'PC'
WHEN 'PHOTORECEP' THEN 'PL'
WHEN 'POLE' THEN 'OT'
WHEN 'SHORTCAP' THEN 'SC'
WHEN 'STARTER' THEN 'ST'
WHEN 'TURNOFF' THEN 'TR'
WHEN 'TURNON' THEN 'TO'
WHEN 'TWINWIRE' THEN 'TW'
WHEN 'OTHER' THEN 'OT'
WHEN 'PATROL' THEN 'OT'
END;

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_DIAGNOSIS_CODE_3 =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_DIAGNOSIS_CODE_3
WHEN 'ADJUSTPAL' THEN 'AP'
WHEN 'ARM' THEN 'AR'
WHEN 'BADLOC' THEN 'BL'
WHEN 'BALLAST' THEN 'BA'
WHEN 'BASEPLATE' THEN 'BP'
WHEN 'BULB' THEN 'BU'
WHEN 'BURNINGOK' THEN 'OK'
WHEN 'CABLEFAULT' THEN 'CA'
WHEN 'CANOPY' THEN 'CN'
WHEN 'DUPLEX' THEN 'DP'
WHEN 'DUPLICATE' THEN 'SA'
WHEN 'FIXTURE' THEN 'FI'
WHEN 'FUSE' THEN 'FS'
WHEN 'FUSEKIT' THEN 'FK'
WHEN 'GLOBE' THEN 'GL'
WHEN 'PANEL' THEN 'PN'
WHEN 'LOOSECONN' THEN 'LK'
WHEN 'MADESAFE' THEN 'MS'
WHEN 'NEWCONST' THEN 'NC'
WHEN 'NOPHONE' THEN 'PH'
WHEN 'NOTBGEEQ' THEN 'NB'
WHEN 'PHOTOCELL' THEN 'PC'
WHEN 'PHOTORECEP' THEN 'PL'
WHEN 'POLE' THEN 'OT'
WHEN 'SHORTCAP' THEN 'SC'
WHEN 'STARTER' THEN 'ST'
WHEN 'TURNOFF' THEN 'TR'
WHEN 'TURNON' THEN 'TO'
WHEN 'TWINWIRE' THEN 'TW'
WHEN 'OTHER' THEN 'OT'
WHEN 'PATROL' THEN 'OT'
END;

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_DIAGNOSIS_CODE_4 =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_DIAGNOSIS_CODE_4
WHEN 'ADJUSTPAL' THEN 'AP'
WHEN 'ARM' THEN 'AR'
WHEN 'BADLOC' THEN 'BL'
WHEN 'BALLAST' THEN 'BA'
WHEN 'BASEPLATE' THEN 'BP'
WHEN 'BULB' THEN 'BU'
WHEN 'BURNINGOK' THEN 'OK'
WHEN 'CABLEFAULT' THEN 'CA'
WHEN 'CANOPY' THEN 'CN'
WHEN 'DUPLEX' THEN 'DP'
WHEN 'DUPLICATE' THEN 'SA'
WHEN 'FIXTURE' THEN 'FI'
WHEN 'FUSE' THEN 'FS'
WHEN 'FUSEKIT' THEN 'FK'
WHEN 'GLOBE' THEN 'GL'
WHEN 'PANEL' THEN 'PN'
WHEN 'LOOSECONN' THEN 'LK'
WHEN 'MADESAFE' THEN 'MS'
WHEN 'NEWCONST' THEN 'NC'
WHEN 'NOPHONE' THEN 'PH'
WHEN 'NOTBGEEQ' THEN 'NB'
WHEN 'PHOTOCELL' THEN 'PC'
WHEN 'PHOTORECEP' THEN 'PL'
WHEN 'POLE' THEN 'OT'
WHEN 'SHORTCAP' THEN 'SC'
WHEN 'STARTER' THEN 'ST'
WHEN 'TURNOFF' THEN 'TR'
WHEN 'TURNON' THEN 'TO'
WHEN 'TWINWIRE' THEN 'TW'
WHEN 'OTHER' THEN 'OT'
WHEN 'PATROL' THEN 'OT'
END;

Set OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_DIAGNOSIS_CODE_5 =
CASE InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_DIAGNOSIS_CODE_5
WHEN 'ADJUSTPAL' THEN 'AP'
WHEN 'ARM' THEN 'AR'
WHEN 'BADLOC' THEN 'BL'
WHEN 'BALLAST' THEN 'BA'
WHEN 'BASEPLATE' THEN 'BP'
WHEN 'BULB' THEN 'BU'
WHEN 'BURNINGOK' THEN 'OK'
WHEN 'CABLEFAULT' THEN 'CA'
WHEN 'CANOPY' THEN 'CN'
WHEN 'DUPLEX' THEN 'DP'
WHEN 'DUPLICATE' THEN 'SA'
WHEN 'FIXTURE' THEN 'FI'
WHEN 'FUSE' THEN 'FS'
WHEN 'FUSEKIT' THEN 'FK'
WHEN 'GLOBE' THEN 'GL'
WHEN 'PANEL' THEN 'PN'
WHEN 'LOOSECONN' THEN 'LK'
WHEN 'MADESAFE' THEN 'MS'
WHEN 'NEWCONST' THEN 'NC'
WHEN 'NOPHONE' THEN 'PH'
WHEN 'NOTBGEEQ' THEN 'NB'
WHEN 'PHOTOCELL' THEN 'PC'
WHEN 'PHOTORECEP' THEN 'PL'
WHEN 'POLE' THEN 'OT'
WHEN 'SHORTCAP' THEN 'SC'
WHEN 'STARTER' THEN 'ST'
WHEN 'TURNOFF' THEN 'TR'
WHEN 'TURNON' THEN 'TO'
WHEN 'TWINWIRE' THEN 'TW'
WHEN 'OTHER' THEN 'OT'
WHEN 'PATROL' THEN 'OT'
END;

IF (InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 IS NULL)
THEN
SET OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 = '9999';
END IF;

IF (InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 = ' ')
THEN
SET OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 = '9999';
END IF;
Back to top
View user's profile Send private message
granthmuk
PostPosted: Wed Mar 19, 2003 8:10 am    Post subject: Reply with quote

Apprentice

Joined: 16 May 2001
Posts: 38
Location: Edinburgh, Scotland
Do you have any tracing in your flow? Also what are you results are you actually getting?
I'd recommend you add a trace node after the compute with tracing of at least
Code:

Root:
${Root}
LocalEnv:
${LocalEnvironment}
Env:
${Environment}
Back to top
View user's profile Send private message
LH33
PostPosted: Wed Mar 19, 2003 8:18 am    Post subject: Reply with quote

Master

Joined: 21 Nov 2002
Posts: 200
Yes, I have a trace node after that node. Here are the test conditions and the results that I get:

1. I send the tag through with valid data and the results are what is expected.

2. I send the tag through with spaces in it and I expect to get the default of '9999', but the output tag has spaces.

3. I send the tag with nothing in it and I get the expected results.

4. I don't send the tag at all and I want to create the output tag with '9999', however it doesn't create it.

Thanks a lot for your help!!
Back to top
View user's profile Send private message
kirani
PostPosted: Wed Mar 19, 2003 9:17 am    Post subject: Reply with quote

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
Lisa,

This is how you can check different values in the XML tags

Code:

-- Tag not present
IF (XMLTagName IS NULL ) THEN
...
END IF;

-- Tag present but contains no value For example, <XMLTag/> or <XMLTag></XMLTag>
IF (XMLTagName = '' ) THEN
...
END IF;

-- Check for SPACE char in first position
IF (SUBSTRING(XMLTagName FROM 1 FOR 1) = ' ') THEN
...
END IF;

_________________
Kiran


IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries

Back to top
View user's profile Send private message Visit poster's website
LH33
PostPosted: Wed Mar 19, 2003 9:38 am    Post subject: Reply with quote

Master

Joined: 21 Nov 2002
Posts: 200
Kiran,

Thanks!! Is something wrong with the following code becasue when I test it without the tag it doesn't work:

IF (InputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 IS NULL)
THEN
SET OutputRoot.XML.CompleteOdlJob.DataArea.ODL_LIGHT_INFORMATION.ODL_KY_LAMP_NO1 = '9999';
END IF;

Thanks for all your help!
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Wed Mar 19, 2003 9:48 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
It may also be helpful to check for 'NULL' when working with the XML domain, particularly when you are copying values into an XML tree from outside the XML tree (a database, the Environment, etc).

Code:
IF (XMLTagName = 'NULL') then
...
END IF;
Back to top
View user's profile Send private message
kirani
PostPosted: Wed Mar 19, 2003 10:10 am    Post subject: Reply with quote

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
Lisa,

May be your Tag name is spelled incorrectly. Please verify your tag name with the Tag names in the Trace file.
Also, try taking a trace log for your message flow using mqsireadlog and mqsiformatlog commands, you will see more details in the trace log.
_________________
Kiran


IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries

Back to top
View user's profile Send private message Visit poster's website
autorun
PostPosted: Fri Mar 28, 2003 10:53 am    Post subject: Reply with quote

Apprentice

Joined: 02 Feb 2002
Posts: 29
Hi All
I have similar problem but I think it is related with MQSI/WMQI version. I am trying to add my observation and find a solution to my problem as well.

In MQSI 2.02, we checked the existance of tag by:

IF( tagname IS NULL ) THEN...

But this code doesnt work anymore since we upgraded to WMQI 2.1. Same code seems to be checking for existance of value associated with the tag. I am faced with massisve rewrite( counting the tag and comparing to zero ) since I use this type of check all over the place. Does anyone know any way to make the code behave the same way easily ?

I'd love to get some explaination to my observation as well.

Thanks
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Check for missing tags
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.