Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    13

    Unanswered: table return functions and procedures

    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

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    all doc is in this book
    Application Development Guide: Programming Server Applications
    see pdf books
    http://www-1.ibm.com/support/docview...id=swg21256030
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    i think most of ur queries can be easily found in
    DB2 UDB V8.2 SQL Cookbook
    search on google , its free
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •