Focal Point
Execute a program on an iSeries (DB2)
March 25, 2008, 05:26 PM
Craig BExecute a program on an iSeries (DB2)
I need to be able to run a program (RPG or CL) on an iSeries (AS/400)(System i) from either an HTML launch page or from within a WF procedure. Can someone point me in the right direction?
WebFOCUS 7.6.2
DB2, V5R4
Output: PDF
March 25, 2008, 05:47 PM
FrankDutchCraig
have you tried to search on the word "DRILLDOWN" here on the FP site?
You will find many items to solve this.
(find is the third button from left....)
|
Frank |
| prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
March 25, 2008, 05:59 PM
GinnyJakesTry searching on 'stored procedure' or 3GL call or something like that. If I understand what you are asking, it seems more like an iWay situation than WebFOCUS. Unless of course the program is an data base procedure. If it is the latter, the stored procedure info would help you.
Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
March 26, 2008, 10:12 AM
Craig BFrank,
Thanks for the hint and I did try the "Find" button first. I didn't think to search under drilldown for executing a program on another machine and having the information returned to WF. At this point I haven't seen anything under drilldown that would help.
WebFOCUS 7.6.2
DB2, V5R4
Output: PDF
March 26, 2008, 05:16 PM
Diptesh PatelCraig:
I'm assuming your WF procedure is not on the AS/400 machine. Look into setting up a hub-sub reporting server environment.
Diptesh
WF 7.1.7 - AIX, MVS
May 07, 2008, 05:44 PM
Jim ZuckerCraig,
Where is your WebFOCUS Reporting Server?
If the reporting server is on the iSeries machine, you can invoke the program in a number of ways.
WebFOCUS also allows you to make remote procedure calls on the iSeries machine, allowing the creation of your own "user-written subroutines".
In order to figure out the best solution, you would need to know:
1. Where the WebFOCUS Reporting Server resides.
2. What Data Adapters you have available.
3. What the nature of the 3-GL programs are.
WebFOCUS 53, 71, 76 - All Platforms
June 04, 2008, 04:36 PM
NoelJim,
If my reporting server is on the Iseries and uses CLI as the DB2 data adapter can I execute a webfocus procedure from a CL or an RPGILE program and the other way around?
Thanks,
Noel
June 04, 2008, 05:03 PM
Craig BUsing the code below I was able to call the program on the iSeries. Hope this helps.
! CALL PGM(LibraryName/ProgramName)
WebFOCUS 7.6.2
DB2, V5R4
Output: PDF
August 28, 2008, 10:52 AM
HuaCraig,
I must missing something, I couldn't get the program work. No error/warning message, just didn't do anything.
Hua
Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS