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     [CLOSED] Can I execute a procedure on i5/as400 from caster

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Can I execute a procedure on i5/as400 from caster
 Login/Join
 
Marikaki
Gold member
posted
Hi,

This week I had a problem with my scheduled standard report in caster that run with no refreshed data because the extraction procedure on the i5/as400 has not been completed successfully.

I saw in caster that we could have pre and post fex to a scheduled report. But my procedure is a pure as400 object that runs many sql statments but also other as400 commands.

What is your best recommandation? Is any of you client has to do so?

Thanks for your help. Smiler

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


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
Tony A
Expert
posted Hide Post
Have a look in the Developer Centre at an article called "How to Automatically Delay ReportCaster Jobs".

You can get to the Developer Centre via the first bread crumb link at the top of the page and then head for the Tips and Techniques link on the left hand side of the resultant web page.

My personal preference on this sort of thing is to check for the file existence via a precedent fex and to reschedule the caster job for ten minutes time before using KILL_RPC. Don't forget to set it back to the next run time in a postscript fex as necessary.

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Marikaki
Gold member
posted Hide Post
Thanks Tony,

I will have a look part time. Excellent if there is a solution and if it is faisable. Did you do it once?

Should I close it?
Again thank you.


Marikaki

WF 7.7.03m, MRE, BI Dashboard, DevStudio, Report Caster, Windows 7, I.E. 8/9, Apache Tomcat 6.0, Derby Output formats: Excel2K, PDF, HTML, AHTML

 
Posts: 96 | Location: Montreal, Quebec, Canada | Registered: January 20, 2010Report This Post
Tony A
Expert
posted Hide Post
You are welcome. It a good source for many techniques etc. and, yes I have used a similar technique before to circumvent the inability to schedule reports on disparate dates that do not conform to "normal" frequencies such as "first day of month" etc. If your accounting periods are sporadic this method can get you out of a hole! Smiler

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report 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     [CLOSED] Can I execute a procedure on i5/as400 from caster

Copyright © 1996-2020 Information Builders