| Author |
Message |
 Topic: multiple databases from 1 compute in V6 |
waugh
Replies: 3
Views: 4206
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon Oct 02, 2006 10:39 am Subject: multiple databases from 1 compute in V6 |
same platform/fix level too... that is some information.... 
I have also ran into this issue and found the following in the infocenter:
|
| Topic: multiple databases from 1 compute in V6 |
waugh
Replies: 3
Views: 4206
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Sep 29, 2006 4:11 am Subject: multiple databases from 1 compute in V6 |
When i try to access 2 databases from compute node, seeing below error.
When we do that, do they need to be of same type?
1 is oracle, 1 is sql server. So, i had to split the compute into two.
... |
| Topic: Returning result sets from Oracle Database Stored Procedure |
waugh
Replies: 9
Views: 22074
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue May 09, 2006 9:43 am Subject: Returning result sets from Oracle Database Stored Procedure |
| I meant to write CARDINALITY(Environment.ResultSet[]); had lower case s there. |
| Topic: Returning result sets from Oracle Database Stored Procedure |
waugh
Replies: 9
Views: 22074
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue May 09, 2006 6:00 am Subject: trace output |
thanks for your help.
After tracing i noticed there is a spelling mistake in the below statement.
SET OutputRoot.XML.totalrecords = CARDINALITY(Environment.ResultSet[]); |
| Topic: Returning result sets from Oracle Database Stored Procedure |
waugh
Replies: 9
Views: 22074
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon May 08, 2006 11:00 am Subject: zero records |
Thanks gmk,
i changed procedure definition to
CREATE PROCEDURE storeproctest() DYNAMIC RESULT SETS 1 EXTERNAL NAME "dbo.GetTransactionRecords" ;
then procedure call to
CALL storeproctest ... |
| Topic: Returning result sets from Oracle Database Stored Procedure |
waugh
Replies: 9
Views: 22074
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri May 05, 2006 11:48 am Subject: SQL server store procedure |
I am using v6 broker.
I tried this SQL server stored procedure. No parameters required.
with
CREATE PROCEDURE storeproctest() EXTERNAL NAME "dbo.GetTransactionRecords" ;
then
CALL store ... |
| Topic: Deploy POLL |
waugh
Replies: 23
Views: 12337
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Apr 27, 2006 11:59 am Subject: not a fan of complete deploys |
not a fan of complete deploys
My reservations:
1) version control will be tough when you change only one flow and do a complete deploy of all N flows running on that EG. (may introduce new error ... |
| Topic: Calling a web service using a HTTPRequest node |
waugh
Replies: 9
Views: 9105
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 07, 2005 7:58 am Subject: Calling a web service using a HTTPRequest node |
Dude,
The documentation on WBI Info Center will surely help you...
http://publib.boulder.ibm.com/infocenter/wbihelp/index.jsp
search for HttpInputNode and other nodes....
I did the same few da ... |
| Topic: WBIMB DB2 ODBC connection test |
waugh
Replies: 4
Views: 4192
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 07, 2005 5:26 am Subject: WBIMB DB2 ODBC connection test |
| does your sql work from normal DB2 SQL prompt? did you try debugging that flow. it will give you exact exception which will be helpful in solving your problem. I think your ODBC is fine as your deploy ... |
| Topic: WBIMB DB2 ODBC connection test |
waugh
Replies: 4
Views: 4192
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 07, 2005 4:46 am Subject: WBIMB DB2 ODBC connection test |
Rohit,
try this command,
demoodbc -UID userid -PWD password datasourcename |
| Topic: Adding broker to broker domain |
waugh
Replies: 1
Views: 2769
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 24, 2005 4:34 am Subject: Adding broker to broker domain |
Vivek,
There is no command that does this.
What is the reason you dont want to do this in toolkit? |
| Topic: Correlation problem |
waugh
Replies: 3
Views: 3548
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 23, 2005 4:45 am Subject: Correlation problem |
| FIELD TYPE BLOB SIZE 24 BYTES SHOULD WORK, this is on WINDOWS/UNIX+DB2 |
| Topic: broker delete |
waugh
Replies: 9
Views: 6548
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 22, 2005 6:17 am Subject: broker delete |
Standalone windows installation:
1)install DB2, it will ask you for user id/password you want to use as part of the installation. choose a userid/password.
2)if u r not already logged in as that ... |
| Topic: WBIMB V5 Toolkit problems |
waugh
Replies: 2
Views: 3295
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 22, 2005 6:00 am Subject: WBIMB V5 Toolkit problems |
| try solution from http://www.mqseries.net/phpBB2/viewtopic.php?t=19844&highlight=hangs |
| Topic: inserting records into database. |
waugh
Replies: 7
Views: 6974
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jun 22, 2005 5:51 am Subject: inserting records into database. |
bugsbunny,
r u running V5 version?
first of all try running that exact insert SQL on database using DB2 command line processor or some tool to see if it inserts a row. |
