View Single Post

   
  #2 (permalink)  
Old 02-27-2008, 03:29 AM
Knut Stolze
 
Posts: n/a
Default Re: DB2 7.2 Z/OS - Functions - Where's the Function source text stored

wfs wrote:

> Hi All,
>
> I've defined a few functions to DB2.


Functions with LANGUAGE SQL or an external programming language like C/C++
or Java?

For language SQL functions you might want to look at SYSCAT.ROUTINES.TEXT.

> I can see the entries in SYSIBM.SYSROUTINES - but where is the source
> text stored.


You should not use the internal, undocumented tables but rather the catalog
view SYSCAT.ROUTINES. The reason being that the internal tables might
change at any time - the external interface is much more stable.

> I want to reverse engineer the definitions.
>
>
> Thanks
>
> Bill


--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Reply With Quote