Re: Books/comments on Stored Procedures

> > Informix Version 5 now supports Stored Procedures. > > Can anyone suggest and reading material which will give me more > of an idea on how to use stored procedures (from a systems design > point of view). > > What are people's experiences in using stored procedures rather > than doing it all in their programs? > > ====================================================================== > Roger Milligan roger@uiscpt.aztec.co.za > Unix Information Systems (Pty) Ltd (UIS) Tel +27 21 4194107 > Cape Town, South Africa Fax +27 21 252828 > Roger, The idea behind stored procedures is similar to object orientated techniques like encapsulation. They allow you to create an API to the database where no external program ever uses SQL but only the stored procedures to access and update data. This allows the possiblility of changing the underlying database and stored procedures but maintaining the same interface which means that your applications do not need to be changed or recompiled. Other advantages are that the engine does not need to optimise the statements as they are held in an optimised state, also client server systems are easier to build because only the calls to the procedures + the data must be transmitted back and forth instead of complete SQL statements or building your own set of procedures at the server end. I don't have any specific recomendations for books but look for books that cover client server databases and database independance. Cheers - Jim -------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 358-5911 (Work) Address: 1700 S. Amphlett Blvd. (415) 882-9728 (Home) San Mateo, CA 94402 Fax: (415) 571-6429 --------------------------------------------------------------------