[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Any proactive schema lock for exclusive access to perform database changes (SQL92 DDL)?

[George Potemkin]

I'm not sure if the trick can be used by SQL client but 4GL can get an exclusive schema lock by the following code: DO TRANSACTION: CREATE _File. MESSAGE "Schema is locked" VIEW-AS ALERT-BOX. UNDO. END. promon/R&D/1/19 shows: 11/15/19 Status: Schema Locks & Wait Queue by user number for all tenants 14:46:43 Usr:Ten Name Domain Locked Queued 5 0 SHR 5 0 EXCL Total Locks Granted - SHR: 1 EXCL: 1

Continue reading...