I have spent hours trying to find what could cause this statement to work for one table and not another within the same database. Neither have constraints on the column. The column size is/was char(8) for both.
ALTER TABLE table1
MODIFY update_who CHAR(12);
For one table it worked and for the other I get 201: A syntax error has occurred.
I am guessing that there is something with the table it does not work on but I don't know what to look for and I can't find anything that explains this.
type your statement
get the error
choose the 'Use editor' option in the menu
this will display your query in vi and will point with a ^^ sign under
the place where the parser does not accept the syntax.
this should help you understanding where exactly your problem is