Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unlock table

Status
Not open for further replies.
coquito65

coquito65

Programmer
Joined
Jul 6, 2004
Messages
9
Location
MX
Hello everybody ¡

Is there any form to unlock a table ?

Thank you very much ¡

Jorge
 
Sort by date Sort by votes
Hi,

If your session has locked the table, you can say:
UNLOCK TABLE table-name;

A table can also be unlocked by closing an active transaction, via COMMIT WORK or ROLLBACK WORK statement.

Regards,
Shriyan
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

evgeniosc
  • Locked
  • Question Question
Copy rows as they inserted on a replica table using trigger
Replies
0
Views
452
evgeniosc
evgeniosc
KaronW
  • Locked
  • Question Question
Do multiple "case" lines run against each line or is each run against the table ?
Replies
0
Views
420
KaronW
KaronW
marcq
  • Locked
  • Question Question
Table space usage vs tables
Replies
0
Views
264
marcq
marcq
aft5425
  • Locked
  • Question Question
Avoid duplicates on phn_nbr while joining a table to itself
Replies
1
Views
291
PHV
PHV
MJB01
  • Locked
  • Question Question
Informix - find out if a temp table exists
Replies
0
Views
302
MJB01
MJB01

Part and Inventory Search

Sponsor

Back
Top