| Author |
Message
|
| Lex |
 Posted: Wed Nov 29, 2006 6:38 am Post subject: Interacting with Sybase DB |
 |
|
Acolyte
Joined: 14 Nov 2006
Posts: 73
|
Hi,
I have migrated flows from version 2.1 to the message broker toolkit 6.0.
We interact with sybase DB in our flows. Therefore, some user-defined node have been created in order to handle this type of database in the 2.1 version. Indeed, we are calling a stored procedure and it was not supported in 2.1 for Sybase DB.
Now that i have migrated my flows, i have some problem with theses nodes, and i was wondering if there was a new way to interact with a Sybase DB in the version 6.0. Maybe a new type of Node or something like that?
Any clue would be appreciated  |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Nov 29, 2006 6:59 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| mgk |
| Posted: Wed Nov 29, 2006 7:32 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hi,
Yes, Sybase stored procedures are now supported on V6, just use a regular compute node to talk to sybase like anyother DB.
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| Lex |
| Posted: Thu Nov 30, 2006 7:57 am Post subject: |
|
|
Acolyte
Joined: 14 Nov 2006
Posts: 73
|
Thanks for the quick response!
What is the pattern in order to call a stored procedure for Sybase in a ESQL file? |
|
| Back to top |
|
|
| JosephGramig |
| Posted: Thu Nov 30, 2006 8:12 am Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
|
| Back to top |
|
|
| Lex |
| Posted: Thu Nov 30, 2006 9:40 am Post subject: |
|
|
Acolyte
Joined: 14 Nov 2006
Posts: 73
|
Hi,
I checked my odbc.ini file and everything is correct and cool.
I Call the procedure like it is said but when i try and look at the trace, i obtain a return code of -1 from odbc.
Any clue what the problem is? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Nov 30, 2006 9:50 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
A return code of -1 is non-specific.
Examine the entire error message.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
