Re: Java calling a AS400 Command to run DB2 stored procedures

A data queue is pretty easy to set up and monitor.

David Morris

>>> Gerard.Aitchison@xxxxxxxxxxxxxxxxx 9/22/2004 5:27:08 PM >>>
I have noticed on many bulleting boards that there are a number of 
solutions for calling Java Programs using the SBMJOB scheduler or other

internal command.

What I am looking to do is the  reverse, which I have not seen too much

info about.  I am looking at using a command on the AS400 to execute a

stored procedure to create tables on a DB2 database.  This Java will be
a 
swing app whereby I can select various parameters to pass onto the
stored 
procedure.

The reason why I am looking this way is that there are a number of
stored 
procs that may take >24 hours to run.  Now we can run the stored proc 
stright from java but if the box that the java app is down, which 
apparently does happen, then the connection is lost and so forth.  Now
if 
we can utilise a method whereby we place the power onto the AS400, then
it 
relieves the reliance of the java connectivity to the AS400.  All that
we 
need to do is check for when the job has completed on the AS400.  Maybe

there is a mechanism to fire the completion back.

Is there anyone who can assist with this problem?


Regards,
Ged Aitchison.
--
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l 
or email: JAVA400-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.