SET LOCK MODE TO WAIT ?

Posted in 1995

J. David Schronce — Thu, 13 Jul 95 11:40:38 EDT — source: Informix-list mailing list archive (1991-1998)

In a recent mail exchange with another Informix programmer, he mentioned that it was possible to use "SET LOCK MODE TO WAIT 60" and have the system time out after the table was unavailable for 60 seconds. I've been digging through the documentation and can find nothing to support his claim. If true it would be a godsend for handling potential permanent lockups. Can anyone confirm or deny that a wait period can be specified as a parameter to SET LOCK MODE TO WAIT and if so, what is the default? Thanks! __ _ _ __ _ >> | \\ __ ___ ___ __| | / _| __| |_ _ _ ___ _ _ __ ___ << | | / _' \\ ' | / _' | \\_ \\/ _| ' \\| '_/ _ \\ ' \\/ _/ -_) C|~~| |__/\\__,_|\\_/|_\\__,_| |__/\\__|_||_|_| \\___/_||_\\__\\___| `--'