Can't commit changes to table

I ran a SQL script to change a column in a table from CHAR(6) to CHAR(*). I run a "desc" after and no changes have taken place. I'm assuming a rollback occurred even though I appended "commit" to the end of the script. What would cause a commit to not occur in this type of situation ? Thanks John -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

I'm presuming that you meant to change the column from char(6) to char(8). I don't think that char(*) is valid. Depending on the size of the table, you might have run out of logical logs. ALTER TABLE is great to modify the schema of a live table, if you have enough logspace to handle the large transaction involved. John Carlson Informix DBA WHSmith USA jvnet@excite.com wrote: > > I ran a SQL script to change a column in a table from CHAR(6) to CHAR(*). I > run a "desc" after and no changes have taken place. I'm assuming a rollback > occurred even though I appended "commit" to the end of the script. What would > cause a commit to not occur in this type of situation ? > > Thanks > John > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own