When anyone asks for information that they are going to “pull” from the IBM i into another database or to interface to another application on the IBM i I do not want them to access the “live” files for several reasons:
Control the information they can get to, don’t show them what they do not needIf there are calculations or other mapping that needs to be performed perform them, rather than rely on them to do it and then find they have not done so in the right mannerMap data from the files and tables into the type of data format they wantPrevent them from being able to insert, change, or delete data from files and tables
In my opinion the perfect tool for this is a SQL View. I can build it the way I want and tell them to use that.
