Ask the Experts - 72
My User has a question:
What is the best solution fot it? Especially when the output data is very huge..
I have a few ideas:
1. On First Button PeopleCode: CallAppEngine()
2. On First Button PeopleCode:
3. On a Button: ScrollSelect()
Thanks for posting your question!
The reason for executing the process (AE/SQR) on process scheduler is to reduce the load on application server. This will help App. Server to take user load than the processing load.
Alternative solution to the problem can be (taking cue from your suggestion)
a) On the run-control-page provide a “SUBMIT” button.
b) When the user clicks the submit button you can use CallAppEngine() or execute a AE or SQR on process scheduler.
c) You can also provide a link which will
a. Take you to Process Monitor directly or
b. Provide a link to XLS report which got generated.(If the user clicks the link and report is still not generated then you can prompt the user that report is still getting generated).
c. The link value can be taken from PS_CDM_LIST