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 |