Hi all,

Anybody can tell me if informix allow lock more than one database same time.

Thank you for you help.

A database can be opened in locked mode with the SQL statement but in an interactive session you will first have to close the current database. I presume in an application you can make multiple connections to databases and lock them with this statement. Keep in mind that for opening a database in locked mode no other connection to that database may exist at the time.

Regards