Calling/Executing an AS/400 job from an application not on the AS/400

[Guest]

[frown] I'm sending data via ODBC from a SQL 2000 database to the AS/400. Once the data is sent, I want to automatically execute a job on the AS/400 that will determine the batch number via JDE's next numbering and load data to JDE's Z-file for journal entry processing. I cannot find a way to automatically execute the AS/400 job from ODBC, Client Access etc... The data will be derived from a C# (Microsoft .NET application) and stored in a SQL server database. Any ideas?

 

[Hahn_Associates]

I believe you can use FTP to execute a remote command on the AS/400. However, I think it would be easier to write a trigger program that would run when records are added to upload files.
dbiggs <[email protected]> wrote:[frown] I'm sending data via ODBC from a SQL 2000 database to the AS/400. Once the data is sent, I want to automatically execute a job on the AS/400 that will determine the batch number via JDE's next numbering and load data to JDE's Z-file for journal entry processing. I cannot find a way to automatically execute the AS/400 job from ODBC, Client Access etc... The data will be derived from a C# (Microsoft .NET application) and stored in a SQL server database. Any ideas?
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=W&Number=44692
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList World™ mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+


---------------------------------
Do you Yahoo!?
HotJobs - Search new jobs daily now

 

[vasuvv2300]

You can use FTP or else you can use the triggers. You can use Data queue effectively on the AS/400 when you want to initiate a job on AS/400

 

[cparlanti]

If you are already using ODBC and Client Access the simpliest way is to use the CALL function of Client Access.
Just execute the following SQL command string:
CALL QSYS.QCMDEXC ('SBMJOB CMD(CALL PGM(J04110Z) PARM(P04110Z XGRZ0001)) JOB(ODBCFACE) JOBQ(QSINGLE)', 000000080.00000)
and, for instance, you will process an A/P batch.