Upgrade from 10.0 to 11.50 64bit

Posted in 2009

Topics: Installation, Setup & Upgrades, Stored Procedures & SPL

Schuran, Sven — Mon, 05 Oct 2009 15:28:02 — source: IIUG Forums & Mailing Lists

Hi, I tried to upgrade from 10.0 to 11.50. But I had to rollback cause of Informix error 26060. It says I have to recreate procedures. Is there a easy way to drop all procedure, even when there are overloaded procedures. Thanks Sven -------------------------------------------------------------------- Sie finden uns im Internet unter: www.maske.de Maske Fleet GmbH Behringstraße 120 22763 Hamburg Noch mehr Service und Dienstleistungen für unsere Kunden : Maske jetzt auch in Nürnberg - Passauerstr. 90, 90480 Nürnberg - Tel.: 0911 / 50 49 730 Handelsregister Hamburg HRB 105256 USt-Ident.-Nr. DE 116 923 883 Geschäftsführer: Andreas Maske Diese e-mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese e-mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene e-mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation.

↪ replying to Schuran, Sven

Art Kagel — Mon, 05 Oct 2009 15:54:19 — source: IIUG Forums & Mailing Lists

output to pipe 'dbaccess mydatabase -' select 'drop procedure' || procname || ';' from sysprocedures; For overloaded procedures you may have to include the argument lists. Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Oct 5, 2009 at 11:28 AM, Schuran, Sven <sschuran@maske.de> wrote: > Hi, > > I tried to upgrade from 10.0 to 11.50. But I had to rollback cause of > Informix > error 26060. It says I have to recreate procedures. > > Is there a easy way to drop all procedure, even when there are overloaded > procedures. > > Thanks Sven > > -------------------------------------------------------------------- > Sie finden uns im Internet unter: www.maske.de > > Maske Fleet GmbH > Behringstraße 120 > 22763 Hamburg > > Noch mehr Service und Dienstleistungen für unsere Kunden : > Maske jetzt auch in Nürnberg - Passauerstr. 90, 90480 Nürnberg - Tel.: 0911 > / > 50 49 730 > > Handelsregister Hamburg HRB 105256 > USt-Ident.-Nr. DE 116 923 883 > Geschäftsführer: Andreas Maske > > Diese e-mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige > vertrauliche Informationen enthalten. Sollten Sie diese e-mail irrtümlich > erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine > Vervielfältigung oder Weitergabe ausdrücklich untersagt. Bitte > benachrichtigen > Sie uns und vernichten Sie die empfangene e-mail. Vielen Dank. > > This e-mail may contain trade secrets or privileged, undisclosed or > otherwise > confidential information. If you have received this e-mail in error, you > are > hereby notified that any review, copying or distribution of it is strictly > prohibited. Please inform us immediately and destroy the original > transmittal. > Thank you for your cooperation. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517503d744556f60475322077

↪ replying to Art Kagel

Schuran, Sven — Mon, 05 Oct 2009 20:06:54 — source: IIUG Forums & Mailing Lists

Thanks. Very good. But there are a lot procedures informix related and not user define. How do i only get user defined procedure. Thanks Sven -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Art Kagel Sent: Monday, October 05, 2009 5:54 PM To: ids@iiug.org Subject: Re: Upgrade from 10.0 to 11.50 64bit [17334] output to pipe 'dbaccess mydatabase -' select 'drop procedure' || procname || ';' from sysprocedures; For overloaded procedures you may have to include the argument lists. Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Oct 5, 2009 at 11:28 AM, Schuran, Sven <sschuran@maske.de> wrote: > Hi, > > I tried to upgrade from 10.0 to 11.50. But I had to rollback cause of > Informix > error 26060. It says I have to recreate procedures. > > Is there a easy way to drop all procedure, even when there are overloaded > procedures. > > Thanks Sven > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517503d744556f60475322077 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. -------------------------------------------------------------------- Sie finden uns im Internet unter: www.maske.de Maske Fleet GmbH Behringstraße 120 22763 Hamburg Noch mehr Service und Dienstleistungen für unsere Kunden : Maske jetzt auch in Nürnberg - Passauerstr. 90, 90480 Nürnberg - Tel.: 0911 / 50 49 730 Handelsregister Hamburg HRB 105256 USt-Ident.-Nr. DE 116 923 883 Geschäftsführer: Andreas Maske Diese e-mail kann Betriebs- oder Geschäftsgeheimnisse oder sonstige vertrauliche Informationen enthalten. Sollten Sie diese e-mail irrtümlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, eine Vervielfältigung oder Weitergabe ausdrücklich untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die empfangene e-mail. Vielen Dank. This e-mail may contain trade secrets or privileged, undisclosed or otherwise confidential information. If you have received this e-mail in error, you are hereby notified that any review, copying or distribution of it is strictly prohibited. Please inform us immediately and destroy the original transmittal. Thank you for your cooperation.