View Single Post

   
  #3 (permalink)  
Old 04-20-2008, 10:37 AM
Jonathan Leffler
 
Posts: n/a
Default Re: dummy update

tomcaml@yahoo.com wrote:
> i am migrating to v10
> but the guide for 9.4 says this under "remove outstanding in-place
> alters"
>
> the db server cannot convert if there are any outstanding
> in-place alters
> remove outstanding in-place alters before converting by
> running a 'dummy' update statement against each table
>
> pointed that direction by infx support - does not seem quite right but
> that is what it says
>
> and the thread is correct, it will not work to do so against SERIAL
> type so thanks much for the replies!


Look for the Perl script to diagnose tables with outstanding IPAs in the
IIUG archives.

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