Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Execute a JDE job on iSeries
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Execute a JDE job on iSeries
 Login/Join
 
Gold member
posted
I saw this post about using Maintain to execute a job on iSeries , I'm wondering if webfocus can achieve this as well?

Does anybody know if webfocus can issue a command to run JDE job on iSeries? Or use iSM to issue a command to run JDE job on iSeries? Both of our webfocus server and iSM are installed on window platform.

This message has been edited. Last edited by: Kerry,


Shirley Huang
WF 7.7.04M MRE BID DevStudio
WIN2003, SQL Server 2000/DB2
HTML/PDF/EXL2k/AHTML
iSM 6.16
 
Posts: 55 | Registered: May 05, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
I'm doing the following to run an iSeries command to see if a file has been updated since my program last ran. IWAY762 is my reporting server running on the iSeries. This code is in the middle of my fex.

 
REMOTE DEST = IWAY762
-REMOTE BEGIN
! DSPFD FILE(PRODLIB/PD200F) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(PRODLIB/PRODINFO) OUTMBR(*FIRST *REPLACE)
! DSPFD FILE(PRODLIB/PD205F) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(PRODLIB/PRODINFO) OUTMBR(*FIRST *ADD)
! DSPFD FILE(PRODLIB/PD210F) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(PRODLIB/PRODINFO) OUTMBR(*FIRST *ADD)
! DSPFD FILE(PRODLIB/PD215F) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(PRODLIB/PRODINFO) OUTMBR(*FIRST *ADD)
! DSPFD FILE(PRODLIB/PD216F) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(PRODLIB/PRODINFO) OUTMBR(*FIRST *ADD)
! DSPFD FILE(PRODLIB/PD220F) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(PRODLIB/PRODINFO) OUTMBR(*FIRST *ADD)
! DSPFD FILE(PRODLIB/PD300F) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(PRODLIB/PRODINFO) OUTMBR(*FIRST *ADD)
! DSPFD FILE(PRODLIB/PD305F) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(PRODLIB/PRODINFO) OUTMBR(*FIRST *ADD)
! DSPFD FILE(PRODLIB/PD310F) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(PRODLIB/PRODINFO) OUTMBR(*FIRST *ADD)
! DSPFD FILE(PRODLIB/PD320F) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(PRODLIB/PRODINFO) OUTMBR(*FIRST *ADD)
! DSPFD FILE(TPRDDTA/F4111) TYPE(*MBR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFILE(PRODLIB/PRODINFO) OUTMBR(*FIRST *ADD)
-REMOTE END
END
-RUN


------------------------------------------
DevStudio 8.2.03
WFS 8.2.03
 
Posts: 86 | Location: Atlanta | Registered: May 10, 2007Reply With QuoteReport This Post
Member
posted Hide Post
You can use the DB2 SQL interface to call iSeries programs and stored procedures:
ENGINE DB2 SET DEFAULT_CONNECTION iSeriesConnection
SQL DB2
CALL LIBRARY.PGM(&PARMS)
END


You can pass parms if you need. You can have the program do a SBMJOB if needed or call the program directly. You can also call iSeries stored procedures with this method (iSeries stored procedures can also be defined as synonyms in WF - we return result sets this way for many of our RPG business processes).


WF 7.7.02
iSeries/Windows
 
Posts: 8 | Registered: December 02, 2011Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Execute a JDE job on iSeries

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.