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 TouchToneTommy 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
Jul 6, 2004
9
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
Copy rows as they inserted on a replica table using trigger
Replies
0
Views
94
evgeniosc
evgeniosc
KaronW
  • Locked
  • Question
Do multiple "case" lines run against each line or is each run against the table ?
Replies
0
Views
87
KaronW
KaronW
marcq
  • Locked
  • Question
Table space usage vs tables
Replies
0
Views
44
marcq
marcq
aft5425
  • Locked
  • Question
Avoid duplicates on phn_nbr while joining a table to itself
Replies
1
Views
66
PHV
PHV
MJB01
  • Locked
  • Question
Informix - find out if a temp table exists
Replies
0
Views
69
MJB01
MJB01

Part and Inventory Search

Sponsor

Back
Top