I have a procedure as P1 & this procedure is calling some internal procedures. We have a java application to call this P1 on db2 server. My requirement is java application is calling P1 as a procedure till now. Is there any way to create a JOB in db2 server , so that I can place that procedure call in a JOB & that java application can directly call that JOB alone.
I want to create a JOB in db2 without using the Wizard or scheduler. some what like a CREATE JOB ,if exists in db2.
I am totally new to these db2. I am learning now. I can't use schedulers as the procedure calls will be depend upon Java application. Hence I am looking for a job(command level) creation in db2. If there is no such functionality in db2 then I look for some alternative, just want to know whether this is possible or not without wizards & schedulers.
2. Check corresponding jar, its appearing in sysibm.sysjarobjects
select * from sysibm.sysjarobjects
3. create a db level external procedure
CREATE PROCEDURE MYPROC.TEST_PROC(INOUT V varchar(2))
DYNAMIC RESULT SETS 0
PARAMETER STYLE JAVA
MODIFIES SQL DATA
PROGRAM TYPE SUB
EXTERNAL NAME 'your_java_file!your_java_method'
You may need help of java developer for the above configuration.