From: Knut Stolze on
db2 wrote:

> 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.sqlref/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.)

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany