Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2002

    Post Unanswered: Need Help(DB2 Stored Procedure)

    Hi Guys!

    New To DB2(First Day). Need help developing a SP to insert /update/delete a table record.
    The procedure does the following.
    1. Takes 2 parameters.
    2. Should check for the user authentication to drop an existing procedure
    3. Should check for the existence of the Object(Porcedure). If
    <available> drop else <msg>
    4. Insert the row into the coresponding table.
    5. Should Capture Errors if any ?

    I need syntax for my question or procedure structure of how to implement all the features in one procedure.

    Please Help
    Last edited by bollin99; 09-03-02 at 13:30.

Posting Permissions

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