Our customer database does not store year-to-date sales in a physical file. However, this is something that we use quite frequently. So I'm considering two solutions.
1. Add a procedure to an existing SQLRPGLE service program to sum the figure based on customer number passed in, OR
2. Create an SQL view that sums for all customers
Running the interactive SQL statement seems nearly instantaneous... I think I would have more flexibility with the service program. I could have gross sales & net sales (less returns) in the same service pgm.
Just looking for opinions on the different approaches.
Greg
1. Add a procedure to an existing SQLRPGLE service program to sum the figure based on customer number passed in, OR
2. Create an SQL view that sums for all customers
Running the interactive SQL statement seems nearly instantaneous... I think I would have more flexibility with the service program. I could have gross sales & net sales (less returns) in the same service pgm.
Just looking for opinions on the different approaches.
Greg
Comment