| Author |
Message |
 Topic: ERROR :: Invoke SQLServer Stored procedure :: VARYING CURSOR |
raghavendrarao4
Replies: 10
Views: 6552
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 15, 2011 7:28 am Subject: ERROR :: Invoke SQLServer Stored procedure :: VARYING CURSOR |
To re-validate, we modified the DB stored procedure with simple parameters, removed CURSOR/Result set output parameter:
CREATE PROCEDURE retrieveLoanDetails (
IN ONE CHARACTER,
OUT TWO CHARAC ... |
| Topic: ERROR :: Invoke SQLServer Stored procedure :: VARYING CURSOR |
raghavendrarao4
Replies: 10
Views: 6552
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 15, 2011 7:01 am Subject: ERROR :: Invoke SQLServer Stored procedure :: VARYING CURSOR |
We did look at the system requirements earlier  . Our trial runs with fix pack 2 (7.0.0.2) and SQLServer 2000 (SELECT) via ODBC went through , however, got stuck at the stored p ... |
| Topic: ERROR :: Invoke SQLServer Stored procedure :: VARYING CURSOR |
raghavendrarao4
Replies: 10
Views: 6552
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 15, 2011 3:52 am Subject: ERROR :: Invoke SQLServer Stored procedure :: VARYING CURSOR |
We're able to execute SQL SELECT queries against the table on SQL Server 2000, without any issue  . This issue we see is when we invoke the stored procedure  ... |
| Topic: ERROR :: Invoke SQLServer Stored procedure :: VARYING CURSOR |
raghavendrarao4
Replies: 10
Views: 6552
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 14, 2011 8:35 am Subject: ERROR :: Invoke SQLServer Stored procedure :: VARYING CURSOR |
Here is the relevant section from odbc.ini
SQLSERVERDB=DataDirect 6.0 SQL Server Wire Protocol
[D_EDB]
Driver=/usr/WMB70/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 SQL Serv ... |
| Topic: ERROR :: Invoke SQLServer Stored procedure :: VARYING CURSOR |
raghavendrarao4
Replies: 10
Views: 6552
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 14, 2011 8:22 am Subject: ERROR :: Invoke SQLServer Stored procedure :: VARYING CURSOR |
Hi All,
Forgot to mention -
WebSphere Message Broker version - 7.0.0.2 (fix pack 2) on zLinux server. Database :: MS SQL Server 2000 version...
Raghavendra. |
| Topic: ERROR :: Invoke SQLServer Stored procedure :: VARYING CURSOR |
raghavendrarao4
Replies: 10
Views: 6552
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 14, 2011 8:14 am Subject: ERROR :: Invoke SQLServer Stored procedure :: VARYING CURSOR |
Hi All,
The scenario is to invoke a stored procedure on SQL Server with the following definition:
CREATE PROCEDURE [dbo].[PROC1]
-- Add the parameters for th ... |
| Topic: User defined properties(UDP) - configuration issue |
raghavendrarao4
Replies: 1
Views: 1741
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Feb 05, 2007 12:53 pm Subject: User defined properties(UDP) - configuration issue |
A strange issue when using the user defined properties in a subflow:
Following properties are defined in the "User Defined Properties" tab of a subflow:
eventType Type=Strin ... |
| Topic: MQ Error 2039 when using MQPut API within an external Java |
raghavendrarao4
Replies: 1
Views: 5753
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jan 22, 2007 2:47 pm Subject: MQ Error 2039 when using MQPut API within an external Java |
| We get the MQexception 2039 when connecting to the queue manager using Java API provided by MQ. The call to the MQ Java class happens from within the message flow, as an external Java program. MQ put ... |
