Dummy update for In place alters

Posted in 2006

Peter_Logan@spartanstores.com — Wed, 08 Feb 2006 21:24:18 — source: IIUG Forums & Mailing Lists

On the iiug web site I found a script that will find the in place alters ... and generate the update sql to fix them. The problem is that the script has wrapped at 80 columns .. so it won't work ... instead of working through the 500 lines or so of code ... does anyone have this script .. or a similar one that will find these. I will be upgrading a v9.40 engine on Aix 5.3 to v10 ... thanks for any help.

↪ replying to Peter_Logan@spartanstores.com

Rajib Sarkar — Wed, 08 Feb 2006 21:38:22 — source: IIUG Forums & Mailing Lists

Hi Peter, I'm attaching the script ...hopefully it'll work. (See attached file: inplacealter.ksh.txt) Thanx much, Rajib Sarkar DB2 UDB RPD Team IBM Data Management Group http://www.ibm.com/software/data/db2/udb/support/ From his neck down a man is worth a couple of dollars a day, from his n= eck up he is worth anything that his brain can produce. -- T. Edison = "Peter_Logan...." = <Peter_Logan@spar = tanstores.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Dummy update for In place alters= 02/08/2006 02:24 [6330] = PM = = = Please respond to = ids@iiug.org = = = On the iiug web site I found a script that will find the in place alter= s .... and generate the update sql to fix them. The problem is that the script has wrapped at 80 columns .. so it won't work ... instead of working through the 500 lines or so of code ... does anyone have this script .. or a similar one that will find these. I will be upgrading a v9.40 engine on Aix 5.3 to v10 ... thanks for any help. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to Rajib Sarkar

Peter_Logan@spartanstores.com — Wed, 08 Feb 2006 21:44:18 — source: IIUG Forums & Mailing Lists

It did not work ... If you want to send it directly... peter_logan@spartanstores.com Thanks ... "Rajib Sarkar" <rsarkar@us.ibm.com> Sent by: ids-bounces@iiug.org 02/08/2006 04:38 PM Please respond to ids@iiug.org To ids@iiug.org cc Subject Re: Dummy update for In place alters [6332] Hi Peter, I'm attaching the script ...hopefully it'll work. (See attached file: inplacealter.ksh.txt) Thanx much, Rajib Sarkar DB2 UDB RPD Team IBM Data Management Group http://www.ibm.com/software/data/db2/udb/support/ >From his neck down a man is worth a couple of dollars a day, from his n= eck up he is worth anything that his brain can produce. -- T. Edison = "Peter_Logan...." = <Peter_Logan@spar = tanstores.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Dummy update for In place alters= 02/08/2006 02:24 [6330] = PM = = = Please respond to = ids@iiug.org = = = On the iiug web site I found a script that will find the in place alter= s ..... and generate the update sql to fix them. The problem is that the script has wrapped at 80 columns .. so it won't work ... instead of working through the 500 lines or so of code ... does anyone have this script .. or a similar one that will find these. I will be upgrading a v9.40 engine on Aix 5.3 to v10 ... thanks for any help. ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. = ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.