| Author |
Message |
 Topic: transform arbitrarily timestamp of type dateTime |
msiegert
Replies: 9
Views: 8308
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 18, 2013 7:19 am Subject: transform arbitrarily timestamp of type dateTime |
thanks, the 'IU' advice helped.
The code:
SET OutputRoot...date =
CAST(OutputRoot...date AS GMTTIMESTAMP FORMAT 'IU') + LOCAL_TIMEZONE;
does what it should, finally pretty simple.
For a ... |
| Topic: transform arbitrarily timestamp of type dateTime |
msiegert
Replies: 9
Views: 8308
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 18, 2013 6:15 am Subject: transform arbitrarily timestamp of type dateTime |
yes, but now I'm getting an error:
<Insert Type="5" Text="'2013-12-10T23:54:55.033+01:00'"></Insert><Insert Type="5" Text="GMTTIMESTAMP">&l ... |
| Topic: ESQL TIMESTAMP |
msiegert
Replies: 2
Views: 7810
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 18, 2013 6:08 am Subject: ESQL TIMESTAMP |
I know your post is quite a long time ago, but have you ever got any advice?
I'm having the same problem now. |
| Topic: transform arbitrarily timestamp of type dateTime |
msiegert
Replies: 9
Views: 8308
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 18, 2013 4:18 am Subject: transform arbitrarily timestamp of type dateTime |
Hi!
Thanks for your replies.
My requirement is that I need to calculate/transform/convert ...
an incoming dateTime
e.g.
2013-12-10T07:54:55.033-06:00
to an outgoing dateTime
2013-12-10T14:54:55 ... |
| Topic: RouteToLabel and Label |
msiegert
Replies: 7
Views: 7251
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Jun 21, 2009 10:28 pm Subject: RouteToLabel and Label |
...thanks so far. All I wanted to know is, if it is possible to route messages from one flow to another flow (not subflow) using RouteToLabel an Label. And like I expected, it is not possible.
rega ... |
| Topic: RouteToLabel and Label |
msiegert
Replies: 7
Views: 7251
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Jun 20, 2009 11:43 pm Subject: RouteToLabel and Label |
..OK, but in my case the flow which contains the Label nodes isn't a subflow from the flow which contains the RouteToLabel Flow.
The esql in the compute node which sets up the routerlist contains th ... |
| Topic: RouteToLabel and Label |
msiegert
Replies: 7
Views: 7251
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Jun 20, 2009 12:55 pm Subject: RouteToLabel and Label |
Hi all!
One silly question:
it's still not possible (even with WMB 6.103) to route messages via RouteToLabel and Label Nodes when Label Nodes aren't in the same flow as the RouteToLabel Node, rig ... |
| Topic: BLOB into Character |
msiegert
Replies: 2
Views: 3600
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 03, 2003 6:00 am Subject: BLOB into Character |
it worked after setting
SET FieldA= CAST(InputRoot.XML.FieldA AS BLOB CCSID 1208 ENCODING 546);
and using the OVERLAY function
WHILE POSITION('e282ac' IN FieldA) > 0 DO
SET FieldA = OVE ... |
| Topic: BLOB into Character |
msiegert
Replies: 2
Views: 3600
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 03, 2003 1:25 am Subject: BLOB into Character |
Hi there!
I'm using the CAST function to transform the value of one data type into another data type, in my case first it is Character into BLOB and afterwards the BLOB field should come up as a no ... |
| Topic: MQSeries on Cluster Tru64 V5.1A |
msiegert
Replies: 0
Views: 3682
|
Forum: Clustering Posted: Fri Jan 10, 2003 12:27 am Subject: MQSeries on Cluster Tru64 V5.1A |
Hi!
I'm trying to set up MQ on a Tru64 V5.1A machine. I did it like is is discribed in the Redbook: Configuring MQSeries with Compaq TruCluster V5.1.
On machine A everything is fine, but while tr ... |
| Topic: Import / export function via command line with MQSI |
msiegert
Replies: 1
Views: 3626
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 20, 2002 7:07 am Subject: Import / export function via command line with MQSI |
Hi folks!
My question is:
is there an opportunity to import or export msg flows in MQSI via the command line like you can do with msg sets?
I'm working with MQSI Version 2.01 and 2.1
Thank ... |
| Topic: return code 20 |
msiegert
Replies: 2
Views: 7259
|
Forum: General IBM MQ Support Posted: Tue Dec 18, 2001 12:54 am Subject: return code 20 |
Hi!
We are running MQ 5.1 CSD06 on NT4.0 SP5.
The NT event log doesn't say anything at the time the error occurs.
Executing runmqchi from the cmd line says:
Programme unable to open queuemanager ... |
| Topic: return code 20 |
msiegert
Replies: 2
Views: 7259
|
Forum: General IBM MQ Support Posted: Mon Dec 17, 2001 8:21 am Subject: return code 20 |
Can anyone help with return code 20?
I haven't found anything yet.
Thanks Marc
-------------------------------------------------------------------------------
12/15/01 05:11:16
AMQ7880: Erro ... |
| Topic: MQSeries on SUN Solaris server cluster |
msiegert
Replies: 1
Views: 11355
|
Forum: IBM MQ Installation/Configuration Support Posted: Wed Dec 05, 2001 3:50 am Subject: MQSeries on SUN Solaris server cluster |
Hi!
What is to consider when installing and configuring MQSeries 5.2 on a SUN Solaris server cluster of two SunOS 5.8 machines?
I know there is a support pack for a AIX Cluster with HACMP, but i ... |
| Topic: TCP/IP error |
msiegert
Replies: 2
Views: 14224
|
Forum: IBM MQ Installation/Configuration Support Posted: Thu Nov 29, 2001 3:52 am Subject: TCP/IP error |
Hi!
While trying to connect from an NT MQSeries Client to a SUN Solaris QMGR Version 5.2 I get the TCP/IP : 10060 (X'274C') error.
What does ut mean? I couldn't anything yet.
The listener is ru ... |
