Change Width Field - Db Online

[balta]

Good afternoon,

It is possible to change a width of a field with the db online?

Windows, OE 11.6.4/OE11.7.8

Thanks
Baltazar

 

[Rob Fitzpatrick]

It is possible to change a field format online but you require an exclusive schema lock to do so. The error 2623 is telling you that you can't do this currently because user 72 has a schema lock.

 

[balta]

So i have to shutdown/start the DB and do the change?

 

[Rob Fitzpatrick]

So i have to shutdown/start the DB and do the change?

No, that's a little drastic. If user 72 disconnects, the schema lock will be available for you.

 

[balta]

I have a lot of users.

I can add fields online, should be possible to do some "basic" operations with DB Online.

 

[Rob Fitzpatrick]

I can add fields online, should be possible to do some "basic" operations with DB Online.

Absolutely.

Feel free to log in with your Progress ID to the OpenEdge Ideas portal and let product management hear your voice!
https://openedge.ideas.aha.io