Any body could help me out on DB2 stored procedure on Z/OS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db2 - 09 Jan 2008 08:11 GMT

Hi,
I have heard that stored procedure on Z/OS can be written on
assembler language only. Can any body could help me out on DB2 stored
procedure on Z/OS. If you recommend me any materials, that would be
great helpful for me.

Thanks,
Joseph
http://db2examples.googlepages.com

Reply to this Message

Knut Stolze - 09 Jan 2008 12:58 GMT

> Hi,
> I have heard that stored procedure on Z/OS can be written on
> assembler language only.

This is not correct. You can use pretty much any of the common languages
these days. Have a look at the manuals:
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.sq
lref/db2z_sql_createprocedureexternal.htm

There is a clause LANGUAGE, which must be used to specify the programming
language of the external module (because it determines language
environment, for example).

> Can any body could help me out on DB2 stored
> procedure on Z/OS. If you recommend me any materials, that would be
> great helpful for me.

There is a red book available:
http://www.redbooks.ibm.com/abstracts/sg247083.html

(The book is currently in the process of being updated.)

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message

db2 - 10 Jan 2008 05:46 GMT

Thanks a lot.
Regards,
Joseph
http://db2examples.googlepages.com

> > Hi,
> > I have heard that stored procedure on Z/OS can be written on
[quoted text clipped - 19 lines]
> DB2 z/OS Utilities Development
> IBM Germany

Reply to this Message