Hi,

I am new to DB2 and need your help. I tried to create a procedure which declares a global temporary table. Then I create a table function which calls the procedure then returns the result from the global temporary table.

There is no problem to deploy the procedure (PR_TEST_GTT), but get an error when deploying the function.

Here is the error message:

Deploy MYSCHEMA.FN_TES T

Running...