× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.