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 » Search

 Search found 12 matches
Author Message
  Topic: Parser error while parsing special characters using XMLNSC
Sneh4nsu

Replies: 6
Views: 5454

PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Oct 25, 2017 11:13 am   Subject: Parser error while parsing special characters using XMLNSC
Output is having no value

Then there's a bug in my code

My question is does XMLNSC parser automatically escape special characters

Yes

or we need to specify certain encodings

No ...
  Topic: Parser error while parsing special characters using XMLNSC
Sneh4nsu

Replies: 6
Views: 5454

PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Oct 25, 2017 10:43 am   Subject: Parser error while parsing special characters using XMLNSC
What happens if you try:

CREATE LASTCHILD OF OutputRoot DOMAIN('XMLNSC') NAME 'tag' VALUE '&';

Output is having no value
My question is does XMLNSC parser automatically escape ...
  Topic: Parser error while parsing special characters using XMLNSC
Sneh4nsu

Replies: 6
Views: 5454

PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Oct 25, 2017 10:14 am   Subject: Parser error while parsing special characters using XMLNSC
DECLARE my_xml CHARACTER '<tag>&</tag>';
CREATE LASTCHILD OF OutputRoot DOMAIN('XMLNSC')
PARSE(my_xml,546,1208);

Throwing 'An xml parsing error has occurred ...
  Topic: Pass parameters for Select sub-query Inside Passthru
Sneh4nsu

Replies: 2
Views: 2360

PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue Sep 19, 2017 11:20 am   Subject: Pass parameters for Select sub-query Inside Passthru
SET Environment.Variables.po_Bod = PASSTHRU('select dbms_xmlquery.getxml(''select PB.PO_NUM,PB.FACILITY,
cursor(select H.*,cursor(select D.*,cursor(select item.UNIT_OF_M ...
  Topic: Timezone Conversion
Sneh4nsu

Replies: 17
Views: 13528

PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Aug 23, 2017 11:46 am   Subject: Re: Timezone Conversion
InputRoot.Properties.CreationTime
This is coming as GMT timestamp. I need to convert it to timezone same as CURRENT_TIMESTAMP

Congratulations. Is there a question?

Assuming a question of " ...
  Topic: Timezone Conversion
Sneh4nsu

Replies: 17
Views: 13528

PostForum: WebSphere Message Broker (ACE) Support   Posted: Wed Aug 23, 2017 9:52 am   Subject: Timezone Conversion
This function may be of some use to you

https://www.ibm.com/support/knowledgecenter/en/SSMKHH_10.0.0/com.ibm.etools.mft.doc/ak05490_.htm


I'll leave the implementation as an exercise for the ...
  Topic: Timezone Conversion
Sneh4nsu

Replies: 17
Views: 13528

PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue Aug 22, 2017 11:21 pm   Subject: Re: Timezone Conversion
InputRoot.Properties.CreationTime
This is coming as GMT timestamp. I need to convert it to timezone same as CURRENT_TIMESTAMP

Congratulations. Is there a question?

Assuming a question of " ...
  Topic: Timezone Conversion
Sneh4nsu

Replies: 17
Views: 13528

PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon Aug 21, 2017 11:31 pm   Subject: Timezone Conversion
InputRoot.Properties.CreationTime
This is coming as GMT timestamp. I need to convert it to timezone same as CURRENT_TIMESTAMP
  Topic: ESQL Select query
Sneh4nsu

Replies: 8
Views: 11146

PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon Aug 14, 2017 2:50 am   Subject: ESQL Select query
The point about Passthru is that you should put the same query into Passthru as you put into sql developer (or any other db tool), apart from the changing of values into parameter markers ('?'). In yo ...
  Topic: ESQL Select query
Sneh4nsu

Replies: 8
Views: 11146

PostForum: WebSphere Message Broker (ACE) Support   Posted: Fri Aug 11, 2017 5:40 am   Subject: ESQL Select query
inv_hdr_row.INV_HDR_SK);
This is basically the end of the select statement and i am supposed to close the parenthesis only after giving the values corresponding to the respective columns.
  Topic: ESQL Select query
Sneh4nsu

Replies: 8
Views: 11146

PostForum: WebSphere Message Broker (ACE) Support   Posted: Fri Aug 11, 2017 4:57 am   Subject: ESQL Select query
SELECT COMMENT_TYPE_CD FROM INVOICE.INV_COMMENT
WHERE CREATE_TS < CURRENT_TIMESTAMP
AND (LAST_UPDATE_TS IS NULL OR LAST_UPDATE_TS < CURRENT_TIMESTAMP)
...
  Topic: ESQL Select query
Sneh4nsu

Replies: 8
Views: 11146

PostForum: WebSphere Message Broker (ACE) Support   Posted: Fri Aug 11, 2017 3:10 am   Subject: ESQL Select query
SET env.HdrCmntDel[] = PASSTHRU('SELECT COMMENT_TYPE_CD FROM Database.INVOICE.INV_COMMENT
WHERE CREATE_TS < ?
AND (LAST_UPDATE_TS IS NULL OR LAST_UPDATE_TS < ?)
...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
 
 


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

Copyright © MQSeries.net. All rights reserved.