| Author |
Message |
 Topic: IIB with WTX integration |
Fresher_Newbie
Replies: 3
Views: 5346
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 17, 2015 4:06 am Subject: IIB with WTX integration |
We could use each others help. I have a similar problem.
We have a WTX map that accepts SJIS encoded input IDOC from SAP using MDMP where the input and output type tree is set to Western/Native. ... |
| Topic: Timeout Control Node - Navigation failed |
Fresher_Newbie
Replies: 6
Views: 5508
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 15, 2015 10:58 pm Subject: Timeout Control Node - Navigation failed |
You are partially right. The InputRoot.XMLNSC.TimeoutRequest is there, but it seems like it can't find it.
The reason is probably this:
I generate a Timeout Request message using a compute nod ... |
| Topic: Timeout Control Node - Navigation failed |
Fresher_Newbie
Replies: 6
Views: 5508
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 15, 2015 5:42 am Subject: Timeout Control Node - Navigation failed |
I'm sending a Timeout request message.
InputRoot.XMLNSC.TimeoutRequest - This is the request location - from where it gets to access the Timeout Request tree.
I don't think it has a problem fi ... |
| Topic: Timeout Control Node - Navigation failed |
Fresher_Newbie
Replies: 6
Views: 5508
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 15, 2015 5:22 am Subject: Timeout Control Node - Navigation failed |
Hey guys,
I'm getting the following error from the TimeOut Control node.
Exception Is:
( ['MQROOT' : 0x119004130]
(0x01000000:Name):RecoverableException ... |
| Topic: Functions on TIMESTAMP/TIME data type. |
Fresher_Newbie
Replies: 1
Views: 1964
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 07, 2015 6:21 am Subject: Functions on TIMESTAMP/TIME data type. |
Hello guys,
Is there any way I can use a MOD function (or something equivalent) on a TIME or a TIMESTAMP datatype value to check if it is in multiple of 15 minutes?
Also anybody know how to ro ... |
| Topic: IIB v9.0.0.1 Error: Pattern Authoring Project Builder |
Fresher_Newbie
Replies: 4
Views: 5720
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jul 27, 2015 2:05 am Subject: Error during Build |
Sorry to re-open this again, but didn't want to create a new topic for the same problem.
I'm getting the following error when I try to import things (Existing Project, Project Interchange etc.) in ... |
| Topic: Convert ESQL TIMESTAMP format to Oracle TIMESTAMP format |
Fresher_Newbie
Replies: 9
Views: 14248
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 26, 2015 12:41 pm Subject: Convert ESQL TIMESTAMP format to Oracle TIMESTAMP format |
Addidng the 'a' did it.
mqjeff - I needed to use it in the SELECT statement to retrieve some records off the ORACLE database, where the TIMESTAMP coloumn is stored in dd-MMM-yy hh.mm.ss.SSSSSSSSS ... |
| Topic: Convert ESQL TIMESTAMP format to Oracle TIMESTAMP format |
Fresher_Newbie
Replies: 9
Views: 14248
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 26, 2015 12:09 pm Subject: Convert ESQL TIMESTAMP format to Oracle TIMESTAMP format |
HH gives you the 24 hour format
hh gives you the 12 hour format, but neither with an AM/PM marker.
Hmm, all right I'll look it up, again. Thanks! |
| Topic: Convert ESQL TIMESTAMP format to Oracle TIMESTAMP format |
Fresher_Newbie
Replies: 9
Views: 14248
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 26, 2015 11:49 am Subject: Convert ESQL TIMESTAMP format to Oracle TIMESTAMP format |
@fjp
Thanks, I've done the same as shown below:
SET CUR_T = CAST(CURRENT_TIMESTAMP AS CHARACTER FORMAT 'dd-MMM-yy hh.mm.ss.SSSSSSSSS');
But also need to include the AM/PM part. How do I do t ... |
| Topic: Convert ESQL TIMESTAMP format to Oracle TIMESTAMP format |
Fresher_Newbie
Replies: 9
Views: 14248
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 26, 2015 10:26 am Subject: Convert ESQL TIMESTAMP format to Oracle TIMESTAMP format |
Hello folks,
Is there any way I can convert the value returned by the CURRENT_TIMESTAMP function (Ex: 2015-06-26 08:30:00.000000) in ESQL to ORACLE TIMESTAMP format (Ex: 26-JUN-15 08.30.00.0000000 ... |
| Topic: Using ESQL to select and insert multiple rows. |
Fresher_Newbie
Replies: 5
Views: 9406
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 25, 2015 10:44 pm Subject: Using ESQL to select and insert multiple rows. |
@fjb_saper - Oh yes, my bad. It should be the way you've mentioned it.
@mgk - Thanks, I'll look into doing it the way you suggested. |
| Topic: Using ESQL to select and insert multiple rows. |
Fresher_Newbie
Replies: 5
Views: 9406
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 24, 2015 10:59 pm Subject: Using ESQL to select and insert multiple rows. |
Thanks Nelson, but since the query involves the usage of the count(*), and GROUP BY functions, the normal select and insert isn't ideal.
I explored the PASSTHRU function, but I'm just not able to ... |
| Topic: Using ESQL to select and insert multiple rows. |
Fresher_Newbie
Replies: 5
Views: 9406
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 24, 2015 3:24 am Subject: Using ESQL to select and insert multiple rows. |
Hello folks,
I need to select multiple rows from one table and insert the selected rows into another table in the same database. I have the Orcacle/SQL query for that, and is as follows:
INSER ... |
