Stored Procedures and Migrating From IDS 7 to 9

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cindy Lichtenauer - 27 May 2004 16:46 GMT

Greetings

I am looking for information and/or tips on converting stored
procedures when migrating from IDS 7.22 to IDS 9.4. Is this a painful
process?

Any advice appreciated!

Thanks,
Cindy

Reply to this Message

Murray Wood (IList) - 27 May 2004 22:38 GMT

They should just run unchanged.

> -----Original Message-----
> From: owner-informix-list@iiug.org
[quoted text clipped - 13 lines]
> Thanks,
> Cindy

sending to informix-list

Reply to this Message

Jonathan Leffler - 28 May 2004 04:50 GMT

> I am looking for information and/or tips on converting stored
> procedures when migrating from IDS 7.22 to IDS 9.4. Is this a painful
> process?

Unless you have totally screwball procedures with hundreds (literally)
of parameters, you shouldn't notice any problems when upgrading. You
might want to modify the stored procedures to take advantage of named
return values - but the main migration should be painless.

Signature

Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

Reply to this Message