Sheduling a DB2 stored procedure from controlM

skumar80 · #1 (**permalink**) 03-18-04, 11:35

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.

Damian Ibbotson · #2 (**permalink**) 03-18-04, 12:20

Quote:

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

Internet Services

Web Development

Digital Marketing

Consumer Tech