0

I would like to see the code for a function defined like below. This function -lives in a schema called MYSCHEMA -makes usage of a shared library installed.

I tried to use the following but it doesn't work.

  select r.routinename as FunctionName, r.text as FunctionBody from 
  syscat.routines r where r.origin in ('U','R') and ROUTINESCHEMA='TRADE' 
  AND ROUTINETYPE ='F'

How can I do that?

   create or replace function MyFunction(varchar(60))
          returns  table(
          ..fields..
           )
          external name 'mySharedLib.so!function'
          language c
          parameter style sql
Abruzzo Forte e Gentile
  • 14,423
  • 28
  • 99
  • 173

2 Answers2

1

There's no "code", just the function definition. You can either use db2look or generate the definition yourself by querying the system catalog views SYSCAT.ROUTINES and SYSCAT.ROUTINEPARMS.

mustaccio
  • 18,234
  • 16
  • 48
  • 57
1

DB2 will not store the code of the external routines (C or Java). DB2 will just call the external binary when the function or SP is called. If the DB cannot locate the binary, it will throw an error

However, the mapping between a routine definition and the called binary is in the catalog, where DB2 will store the header and which binary has to call.

When you add a routine, DB2 does not even check it that routine has the good format, or callable parameters. That will be done at execution time.

AngocA
  • 7,655
  • 6
  • 39
  • 55
  • Hi AngocA, do you know if the size/limit, in the example 60, is enforced before calling the routine? Or is the routine that has to validate the size? – DavidC Mar 27 '15 at 14:23
  • I do not know. You can test if, but if you want, you can create an independent question just for that, because it is interesting. – AngocA Mar 27 '15 at 14:26