| Author |
Message |
 Topic: Parser error while parsing special characters using XMLNSC |
Sneh4nsu
Replies: 6
Views: 6756
|
 Forum: 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: 6756
|
Forum: 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: 6756
|
Forum: 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: 3034
|
Forum: 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: 17724
|
Forum: 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: 17724
|
Forum: 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: 17724
|
Forum: 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: 17724
|
Forum: 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: 23448
|
Forum: 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: 23448
|
Forum: 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: 23448
|
Forum: 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: 23448
|
Forum: 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 < ?)
... |
