Hi,

I am starting in DB2 and i want to make a select in a global temporary table, in a procedure it works normally, but in a function it isn't, a had tried a lot's of things but all of then got an error like this:

SQL0526N The requested function does not apply to declared temporary tables.

Someone knows the reasons of this error?

Thanks.

A global temporary table is not supported in a function.

Ok, thanks...

But you know a different way to do the same thing that the global temporary table do ? For example i need to keep a several records in the user session, but i can't find.

Thanks a lot.

I solve my problem making a procedure that reads a global temporary table and a function that executes this procedure and gets his result.