Sleep command in db2

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Arun Srinivasan

    Sleep command in db2

    Just want to know if there is a sleep command I could use to slow down
    the process in a stored procedure. I know people would've asked this
    question. I googled it, but everyone said that they haven't used in
    the stored procedures. I want to know if the sleep cannot be done
    directly in an SP, is there any workaround for this.

    Thanks
    Arun
  • Serge Rielau

    #2
    Re: Sleep command in db2

    Arun Srinivasan wrote:
    Just want to know if there is a sleep command I could use to slow down
    the process in a stored procedure. I know people would've asked this
    question. I googled it, but everyone said that they haven't used in
    the stored procedures. I want to know if the sleep cannot be done
    directly in an SP, is there any workaround for this.
    You can create an external procedure (Jave, .NET, C) and use whatever
    sleep command is used there....

    Cheers
    Serge


    --
    Serge Rielau
    DB2 Solutions Development
    IBM Toronto Lab

    Comment

    Working...