| Author |
Message |
 Topic: Mapping xs:Datetime with timezone. |
zhumingvictor
Replies: 10
Views: 4605
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 01, 2013 10:07 am Subject: Mapping xs:Datetime with timezone. |
The XSD format in the output is xs:DateTime.
Does it specify a lexical representation that includes a timezone qualifier? or does it specify the default lexical representation?
The XSD doesn't r ... |
| Topic: Mapping xs:Datetime with timezone. |
zhumingvictor
Replies: 10
Views: 4605
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 01, 2013 9:46 am Subject: Mapping xs:Datetime with timezone. |
| I know I can using compute node to replace the Mapping node, but a simple mapping node can save me lots coding and Mapping node is more clear to look at and easier to understand for the developer who ... |
| Topic: Mapping xs:Datetime with timezone. |
zhumingvictor
Replies: 10
Views: 4605
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 01, 2013 8:51 am Subject: Mapping xs:Datetime with timezone. |
| The input is a string in format of yyyyMMdd and I am coverting it to timestamp in using custome esql in Mapping node. The output is a xs:DateTime format. I tried to cast the date string to GMTTimestam ... |
| Topic: Mapping xs:Datetime with timezone. |
zhumingvictor
Replies: 10
Views: 4605
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 01, 2013 8:15 am Subject: Mapping xs:Datetime with timezone. |
| Hi, I am using a SOAPRequest node to send request, before I send the request I have to do a data mapping using Mapping node. But the WS I am calling requires xs:DateTime with timezone info e.g. 2013-0 ... |
| Topic: How to select all leaf node from xml |
zhumingvictor
Replies: 11
Views: 5440
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 29, 2013 12:00 pm Subject: How to select all leaf node from xml |
you need to use nested selects and then you don't need to loop.
something like
SET MY_COUNT= SELECT
( SELECT COUNT(*)
FROM I.transactions.transaction
It works!  I don't need each item ... |
| Topic: How to select all leaf node from xml |
zhumingvictor
Replies: 11
Views: 5440
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 29, 2013 7:39 am Subject: How to select all leaf node from xml |
Set a reference. InputRoot.XMLNSC.myroot.batches
Then iterate through, selecting batch
No way to do it without looping through? |
| Topic: How to select all leaf node from xml |
zhumingvictor
Replies: 11
Views: 5440
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 29, 2013 7:29 am Subject: How to select all leaf node from xml |
Hi I am trying to do:
SET MY_COUNT= (SELECT COUNT(*)
FROM InputRoot.XMLNSC.myroot.batches.batch.transactions.transactionSyntax error : cannot specify '
Anybody know how I can correct this?
... |
| Topic: Output CSV with column headers. |
zhumingvictor
Replies: 2
Views: 2526
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 18, 2013 7:00 am Subject: Output CSV with column headers. |
Hi,
I am working a a project that selects some columns and output as a CSV file. What I did is defined a DFDL model for the output csv and user a resetcontent descriptor to reset it as csv. All tho ... |
| Topic: How to get PARSE statement working with DFDL |
zhumingvictor
Replies: 20
Views: 19915
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 28, 2013 5:48 am Subject: How to get PARSE statement working with DFDL |
Using debug changes the way the message tree is handled. Take a user trace instead.
If it's the same problem as this, follow the same advice as this thread & raise a PMR.
But it will work if I ... |
| Topic: How to get PARSE statement working with DFDL |
zhumingvictor
Replies: 20
Views: 19915
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 28, 2013 5:41 am Subject: How to get PARSE statement working with DFDL |
Anybody found a solution for this?
Solution to what? Unless you describe your problem we can't know if it's actually the same problem.
Solution for the exact same problem this thread talked about. ... |
| Topic: How to get PARSE statement working with DFDL |
zhumingvictor
Replies: 20
Views: 19915
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 28, 2013 4:59 am Subject: How to get PARSE statement working with DFDL |
| Anybody found a solution for this? |
| Topic: Access udp from mapping node in subflow |
zhumingvictor
Replies: 19
Views: 16015
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 20, 2013 12:19 pm Subject: Access udp from mapping node in subflow |
Is the ESQL statement that creates the UDB in the same subflow as the mapping node/udp?
Are they all in the same broker schema with the accessor function?
Did you set the value of the UDP on the ... |
| Topic: Access udp from mapping node in subflow |
zhumingvictor
Replies: 19
Views: 16015
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 20, 2013 9:02 am Subject: Access udp from mapping node in subflow |
Is the ESQL statement that creates the UDB in the same subflow as the mapping node/udp?
Are they all in the same broker schema with the accessor function?
Did you set the value of the UDP on the ... |
| Topic: Access udp from mapping node in subflow |
zhumingvictor
Replies: 19
Views: 16015
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 20, 2013 8:20 am Subject: Access udp from mapping node in subflow |
is it build from the command line using mqsicreatebar or mqsipackagebar?
We use mqsicreatebar |
| Topic: Access udp from mapping node in subflow |
zhumingvictor
Replies: 19
Views: 16015
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 20, 2013 6:57 am Subject: Access udp from mapping node in subflow |
All environments are 8.0.0.3. The UDPs are defined in the same flow as mapping node.
Actually the bar file was build using command line, at the beginning we build it using default parameters which ... |
