| Author |
Message |
 Topic: Extracting data from Apache Cassandra in IIBv9 |
wmb_wps_soa
Replies: 0
Views: 1217
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 16, 2016 7:38 am Subject: Extracting data from Apache Cassandra in IIBv9 |
Hello All,
I have a requirement to extract data from Apache Cassandra from IIBv9.0.0.3. While exploring the integration options, i figured out we can put the client API jars in IIB shared-class to ... |
| Topic: SAP Adapter issue |
wmb_wps_soa
Replies: 4
Views: 2988
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 16, 2016 7:36 am Subject: SAP Adapter issue |
Hello,
Thats a good response. "customer does not exist in master record, error code: F2890".
You need to check with your SAP folks on this.
Thanks
SJ |
| Topic: Calling java procedure that uses Dataobject input |
wmb_wps_soa
Replies: 4
Views: 1842
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 29, 2015 6:10 am Subject: Calling java procedure that uses Dataobject input |
Thanks mqjeff,
I will try that one. |
| Topic: Calling java procedure that uses Dataobject input |
wmb_wps_soa
Replies: 4
Views: 1842
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 29, 2015 6:02 am Subject: Calling java procedure that uses Dataobject input |
Thanks timber.
Its not for iDoc or anyother adapter. The java code is taken from WESB as part of WESB to IIBv10 migration. In the java code, its using an API to perform database operations (client ... |
| Topic: Calling java procedure that uses Dataobject input |
wmb_wps_soa
Replies: 4
Views: 1842
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 29, 2015 5:45 am Subject: Calling java procedure that uses Dataobject input |
Hi All,
I am trying to call a java procedure from ESQL (IIBv10). Java method has a DataObject (commonj.sdo.DataObject) input parameter, and I am passing a tree as REFERENCE while calling the java p ... |
| Topic: FileRead Component |
wmb_wps_soa
Replies: 3
Views: 2714
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 17, 2014 10:45 pm Subject: FileRead Component |
Did you update your broker runtime version using mqsichangebroker command?
Run mqsireportbroker <brokername> to see the Fixpack capability level. If its not 7.0.0.3 then you will need to run ... |
| Topic: SHARED ROW Variable - To update/delete |
wmb_wps_soa
Replies: 3
Views: 3578
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 17, 2014 11:57 am Subject: SHARED ROW Variable - To update/delete |
Thanks Vitor.
I am making the flow as a single threaded flow. As there is no way to update the data in SHARED ROW using a single statement, I tried to use looping to update counter in the matching ... |
| Topic: SHARED ROW Variable - To update/delete |
wmb_wps_soa
Replies: 3
Views: 3578
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Dec 17, 2014 11:37 am Subject: SHARED ROW Variable - To update/delete |
Hi All,
Can we update OR delete the data that is in SHARED ROW variable list? I know, I can make the SHARED ROW empty and reload it, but my requirement is not to empty the whole SHARED ROW, but to ... |
| Topic: Overloding Oracle procedures |
wmb_wps_soa
Replies: 9
Views: 3839
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 30, 2014 2:03 pm Subject: Overloding Oracle procedures |
Sorry it was a mismatch in my declaration in the broker code. After I fixed it, everything started working with the wrapper stored procedure.
Summary:
Wrapper stored procedure Name # ABC in packa ... |
| Topic: Overloding Oracle procedures |
wmb_wps_soa
Replies: 9
Views: 3839
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 30, 2014 10:49 am Subject: Overloding Oracle procedures |
The issue that I am talking about is in WMBV7005.
The wrapper stored procedure that the DBA created has the same name as the overloaded stored procedures(2 stored procedure with same name, one wit ... |
| Topic: Overloding Oracle procedures |
wmb_wps_soa
Replies: 9
Views: 3839
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 30, 2014 9:02 am Subject: Overloding Oracle procedures |
Thank you both.,
So I assume its not supported in IIBV9 either.
I have a scenario, where the DBA created a wrapper stored procedure with an unique name which calls the overloaded procedure inte ... |
| Topic: Overloding Oracle procedures |
wmb_wps_soa
Replies: 9
Views: 3839
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jul 29, 2014 1:21 pm Subject: Overloding Oracle procedures |
Hi All,
Does anyone knows if overloaded oracle procedure is supported in IIBv9 OR IIBv10 via ODBC?
Thanks
SJ |
| Topic: Adding Seconds to 20140720T164607 ('yyyyMMdd''T''HHmmss') |
wmb_wps_soa
Replies: 2
Views: 1938
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 24, 2014 9:09 am Subject: Adding Seconds to 20140720T164607 ('yyyyMMdd''T''HHmmss') |
Thanks mqjeff. I got it working with the below CAST'ng.
DECLARE currentTimeFormated TIMESTAMP CAST('20140720164607' AS TIMESTAMP FORMAT 'yyyyMMddHHmmss');
Note: Had to remove the 'T' |
| Topic: Adding Seconds to 20140720T164607 ('yyyyMMdd''T''HHmmss') |
wmb_wps_soa
Replies: 2
Views: 1938
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 24, 2014 7:53 am Subject: Adding Seconds to 20140720T164607 ('yyyyMMdd''T''HHmmss') |
Having an issue with adding SECOND to the input timestamp comes as string.
Input Timestamp(Character type) = 20140720T164607
Input Timestamp Format = 'yyyyMMdd''T''HHmmss'
In-order to add the ... |
| Topic: Passthru function for Update/Insert with dynamic/multiple DB |
wmb_wps_soa
Replies: 1
Views: 2386
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Feb 02, 2014 2:53 pm Subject: Passthru function for Update/Insert with dynamic/multiple DB |
Hi Guys,
I am having an issue using Passthru function as I want to use it with dynamic DSN to use two different SQL database operations in the same compute node, but it is not working and I could n ... |
