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 » General Discussion » Processing Instruction in XML using ESQL

Post new topic  Reply to topic
 Processing Instruction in XML using ESQL « View previous topic :: View next topic » 
Author Message
John_peter
PostPosted: Mon May 10, 2004 9:51 am    Post subject: Processing Instruction in XML using ESQL Reply with quote

Novice

Joined: 10 May 2004
Posts: 22

I want to add a prosessing instruction
SET OutputRoot.XML.(XML.ProcessingInstruction) = 'ibd version="1.4"'

But I get a space after the '?' in the output


<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<? ibd version="1.4"?>
Back to top
View user's profile Send private message
bower5932
PostPosted: Mon May 10, 2004 10:09 am    Post subject: Reply with quote

Jedi Knight

Joined: 27 Aug 2001
Posts: 3023
Location: Dallas, TX, USA

Try posting in WMQI Support index. You'll get a better chance of getting an answer.
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger
KimT
PostPosted: Tue May 11, 2004 9:30 am    Post subject: Reply with quote

Novice

Joined: 07 May 2004
Posts: 17
Location: Hartford, CT

I just found out you cannot have a PI outside your outer tags. You can set Environment.Variables.String1 and Environment.Variables.String2 then RCD to blob, next concatenate, RCD to xml again.

Under the concatenate compute node:

SET OutputRoot."BLOB"."BLOB" = CAST ((Environment.Variables.STRING1 || Environment.Variables.STRING2 || CAST (InputBody."BLOB" AS CHAR CCSID InputRoot.Properties.CodedCharSetId)) AS BLOB CCSID InputRoot.Properties.CodedCharSetId);


That's how I got it to work. Good Luck!
Back to top
View user's profile Send private message
KimT
PostPosted: Wed May 12, 2004 4:27 am    Post subject: Reply with quote

Novice

Joined: 07 May 2004
Posts: 17
Location: Hartford, CT

SET OutputRoot.XML.OT.(XML.ProcessingInstruction)ibd = 'version="1.4"';

where OT is your outer tag name

this is the correct format to use for a PI, sorry forgot to put it in the first reply
Back to top
View user's profile Send private message
John_peter
PostPosted: Sat May 15, 2004 5:26 am    Post subject: Reply with quote

Novice

Joined: 10 May 2004
Posts: 22

KimT wrote:
SET OutputRoot.XML.OT.(XML.ProcessingInstruction)ibd = 'version="1.4"';

where OT is your outer tag name

this is the correct format to use for a PI, sorry forgot to put it in the first reply


Perfect !! That Worked!Thanks!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General Discussion » Processing Instruction in XML using ESQL
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.