[an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] 24x7 Script Archive


Calling a program in AS400

Q: How to call those program in AS400?

A: The easiest way is wrapping the program as a DB2 stored procedure. To call that stored procedure, obtain and install ODBC driver for DB2, create new database profile in 24x7, after that create a "database" type job that calls the program using the following SQL statement: "EXECUTE <my_proc> <param1, param2,...>", where you should replace <my_proc> and <param1, param2,...>" with the program name and desired parameters.  There are several DB2 ODBC drivers available, you may want to try drivers from Intersolv http://www.intersolv.com or IBM http://www.ibm.com


** Alternative way is creating a "24x7 script" type job that uses Telnet statements  to connect to your AS400 host and run this program via Telnet.