Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Posts
    36

    Unanswered: Writing Stored Procedures in db2

    Hi all,

    Can anyone please guide/help me on writing a store procedure. This is the first time I am writing a store procedure in db2.

    They have provided me with a CSV file that has all the values and I have to use this values for using in each iterations listed below.

    The application team has provided me with a logic that iterates through each loop and the result set of the first loop should be used in the second loop and so on 5 loops.

    And for each Iteration I have to remove the duplicate values or do not add the duplicate values while iteration for each resul set.

    They are asking me to use the vectors.

    Any help is highly appreciated.

    Thanks a lot......

    DB2 Version: 8.1.1

    OSLEVEL : AIX 5.3

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Did you have a look at the DB2 manuals already? It contains a lot of examples on stored procedures and how to write them.

    p.s: 8.1.1 is out of service.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Mar 2009
    Posts
    36
    Thanks Stolze for ur reply..

    No, I did not check the DB2 Manuals. can you please guide me for the manuals where I can find them?

    Thanks Again..

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Mar 2009
    Posts
    36
    Thanks Satya..

Posting Permissions

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