I am new to the DB2/400 world and am tasked to speed up some of the reports and a GUI application.
To accomplish this I am heading in the direction of using stored procedures and UDFs. My problems is that the shop that I am working in is basically a AS400 shop that has never used SP or UDFs so there is very little/None help in questions that I have reguarding the use of SP's. My question is that if I grant execute rights to public and when the application/database is deployed do these rights travel with the object that is in a seperate library that will be sent to the client site. If the rights are not transferred is there an easy way to run a create script to acutally grant the rights to the group public? I am running up against a little resistance by the AS400 developers due to they have never seen or attempted to use a stored proc to perform any type of Database operation.
I also get the impression in talking with them (the developers) they believe that a table in the database is nothing more than a flat file that they access. Does DB2/400 actually work in this manner(flat file) or is it an actual relational database?
Jim Schneider(Legal Dev)