| Author |
Message |
 Topic: retrieving REF CURSOR from DB using ESQL |
umaneesh
Replies: 9
Views: 28861
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Tue May 24, 2011 12:12 pm Subject: Resolution? |
Hi,
I remember the issue was with Oracle stored procedure. It started working fine when DB guys fixed it. But broker supports ref_cursor and we captured it like this,
CALL UPDATE_RETR_SP(sp_Id, ... |
| Topic: retrieving REF CURSOR from DB using ESQL |
umaneesh
Replies: 9
Views: 28861
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Apr 14, 2010 8:24 am Subject: retrieving REF CURSOR from DB using ESQL |
nothing worked out. Infact we happened to see this in info center of v6:
Parameters cannot be of the ESQL REFERENCE, ROW, LIST, or INTERVAL data types.
We had changed the stored procedure to h ... |
| Topic: retrieving REF CURSOR from DB using ESQL |
umaneesh
Replies: 9
Views: 28861
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Apr 11, 2010 6:16 pm Subject: retrieving REF CURSOR from DB using ESQL |
In addition to my above response,
Also check that you have enabled the driver option "ProcedureReturnsResults"...[/quote]
I am restricted to see the options. But will get it shortly.
... |
| Topic: retrieving REF CURSOR from DB using ESQL |
umaneesh
Replies: 9
Views: 28861
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Apr 11, 2010 5:02 pm Subject: retrieving REF CURSOR from DB using ESQL |
I would have thought that you'd have to put the result set into a variable of type ROW
He did (effectively) as ROW is just another word for tree...
Yes. This is not working either.
The synt ... |
| Topic: retrieving REF CURSOR from DB using ESQL |
umaneesh
Replies: 9
Views: 28861
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Apr 11, 2010 10:20 am Subject: retrieving REF CURSOR from DB using ESQL |
Hi,
I have a requirement to call an oracle stored procedure which has REF_CURSOR parameter included. I have to retrieve the ref_cursor Stored proc in oracle:
PROCEDURE ORC_SP_DATA (
... |
| Topic: CSV with appended spaces |
umaneesh
Replies: 7
Views: 4261
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Oct 27, 2009 1:46 pm Subject: Re: CSV with appended spaces |
Hi,
I am facing the similar situation here. Need to have padding character as SPACES in CSV simple string elements. It is parsing fine but produces the same without padding.
something like this: ... |
| Topic: Way to handle transactionality with no duplication |
umaneesh
Replies: 4
Views: 3639
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Oct 09, 2009 12:57 pm Subject: Way to handle transactionality with no duplication |
Thanks Jeff L, and Davies.. I have designed for two queues by extracting queue names in excpn list and by backoutCount/MQRC resending msgs to respective failed queue.
Thanks! |
| Topic: Way to handle transactionality with no duplication |
umaneesh
Replies: 4
Views: 3639
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 08, 2009 8:36 am Subject: Way to handle transactionality with no duplication |
You will have to keep track of which ones succeed, and then check before sending out again during retry.
Thanks Jeff 
But how to track the succeded one? On the other way, I can always track t ... |
| Topic: Way to handle transactionality with no duplication |
umaneesh
Replies: 4
Views: 3639
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Oct 08, 2009 7:59 am Subject: Way to handle transactionality with no duplication |
Hi,
My msgflow is to receive one msg and send it [As Is] to different destination queues. The requirement is that, if one destination queue has some issue, the transaction should not get rolled bac ... |
| Topic: how to map sequence with open defined in ESQL |
umaneesh
Replies: 2
Views: 2012
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 23, 2009 12:50 pm Subject: how to map sequence with open defined in ESQL |
Thank you for your response!
It is getting parsed in TDS.
Question is how to parse unknown elements.
I think I need to do some learnings in delaing with unknown elements with esql. With bit ... |
| Topic: how to map sequence with open defined in ESQL |
umaneesh
Replies: 2
Views: 2012
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Sep 23, 2009 11:07 am Subject: how to map sequence with open defined in ESQL |
Hi,
I have an MRM [swift] which actually has a free format after some 4 tags. Finally I have the free format 'sequence' with composition as sequence and content-validation as 'Open defined'.
Ho ... |
| Topic: To Use 'TRIM with Trailing whitespaces' in msgset |
umaneesh
Replies: 2
Views: 2917
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jul 23, 2009 5:28 am Subject: To Use 'TRIM with Trailing whitespaces' in msgset |
Hi,
you can use the property: "Trim on input" --> Trim padding characters in the TDS Format message set properties.
You can change it globally in the MessageSet configuration for your T ... |
| Topic: To Use 'TRIM with Trailing whitespaces' in msgset |
umaneesh
Replies: 2
Views: 2917
|
Forum: WebSphere Message Broker (ACE) Support Posted: Wed Jul 22, 2009 11:23 pm Subject: To Use 'TRIM with Trailing whitespaces' in msgset |
Hi
I have a requirement like this,
Message:
{AIRway caps INTL regular <CR><LF>
Ashoke dalmin lencher <CR><LF>
Amount:1000578,00 <CR><LF>
}
... |
| Topic: Changing node properties from ESQL |
umaneesh
Replies: 2
Views: 3949
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Jun 28, 2009 8:58 am Subject: Changing node properties from ESQL |
Hi,
Is there any ESQL way to change properties in node[MQInput Node, OutputNode, etc] ... In certain scenarios, instead of using RCD's i would like to go with ESQL..
Hope I have one way of doing ... |
| Topic: Keyword 'LANGUAGE' in version 5.1 |
umaneesh
Replies: 1
Views: 1516
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sun Jun 28, 2009 8:02 am Subject: Keyword 'LANGUAGE' in version 5.1 |
Hi,
A straight forward one...
Is LANGUAGE keyword [ESQL] available in V5.1 or V5 broker...
I use WSADIE + V5.1 broker for one of my requirements. I couldnt get this keyword over there.
My ... |
