Author |
Message |
Topic: XML Sorting |
ANorm
Replies: 2 Views: 1700
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 22, 2008 7:18 pm Subject: XML Sorting |
Task:
Sort XML message (multiple records) by CustomerName then output XML message by CustomerName & TotalValue.
Eg,
Input message (multiple records):
<?xml version="1.0" encod ... |
Topic: Timestamp Format |
ANorm
Replies: 10 Views: 5051
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Jul 13, 2003 11:16 am Subject: Timestamp Format |
Great idea . I will use the SUBSTRING function to extract data and create a new string into desired format.
However, I would appreciate further help with the logic to append the am/pm .
... |
Topic: Timestamp Format |
ANorm
Replies: 10 Views: 5051
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Jul 13, 2003 6:40 am Subject: Timestamp Format |
Could you please provide the ESQL?
Thank you. |
Topic: Timestamp Format |
ANorm
Replies: 10 Views: 5051
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Jul 12, 2003 7:07 pm Subject: Timestamp Format |
In WMQI, using substring & timestamp I got yyyy-mm-dd hh:mm:ss.
I like to get timestamp in the following format:
mm/dd/yy hh:mm:ss am or pm
Thanks |
Topic: xml to mrm |
ANorm
Replies: 6 Views: 3027
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 22, 2003 1:02 am Subject: xml to mrm |
Thanks for the reply.
In this situation the number of repeat is a variable as indicated by
the value of <Count> tag. For this particular message(as shown in my orignal posting), count=3.
It ... |
Topic: xml to mrm |
ANorm
Replies: 6 Views: 3027
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon May 19, 2003 5:38 pm Subject: xml to mrm |
Hi Egils,
Thanks for the reply. Could you please explain the [index]. |
Topic: xml to mrm |
ANorm
Replies: 6 Views: 3027
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 15, 2003 4:57 pm Subject: xml to mrm |
I need to map xml to mrm fields. However I have problem with repeating field.
Input is xml, need to output to fixed length
The input xml repeating could have one or more but will have a tag to i ... |