Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Sheduling a DB2 stored procedure from controlM

    Hi Folks,

    I have a stored procedure in DB2 UDB on AIX.
    I need to schedule the same in Control-M.

    Could anyone tell me is it possible to shedule a stored procedure in Control-M? If yes, how do I do it?

    It would be great if someone could provide me the commands for the shell script that executes a stored procedure.

    Thanks,
    kumar.

  2. #2
    Join Date
    Jun 2002
    Location
    UK
    Posts
    525

    Re: Sheduling a DB2 stored procedure from controlM

    Originally posted by skumar80
    Hi Folks,

    I have a stored procedure in DB2 UDB on AIX.
    I need to schedule the same in Control-M.

    Could anyone tell me is it possible to shedule a stored procedure in Control-M? If yes, how do I do it?

    It would be great if someone could provide me the commands for the shell script that executes a stored procedure.

    Thanks,
    kumar.
    I have no idea about Control-M but you would call a db2 SP from the command line (or in a shell script) as follows...

    Code:
    db2 "call yourSpName(inParamValue1, inParamValue2 ...)"
    You would need to reference any OUT parameters with '?'s.

    Damian

Posting Permissions

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