table return functions and procedures

sunsanvin · #1 (**permalink**) 03-30-07, 04:07

Dear Folks, Please provide me steps to write functions and procedures which returns table.

what exactly i need is a fuctions and procedures , the output should be a table...........

thank you verymuch

guyprzytula · #2 (**permalink**) 03-30-07, 06:07

all doc is in this book
Application Development Guide: Programming Server Applications
see pdf books
http://www-1.ibm.com/support/docview...id=swg21256030

stolze · #3 (**permalink**) 03-31-07, 12:27

Adding to Guy's comment, have a look at the samples that come with DB2. There are examples that show how to implement table functions and also for stored procedures that return result sets, I believe.

rahul_s80 · #4 (**permalink**) 04-02-07, 00:40

i think most of ur queries can be easily found in
DB2 UDB V8.2 SQL Cookbook
search on google , its free

Internet Services

Web Development

Digital Marketing

Consumer Tech