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?

Craig

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....)

Try 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.

Frank,

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.

Craig:
I'm assuming your WF procedure is not on the AS/400 machine. Look into setting up a hub-sub reporting server environment.

Craig,

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.

Jim,

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

Using the code below I was able to call the program on the iSeries. Hope this helps.

! CALL PGM(LibraryName/ProgramName)

Craig,

I must missing something, I couldn't get the program work. No error/warning message, just didn't do anything.

Hua