Re: Creating SQL view for RPG at runtime.

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

Well, you are performing application specific selection in a view. Don't 
do that. If the select criteria changes based on the application, place 
that selection criteria in the application. If the selection criteria is 
_always_ fixed, then that's more likely a candidate for the view.

David Foxwell wrote:
> Hi all,
>
> Using SQL with RPG is totally new in our company.
>
> I have created a view which uses CURRENT DATE amongst other criteria that I read as a primary file in my RPG. 
> This program will be planned to run at the end of the last working day of each month.
>
> What if the program has to be run on the first day in case of a problem? It 
> would use the data from the wrong month.
>
> I have a CLP which inititializes my output files: I think I should I be 
> creating my view at the same time, using my planned date instead of CURRENT 
> DATE.
>
> Where or how would one do this? 
>
> My output files can be created simply but for the input (view) I would need a source file for RUNSQLSTM or a separate SQLRPGLE program. 
>
> Is there a correct way to go about this.
>
>