Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Execute a program on an iSeries (DB2)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Execute a program on an iSeries (DB2)
 Login/Join
 
Craig B
Member
posted
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
 
Posts: 16 | Location: Des Moines, IA | Registered: December 04, 2007Report This Post
FrankDutch
Virtuoso
posted Hide Post
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....)




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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
GinnyJakes
Expert
posted Hide Post
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.


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
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Craig B
Member
posted Hide Post
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.


WebFOCUS 7.6.2
DB2, V5R4
Output: PDF
 
Posts: 16 | Location: Des Moines, IA | Registered: December 04, 2007Report This Post
Diptesh Patel
Gold member
posted Hide Post
Craig:
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
 
Posts: 79 | Location: Warren, NJ, USA | Registered: October 25, 2006Report This Post
Jim Zucker
Member
posted Hide Post
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.


WebFOCUS 53, 71, 76 - All Platforms
 
Posts: 15 | Location: Information Builders - Chicago | Registered: May 08, 2003Report This Post
Noel
Silver Member
posted Hide Post
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
 
Posts: 34 | Location: Winnipeg, MB | Registered: January 23, 2008Report This Post
Craig B
Member
posted Hide Post
Using 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
 
Posts: 16 | Location: Des Moines, IA | Registered: December 04, 2007Report This Post
Hua
Guru
posted Hide Post
Craig,

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
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Execute a program on an iSeries (DB2)

Copyright © 1996-2020 Information Builders