Re: Can we change the column width of a column in a live database?

We've discovered that you must recompile 4gl programs that use an altered table (at least on the standard engine). Otherwise inserts and updates can put scrambled data into a row... jblatz@worldnet.att.net wrote: > In article <360A3B74.E19E7249@vbws01.ba.ford.com>, > Saleem Mohammad <smohamm1@vbws01.ba.ford.com> wrote: > > Hi Everyone > > > > Can we change the ( I have to increase the width of character > > filed in a table of a live database) width of a column in a > > live database??? Please let me know. > > > > Thank You > > Saleem > > > > I don't know what version you are running, but it probably is the same for > them all. In order to change the column width you must do an 'alter table'. > This will lock that table in exclusive mode which means it cannot be accessed > until the alter is complete. It will not effect the rest of the database > except perhaps in terms of performance. > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum