Re: Stored Procedures - Who is in Charge?

Kate Tomchik/IS/SSC/THD@emory.mathcs.emory.edu wrote: :We are just starting to use stored procedures in our production environment, :and I just was wondering :how these are handled in other companies. :Does the DBA or the Programmers write the SP? The programmers with the DBA's full knowledge and support. :Does the DBA or the Programmers debug/test/approve of their use? The programmers with the approval of the DBA. :Who implements the SP when in development environments? Lead programmers. :" in production :environments? May be the DBA or whoever is responsible for the final production installation of the programs that rely on them. :What permissions do developers need to create new stored procedures? DBA if they are going to be run with DBA priviledge. Otherwise resource. :Any other insights would be greatly appreciated. :We are currently using 5.03 on HP 9.04, about to upgrade to 5.05 and HP10.10 in :production :environments, and 7.13.UC2 and HP10.10 in development environments, so any :quirks :with these combos would also be greatly appreciated information. The main issue is with the dbinfo function that isn't available in version 5.x. You will easily need this function, and it will limit your ability to write some types of stored procedure on the 5.x version. :P.S. I'm told that the REPLY may not be working from my messages, so you may :have to :manually type in the ktomchik@homedepot.com. Let me know. Yes, I whould have had to. However if you don't have the time to read the newsgroup, why should I bother. I expect people to not only ask, but eventually also contribute. If nothing else you might want to report on your progress with stored procedures. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org