MQSeries.net :: View topic - Stored Procedure call

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Stored Procedure call

Stored Procedure call

« View previous topic :: View next topic »

Author

Message

m_wip

Posted: Wed Apr 07, 2004 2:59 am Post subject: Stored Procedure call

Newbie

Joined: 06 Apr 2004
Posts: 8

Can we call a stored procedure using the Passthru statement in a Compute Node?
i.e.
passthru('exec schema.procname');

where the stored procedure does not take any input parameter.

Do I need to specify the DSN or database name? The broker I'm using has the permissions to execute a SQL on the database(schema).

Thanks!

Missam

Posted: Wed Apr 07, 2004 5:53 am Post subject:

Chevalier

Joined: 16 Oct 2003
Posts: 424

Yes you can use PASSTHRU to call stored procedures.
there is a section defining on how to do this in ESQL reference manual.
look into that

m_wip

Posted: Thu Apr 08, 2004 12:30 am Post subject:

Newbie

Joined: 06 Apr 2004
Posts: 8

Thanks but that is what I referred to.
Using that the proc is not still not executed!

Any help relate dto how to call the stored proc other than what is mentioned in the ESQL ref pdf, will be appreciated

mgk

Posted: Thu Apr 08, 2004 12:51 am Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

PASSTHRU does work for calling stored procedures. Try adding empty braces to your function name as in name().

You can also look as CREATE PROCEDURE which allows you to invoke a stored procedure as well.

Cheers,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.

m_wip

Posted: Thu Apr 08, 2004 10:57 pm Post subject:

Newbie

Joined: 06 Apr 2004
Posts: 8

It worked using the Passthru statement.

thanks!

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Stored Procedure call

Jump to:

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

Protected by Anti-Spam ACP