| Author |
Message |
 Topic: SELECT accessing both DB and MessageTree |
raj_ebiz
Replies: 8
Views: 9170
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Tue Aug 22, 2006 10:20 am Subject: SELECT accessing both DB and MessageTree |
My Broker version is 5 and CSD 05. I am running the locally on Win XP.
I have created a test table in the Broker's database. The database is DB2 8.2.
Table has only 2 rows.
select * from ITEMLIS ... |
| Topic: SELECT accessing both DB and MessageTree |
raj_ebiz
Replies: 8
Views: 9170
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 21, 2006 1:54 pm Subject: SELECT accessing both DB and MessageTree |
Thanks for your response MGK.
The DB has a matching row for my WHERE clause.
Below is a sample ESQL i am testing with.
SELECT T as OrderLine FROM inRef.OrderLine[] as T , Database.ITEM as L W ... |
| Topic: SELECT accessing both DB and MessageTree |
raj_ebiz
Replies: 8
Views: 9170
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Aug 21, 2006 10:58 am Subject: SELECT accessing both DB and MessageTree |
| Still wondering if anyone has done something like this before ? The ESQL reference does say that we can access both DB and MessageTree in the same select statement. |
| Topic: SELECT accessing both DB and MessageTree |
raj_ebiz
Replies: 8
Views: 9170
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Aug 18, 2006 5:58 am Subject: SELECT accessing both DB and Message Tree |
Following is the message i am using. This is just a sample xml i am using in a test flow just to see if it works.
<Order>
<OrderLine>
<LineNum>1</LineNum>
<Ite ... |
| Topic: SELECT accessing both DB and MessageTree |
raj_ebiz
Replies: 8
Views: 9170
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Aug 17, 2006 10:36 am Subject: SELECT accessing both DB and MessageTree |
Hi,
Are there any issues in accessing both Database and Message Tree in the same SELECT statement.
I have a SELECT statement like below
inRef is a pointer to a element in the MessageTree
SEL ... |
| Topic: Z/OS Java Client |
raj_ebiz
Replies: 3
Views: 3770
|
Forum: General IBM MQ Support Posted: Wed Jul 19, 2006 6:09 am Subject: Z/OS Java Client |
| No. The RACF people are having issues in giving me access to the OMVS partition of the mainframe. |
| Topic: Z/OS Java Client |
raj_ebiz
Replies: 3
Views: 3770
|
Forum: General IBM MQ Support Posted: Tue Jul 18, 2006 11:19 am Subject: Z/OS Java Client |
Hi,
Has anyone tried running a MQ Java Client program on Z/OS to read or write messages to queues on queue managers running on distributed platform ? We don't have MQSeries installed on the mainframe ... |
| Topic: CICS Adapter doesnot start Server Subtasks |
raj_ebiz
Replies: 0
Views: 5612
|
Forum: Mainframe, CICS, TXSeries Posted: Thu Mar 27, 2003 6:26 am Subject: CICS Adapter doesnot start Server Subtasks |
Hi,
I am using CICS Transaction Server 1.3 . When CICS comes up, it connects successfully to MQSeries Queue Manager but i donot see the 8 Server sub tasks which get started normally.
So whenever i t ... |
| Topic: MQCICS Bridge , CSQC723E Error for Pseudo Conversation |
raj_ebiz
Replies: 2
Views: 3366
|
Forum: General IBM MQ Support Posted: Wed Jan 29, 2003 6:07 am Subject: MQCICS Bridge , CSQC723E Error for Pseudo Conversation |
Thanks for the explanation. I was under the impression that the Bridge Monitor worries only about the CorrelId . I didnot know that the MsgId is used by bridge for cleanup. It all makes sense now.
... |
| Topic: Different Regions for CICS Bridge |
raj_ebiz
Replies: 4
Views: 4217
|
Forum: General IBM MQ Support Posted: Tue Jan 28, 2003 7:00 am Subject: Different Regions for CICS Bridge |
| If you specify MQRO_EXCEPTION in your MQMD report options, the Bridge sends a exception message to the replyto queue specified in your MQMD, when there is abend in the linked program. |
| Topic: MQCICS Bridge , CSQC723E Error for Pseudo Conversation |
raj_ebiz
Replies: 2
Views: 3366
|
Forum: General IBM MQ Support Posted: Tue Jan 28, 2003 6:45 am Subject: MQCICS Bridge , CSQC723E Error for Pseudo Conversation |
Hi All,
We are using the MQ-CICS Bridge to invoke a pseudo conv. 3270 txn on CICS.
The Mainframe environment is Z/OS V1.1,MQ 5.2 and CICS TS 2.1 .
The following is our scenario.
A message co ... |
