By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,226 Members | 1,032 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,226 IT Pros & Developers. It's quick & easy.

Examples wanted

P: n/a
I am trying to find examples of two things that I don't see discussed in the
IBM manuals. I was wondering if the readers of this newsgroup could help me
by giving me some examples or at least pointing to examples that might
already exist somewhere.

I would like to find examples of two things:
1. an SQL PL stored procedure that invokes another program that is NOT a
stored procedure, for example a standalone client program.
2. an SQL PL stored procedure that sends a message to MQSERIES.

The SQL PL procedure will be running in DB2 for Windows/Linux/Unix on
Version 8.2.

Rhino
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Rhino wrote:
I would like to find examples of two things:
1. an SQL PL stored procedure that invokes another program that is NOT a
stored procedure, for example a standalone client program.


Obviously you have to leave the DB2 environment and go to the OS-level to do
whatever you want to do. You can find some examples here:

http://www-128.ibm.com/developerwork....html#section5

--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena
Nov 12 '05 #2

P: n/a
Knut Stolze wrote:
Rhino wrote:

I would like to find examples of two things:
1. an SQL PL stored procedure that invokes another program that is NOT a
stored procedure, for example a standalone client program.

Obviously you have to leave the DB2 environment and go to the OS-level to do
whatever you want to do. You can find some examples here:

http://www-128.ibm.com/developerwork....html#section5

And here for MQ:
http://www-128.ibm.com/developerwork...08wolfson.html

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

P: n/a
Thank you, Serge, that is much appreciated!

Rhino

"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:3l*************@individual.net...
Knut Stolze wrote:
Rhino wrote:

I would like to find examples of two things:
1. an SQL PL stored procedure that invokes another program that is NOT a
stored procedure, for example a standalone client program.

Obviously you have to leave the DB2 environment and go to the OS-level to do whatever you want to do. You can find some examples here:

http://www-128.ibm.com/developerwork....html#section5

And here for MQ:

http://www-128.ibm.com/developerwork...08wolfson.html
Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Nov 12 '05 #4

P: n/a
Thanks very much, Knut! That looks like exactly what the doctor ordered ;-)

Rhino

"Knut Stolze" <st****@de.ibm.com> wrote in message
news:dd**********@lc03.rz.uni-jena.de...
Rhino wrote:
I would like to find examples of two things:
1. an SQL PL stored procedure that invokes another program that is NOT a
stored procedure, for example a standalone client program.
Obviously you have to leave the DB2 environment and go to the OS-level to

do whatever you want to do. You can find some examples here:

http://www-128.ibm.com/developerwork....html#section5
--
Knut Stolze
Information Integration Development
IBM Germany / University of Jena

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.