RPGLE program with five modules updating different set of files.
Main module calls others each time a customer is being processed to change some specific detail in many files.
There are many customers, so the modules are called many times (LR is set on only at the end of the whole process).
Each module has many SQL updates in the form:
- UPDATE xxx SET cc=bb WHERE mm=nn.
There are no SELECT, CURSOR, OPEN, etc.
My questions are:
SQL creates access paths for every file and keeps them, so they will be reused in the next cycle?
Or the access path is open and close each time?
Or there are no access paths and SQL reads the whole file?
NOTE: Those files updated by SQL do not have access paths according to the WHERE statement.
Thanks for any answer. My main worry is performance as there are many customers with many many records and files to be updated.