Author |
Message |
Topic: MQAttach for MQ FTE |
anvanzyl
Replies: 1 Views: 3811
|
Forum: General IBM MQ Support Posted: Thu Apr 22, 2010 3:05 pm Subject: MQAttach for MQ FTE |
Hi,
Has anyone used a product called MQAttach (from http://www.mqattach.com) for administration of MQFTE?
We are busy implementing MQFTE and have been advised by IBM to use MQAttach for MQFTE ad ... |
Topic: Zero Iteration Count Err when I call Oracle Stored Procedure |
anvanzyl
Replies: 14 Views: 15907
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun May 13, 2007 7:33 pm Subject: Zero Iteration Count Err when I call Oracle Stored Procedure |
Firstly, not sure which version of WBIMB you are using, but my comments are based on V5.
I see that when calling your stored procedure you are passing 6 parameters but the definition only specifies 5 ... |
Topic: Monitor WBI |
anvanzyl
Replies: 3 Views: 2971
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Feb 01, 2007 8:33 pm Subject: Monitor WBI |
If you have a tight budget you could write your own shell scripts to check Broker processes ( and/or execution groups, database, and whatever other integration application processes) and report via e- ... |
Topic: ESQL Help |
anvanzyl
Replies: 7 Views: 6450
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 09, 2006 1:31 pm Subject: ESQL Help |
One possibility would be to define a CWF message containing a simple integer type and one complex type matching the structure of your input message (including the CR or LF as applicable) (this type se ... |
Topic: esql - Overlay |
anvanzyl
Replies: 2 Views: 4502
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 16, 2006 11:32 pm Subject: esql - Overlay |
Thanks! Makes perfect sense now. |
Topic: esql - Overlay |
anvanzyl
Replies: 2 Views: 4502
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 16, 2006 9:51 pm Subject: esql - Overlay |
Hi,
Please have a look at the following esql code:
declare V1 char '0123456789';
declare pad_V1 char '00000';
set V1 = overlay(pad_V1 placing V1 from 1 for 5);
from this I expected the resu ... |
Topic: Message Broker 6 connecting to SAP |
anvanzyl
Replies: 2 Views: 3670
|
Forum: General Discussion Posted: Sun Aug 06, 2006 7:24 pm Subject: Message Broker 6 connecting to SAP |
Hi,
I have used the R3Link to integrate applications via MQSI 2.1 to SAP before. My current customer uses WBIMB V5 and the WBI SAP Adapter to integrate with SAP. The following features make the WBI a ... |
Topic: JDBC Adapter Parameter Type |
anvanzyl
Replies: 1 Views: 2574
|
Forum: WebSphere Interchange Server + Adapters Posted: Tue Jul 18, 2006 10:12 pm Subject: JDBC Adapter Parameter Type |
using "IO" works.
 |
Topic: JDBC Adapter Parameter Type |
anvanzyl
Replies: 1 Views: 2574
|
Forum: WebSphere Interchange Server + Adapters Posted: Tue Jul 18, 2006 6:04 pm Subject: JDBC Adapter Parameter Type |
Hi,
I use the JDBC adapter (with WBIMB) to execute an Oracle Stored procedure. One of the parameters is "IN OUT" type (ie used as input, modified and returned). What I want to know is how I indicate ... |
Topic: JDBC adapter usage |
anvanzyl
Replies: 5 Views: 3912
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 05, 2006 3:09 pm Subject: JDBC adapter usage |
Hi,
In V5 you would also use the JDBC adapter if you are calling an external DB stored procedure with BLOB, CLOB, or user defined type parameters. (Using the ODA to discover the procedure and gener ... |
Topic: Version 5.0 Migration Issue |
anvanzyl
Replies: 3 Views: 2663
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 05, 2006 2:44 pm Subject: Version 5.0 Migration Issue |
Hi,
Where do you see "Unresolved database Refrences"? I would assume you are looking at the "Tasks" window in the toolkit and that they appear as "Warnings" in which case you can ignore them - will ... |
Topic: External Oracle Procedure Call |
anvanzyl
Replies: 3 Views: 4395
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu May 11, 2006 3:30 pm Subject: External Oracle Procedure Call |
Thanks for the responses guys. I suppose its back to the drawing board for me then.  |
Topic: External Oracle Procedure Call |
anvanzyl
Replies: 3 Views: 4395
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed May 10, 2006 8:45 pm Subject: External Oracle Procedure Call |
Hi,
I am trying to call the following external Oracle procedure from a WBIMB v5 (CSD4) message flow:
(schema 'ABC')
CREATE OR REPLACE PROCEDURE GET_COMP_ID (O_status OUT VARCHAR2,
... |
Topic: SAP - MQ Link Issue |
anvanzyl
Replies: 2 Views: 2632
|
Forum: General Discussion Posted: Tue Mar 07, 2006 3:04 pm Subject: SAP - MQ Link Issue |
I am not sure exactly what the problem is. What adapter are you using to get the data into SAP? When you say the data dictionary changes, I assume you are refering to SAP IDOC segment structure as thi ... |
Topic: Websphere Adapter for SAP - IDOC number response |
anvanzyl
Replies: 7 Views: 8059
|
Forum: General Discussion Posted: Wed Feb 22, 2006 9:31 pm Subject: Websphere Adapter for SAP - IDOC number response |
You can't get any information back to the broker with inbound IDOC transfers to SAP (other than the status update which is returned in the RFH header)... However, I suppose you can check the RFC trace ... |