Results 1 to 4 of 4

Thread: DB2 procedures

  1. #1
    Join Date
    May 2012

    Question Unanswered: DB2 procedures

    Hi !

    I have a stored procedure where i need to do error handling.

    I am doing a DML operation in stored procedure.

    If for eg if the DML operation is getting failed i need to update the status in logging table.

    Can u pls help

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    You will need to declare a condition handler. More details in the manual: Compound SQL (compiled)

  3. #3
    Join Date
    May 2012
    Can you tell me in short of the syntax.

    Am just doing some Insert operation in stored procedure.. The insert operation can get failed due to constraints issue or connectivity problem or for any other reason ..

    If the insert operation got failed i need to have some error handling where i will update user defined logging table that the procedure is failed.

    Pls help me experts..

  4. #4
    Join Date
    Apr 2012
    Provided Answers: 27
    It is much wiser to help yourself ....

    If your DB2-server is on Windows look at the many helpful examples in directory
    "\program files\ibm\sqllib\samples\sqlpl"

    If your DB2-Server is on Linux/Unix look for the same samples in

Posting Permissions

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