Stored Procedures vs views for connecting to Iseries DB2 databse using .NET
Posted on 2009-12-28
I have a requirement to access the Iseries DB2 database using .NET.
I need to acce a number of AS 400 files on DB2.
For that we can think of the option of creating store procedures using Iseries ACcess, since stored procedures are mostly used for connecting to the datbases from .NET.
However we got a suggestion from a more experienced person on AS 400 that views will probably be a better solution.
We were told that it will be very easy for an AS 400 person to create one single views on all the tables that are required in a query and then oiut query will only access that view.
Can some one please suggest the pros and cons of using views over Sored procedures or vice versa?