| Author |
Message |
 Topic: DB2 ODBC Error SQL0514 "Cursor not in Prepared State&qu |
Outdesign
Replies: 6
Views: 9903
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Fri May 24, 2002 12:21 am Subject: DB2 ODBC Error SQL0514 "Cursor not in Prepared State&qu |
To clarify the bind point ...
-> If you use the DB Control Center "Create Database Wizard" to create your
database then do *NOT* need to explicity perform the database bind.
-> If you us ... |
| Topic: Renaming of DB2 columns |
Outdesign
Replies: 5
Views: 8886
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue May 21, 2002 4:28 am Subject: Renaming of DB2 columns |
Nick,
Yes, you require WMQIv2.1 to use the Correlation name "OutputLocalEnvironment".
If you are using MQSIv2.0.* then you can use the DestinationList as a
temporary storage area by coding the ... |
| Topic: SQLConnectW return -1 using mqsicreatebroker on Solaris |
Outdesign
Replies: 2
Views: 4545
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jan 25, 2002 7:20 am Subject: SQLConnectW return -1 using mqsicreatebroker on Solaris |
Three things come to mind here ...
1. The IBM Supported Software site does not indicate that MQSeries Integrator Version 2
currently supports DB2 v7.1 FixPack 5 ?
2. How did you installed D ... |
| Topic: Calling Stored Procedure from ESQL. |
Outdesign
Replies: 7
Views: 25801
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jan 24, 2002 10:27 am Subject: Calling Stored Procedure from ESQL. |
The syntax for invoking a stored procedure within MQSI is :
Database Node :
===============
PASSTHRU('call proc_insert(?,?)', Body.Message.Param1, Body.Message.Param2);
In theory you ESQL st ... |
| Topic: broker deletion |
Outdesign
Replies: 1
Views: 3092
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Dec 20, 2001 10:45 am Subject: broker deletion |
The Websphere MQ Integrator Version 2.1 Problem Determination Guide contains a
reference to this on page 44
******
Unable to delete broker after deleting broker database
Scenario: You deleted ... |
| Topic: Adding a DTD reference - a problem ?? |
Outdesign
Replies: 2
Views: 3753
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Dec 18, 2001 4:28 am Subject: Adding a DTD reference - a problem ?? |
Not sure if this answers your question but this is something you may be falling foul of ...
When using messages where the XML and DTD declarations are present it is worth noting
that the DTD eleme ... |
| Topic: Memory allocation failure - MQSI 2.0.2 on SunSolaris |
Outdesign
Replies: 4
Views: 5854
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Dec 03, 2001 4:08 am Subject: Memory allocation failure - MQSI 2.0.2 on SunSolaris |
MQSIv2.0.2 does NOT support DB2v7.2 :
(*)DB2 V7.1 (GA Level) with ODBC driver.
Note: There are known problems with MQSI & DB2 V7.1 FixPack 2a and 3 on SUN Solaris.
There is a valid workaround ... |
| Topic: Updating data in DB2 on Mainframe? |
Outdesign
Replies: 2
Views: 3512
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 29, 2001 2:37 am Subject: Updating data in DB2 on Mainframe? |
YES, this can be done.
There has been a lot of discussion on the subject of MQSIv2 accessing DB2 on OS390.
In summary, yes MQSIv2 can :
-> query DB2 on OS390 (SELECT)
-> update DB2 on OS390 ( ... |
| Topic: Free FTP over MQSeries - maybe |
Outdesign
Replies: 7
Views: 16656
|
Forum: General Discussion Posted: Fri Nov 23, 2001 6:35 am Subject: Free FTP over MQSeries - maybe |
Roger,
Thought you may be interested in this 
http://www-3.ibm.com/software/ts/mqseries/txppacs/ma0p.html
MA0P: MQSeries FTP client
Description
===========
This SupportPac provide ... |
| Topic: MQSI 2.0.1 & MQSI 2.0.2 compability |
Outdesign
Replies: 3
Views: 4403
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Nov 20, 2001 9:25 am Subject: MQSI 2.0.1 & MQSI 2.0.2 compability |
You can successfully run with a mixed environment where you have a v2.0.2
ConfigMgr and Control Center and a v2.0.1 Broker.
However, when deploying from a v2.0.2 ConfigMgr and Control Center to ... |
| Topic: Parameters are not passed to ESQL statements |
Outdesign
Replies: 5
Views: 8966
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Nov 12, 2001 4:38 am Subject: Parameters are not passed to ESQL statements |
George / Gennadi,
With reference to your first post :
===================================
You indicate the following SELECT statement causes an ODBC error, but you do not
supply the details o ... |
| Topic: Insering CDATA in XML messages with ESQL |
Outdesign
Replies: 4
Views: 14407
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 08, 2001 4:51 am Subject: Insering CDATA in XML messages with ESQL |
Luca,
-- Compute node ESQL
SET OutputRoot.XML.(XML.XmlDecl) = '';
SET OutputRoot.XML.(XML.XmlDecl).(XML.Version) = '1.0';
SET OutputRoot.XML.(XML.XmlDecl).(XML.Standalone) = 'yes';
SET Outp ... |
| Topic: ESQL access to mainframe DB2 from MQSIv2.0.1 |
Outdesign
Replies: 19
Views: 23468
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 31, 2001 2:49 am Subject: ESQL access to mainframe DB2 from MQSIv2.0.1 |
Excellent news
|
| Topic: Error code in exceptionlist |
Outdesign
Replies: 1
Views: 3933
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Oct 31, 2001 2:46 am Subject: Error code in exceptionlist |
Kelvin,
Error number 2450 refers to the MQSI error number BIP2450.
The information you are looking for can be found in the files in the
directory (or your equivalent) :
C:Program FilesMQSerie ... |
| Topic: ESQL access to mainframe DB2 from MQSIv2.0.1 |
Outdesign
Replies: 19
Views: 23468
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 30, 2001 7:09 am Subject: ESQL access to mainframe DB2 from MQSIv2.0.1 |
Nick,
QUOTE:
"I've tried overriding this by specifying UID and PWD in the .odbc.ini file but this seems to have no effect."
REPLY:
The userid and and password specified in the .odbc. ... |
