| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| External Sybase Stored Procedure Returns No values |
« View previous topic :: View next topic » |
| Author |
Message
|
| kiruthigeshwar |
 Posted: Sat Sep 07, 2013 3:11 am Post subject: External Sybase Stored Procedure Returns No values |
 |
|
Acolyte
Joined: 31 Oct 2012
Posts: 50
|
Hi All,
I am calling an external stored procedure in sybase. it returned no response in return. This was using ODBC from esql/java nodes. But using jdbc from java I am able to retreive the resultset. But in the later case initially i was asked to run in unchained mode. And it worked then (SET CHAINED OFF).
But when I used the same in esql and odbc, it still not working. Pleae help me with this.
_________________
Regards,
K |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Sat Sep 07, 2013 4:46 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
We'd like to help but apart from telling us your problem we don't have any detail of the failing ESQL Code.
How about positng some more indormation?
Are you getting an error back from Sybase when you try the ESQL operation? If so, what is the error?
You really have to give us more details on your problem.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| dogorsy |
| Posted: Sat Sep 07, 2013 10:04 pm Post subject: |
|
|
Knight
Joined: 13 Mar 2013
Posts: 553
Location: Home Office
|
| Get a debug user trace, that will show the call , the parameters passed and what is returned, either values or error. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
