Alter Table, Alter Column

Melco

New Member
I am using Progress OpenEdge 10.2B on windows server 2003X64SP2.
I am trying to expand a column in the database and I keep getting an error.

I am new to progress and I have an background in Oracle.

Here is the statement:

ALTER TABLE PUB.cust
ALTER COLUMN cust-no CHARACTER (80)

Here is the error:
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "-no CHARACTER (80)"(10713)

I tried putting cust-no in quotes and received this error:
[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "CHARACTER (80)"(10713)

I don't know if this makes any difference but it is a Primary key.

I want to thank you for your help in advance.
 
Thank you, that was very helpful, I just need to figure out how to get an exclusive lock on that table.
I will try to stop and start the database to see if I can get an exclusive lock, unless you know of a better way.
 
BTW, I would recommend *not* making schema changes with SQL. Use the data dictionary. You will be much happier in the end.
 
SQL is NOT the native way to interact with OpenEdge. I don't have the experience myself, since I don't do it, but I believe that one can have issues trying to access SQL-created fields/tables from ABL. Among other things, one I do have experience with, SQL DDL does not have a perfect match to OpenEdge datatypes. With practice, one can sometimes find the right thing, but it isn't always obvious.
 
Back
Top