Re: Stored Procedures - Who is in Charge?

What do you mean about reading and contributing to the newsgroup? I read it every day and I'm the one who recently enlightened everyone on the quirks of HPs with version 7.1X informix as well as many other issues. I'm rather offended. Just because I warn people that they CAN'T send to me with the reply option doesn't mean I EXPECT them to do it, but it's up to them if they don't want their opinions made public. They may have other members of their company that also read the news group that would disagree with them or not approve of them giving out company related information. Be calm, okay. (By the way, notice I made this public, despite the fact that it will mostly just clutter everyone's mailbox with a somewhat personal discussion between the two of us). Nils.Myklebust @ idg.no (Nils Myklebust) 10/16/96 01:46 PM To: informix-list @ rmy.emory.edu @ INTERNET cc: (bcc: Kate Tomchik/IS/SSC/THD) Subject: 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