You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

accepting the values from runcontrol table through sqr program while running in process scheduler

2 replies [Last post]
Guest's picture
Guest

Hi,

My requirement is to accept values from runcontrol table through sqr program while running the program in process sheduler.Give me 1 simple eg. program .

Thanks in advance,
Deepa.

Ashar's picture
User offline. Last seen 4 years 34 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: accepting the values from runcontrol table through sqr ...

Here is an example..

Begin-Procedure Select-Inputs

Begin-Select
A.FROMDATE
A.THRUDATE
From PS_RUN_CNTL_HR A
Where A.OPRID = $prcs_oprid
And A.RUN_CNTL_ID = $prcs_run_cntl_id
End-Select
End-Procedure

Lepa's picture
User offline. Last seen 2 years 5 days ago. Offline
Joined: 06/23/2008
Posts: 591
Re: accepting the values from runcontrol table through sqr ...

Do you know of a delivered SQR that takes values from the run page? If so, then just open the program and dig around. It should be easy to figure out.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog