DB2 LUW 8.2 - Sql Function with declared temp table?

Scott Hodgin

DB2 LUW 8.2 - Sql Function with declared temp table?
Hi list,



Does anyone have a working UDB SQL function that declares a global temporary
table? Is it possible to declare a global temp table in a udb SQL function?



I have tried numerous things, but I keep getting syntax errors.



Any help is appreciated.







Scott Hodgin, Database Administrator

South Carolina Farm Bureau Insurance Company

[login to unmask email] <mailto:[login to unmask email]>




---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm